TYPE=VIEW
query=select `so`.`code` AS `code`,`s`.`acc_no` AS `acc_no`,(select sum(`so2`.`mesurement`) from `co-operativebank`.`share_object` `so2` where ((`so2`.`sub_head` = \'23101A\') and (`so`.`code` = `so2`.`code`)) group by `so2`.`sub_head`) AS `Rabi`,(select sum(`so3`.`mesurement`) from `co-operativebank`.`share_object` `so3` where ((`so3`.`sub_head` = \'23101B\') and (`so`.`code` = `so3`.`code`)) group by `so3`.`sub_head`) AS `Kharif` from `co-operativebank`.`share_object` `so` join `co-operativebank`.`shares` `s` where (`s`.`code` = `so`.`code`) group by `so`.`code`
md5=8f96edab620a437d7b33811a4b446147
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2018-05-19 04:39:56
create-version=1
source=select `so`.`code` AS `code`,s.acc_no,(select sum(`so2`.`mesurement`) from `share_object` `so2` where ((`so2`.`sub_head` = \'23101A\') and (`so`.`code` = `so2`.`code`)) group by `so2`.`sub_head`) AS `Rabi`,(select sum(`so3`.`mesurement`) from `share_object` `so3` where ((`so3`.`sub_head` = \'23101B\') and (`so`.`code` = `so3`.`code`)) group by `so3`.`sub_head`) AS `Kharif` from `share_object` `so`,shares s where s.code=so.code group by `so`.`code`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `so`.`code` AS `code`,`s`.`acc_no` AS `acc_no`,(select sum(`so2`.`mesurement`) from `co-operativebank`.`share_object` `so2` where ((`so2`.`sub_head` = \'23101A\') and (`so`.`code` = `so2`.`code`)) group by `so2`.`sub_head`) AS `Rabi`,(select sum(`so3`.`mesurement`) from `co-operativebank`.`share_object` `so3` where ((`so3`.`sub_head` = \'23101B\') and (`so`.`code` = `so3`.`code`)) group by `so3`.`sub_head`) AS `Kharif` from `co-operativebank`.`share_object` `so` join `co-operativebank`.`shares` `s` where (`s`.`code` = `so`.`code`) group by `so`.`code`
