TYPE=VIEW
query=select `v`.`acc_no` AS `acc_no`,`q`.`sbacc` AS `sbacc`,sum(`v`.`bal`) AS `bal` from `co-operativebank`.`acc_bal` `v` join `co-operativebank`.`quick_name` `q` where ((`q`.`acc_no` = `v`.`acc_no`) and ((`v`.`head` = \'23100\') or (`v`.`head` = \'23200\')) and (`v`.`acc_no` <> \'\')) group by `q`.`sbacc`
md5=53a878d92893399257dea6e721705f87
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2018-05-19 04:48:37
create-version=1
source=SELECT v.acc_no,sbacc, sum(bal) as bal FROM `acc_bal` v,quick_name q WHERE q.acc_no=v.acc_no and (head=\'23100\' or head=\'23200\') and v.acc_no<>\'\' group by sbacc
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`acc_no` AS `acc_no`,`q`.`sbacc` AS `sbacc`,sum(`v`.`bal`) AS `bal` from `co-operativebank`.`acc_bal` `v` join `co-operativebank`.`quick_name` `q` where ((`q`.`acc_no` = `v`.`acc_no`) and ((`v`.`head` = \'23100\') or (`v`.`head` = \'23200\')) and (`v`.`acc_no` <> \'\')) group by `q`.`sbacc`
