TYPE=VIEW
query=select `so`.`code` AS `code`,`s`.`acc_no` AS `acc_no`,(select sum(`so2`.`mesurement`) from `co-operativebank-henria`.`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-henria`.`share_object` `so3` where ((`so3`.`sub_head` = \'23101B\') and (`so`.`code` = `so3`.`code`)) group by `so3`.`sub_head`) AS `Kharif` from (`co-operativebank-henria`.`share_object` `so` join `co-operativebank-henria`.`shares` `s`) where (`s`.`code` = `so`.`code`) group by `so`.`code`
md5=c843f8614e9d781bbd2c739808f85644
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2021-07-15 17:05:35
create-version=1
source=select  `so`.`code`  AS  `code` ,\n `s`.`acc_no`  AS  `acc_no` ,\n(  select sum(  `so2`.`mesurement`  )  from  `co-operativebank-henria`.`share_object`  `so2`  where ( (  `so2`.`sub_head`  =  \'23101A\' ) and (  `so`.`code`  =  `so2`.`code`  ) ) group  by  `so2`.`sub_head`  ) AS  `Rabi` ,\n(  select sum(  `so3`.`mesurement`  )  from  `co-operativebank-henria`.`share_object`  `so3`  where ( (  `so3`.`sub_head`  =  \'23101B\' ) and (  `so`.`code`  =  `so3`.`code`  ) ) group  by  `so3`.`sub_head`  ) AS  `Kharif`  from (  `co-operativebank-henria`.`share_object`  `so`  join  `co-operativebank-henria`.`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-henria`.`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-henria`.`share_object` `so3` where ((`so3`.`sub_head` = \'23101B\') and (`so`.`code` = `so3`.`code`)) group by `so3`.`sub_head`) AS `Kharif` from (`co-operativebank-henria`.`share_object` `so` join `co-operativebank-henria`.`shares` `s`) where (`s`.`code` = `so`.`code`) group by `so`.`code`
