TYPE=VIEW
query=select `v1`.`Acc_no` AS `acc_no`,`sh`.`sub_head` AS `name`,sum(`v1`.`cr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-124`.`voucher` `v1` join `co-operativebank-124`.`sub_head` `sh`) where ((`v1`.`sub_head` = `sh`.`code`) and (`v1`.`sub_head` = \'28202\') and (`v1`.`date` = \'2017-11-01\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`cr` <> \'0\')) group by `v1`.`Acc_no` union all select `v1`.`Acc_no` AS `acc_no`,`sh`.`sub_head` AS `name`,\'0\' AS `0`,sum(`v1`.`cr`) AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-124`.`voucher` `v1` join `co-operativebank-124`.`sub_head` `sh`) where ((`v1`.`sub_head` = `sh`.`code`) and (`v1`.`sub_head` = \'28202\') and (`v1`.`date` = \'2017-11-01\') and (`v1`.`deposit_type` = \'TRANSFER\') and (`v1`.`cr` <> \'0\')) group by `v1`.`Acc_no`
md5=f41aa86c94a967c4731d2f6060a27c74
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-10-26 06:26:40
create-version=1
source=select  `v1`.`Acc_no`  AS  `acc_no` ,\n `sh`.`sub_head`  AS  `name` ,\nsum(  `v1`.`cr`  )  AS  `CASH` ,\n \'0\' AS  `TRAN` ,\n `v1`.`date`  AS  `date` ,\n `v1`.`sub_head`  AS  `sub_head`  from (  `co-operativebank-124`.`voucher`  `v1`  join  `co-operativebank-124`.`sub_head`  `sh`  ) where ( (  `v1`.`sub_head`  =  `sh`.`code`  ) and (  `v1`.`sub_head`  =  \'28202\' ) and (  `v1`.`date`  =  \'2017-11-01\' ) and (  `v1`.`deposit_type`  =  \'CASH\' ) and (  `v1`.`cr`  <>  \'0\' ) ) group  by  `v1`.`Acc_no`  union  all  select  `v1`.`Acc_no`  AS  `acc_no` ,\n `sh`.`sub_head`  AS  `name` ,\n \'0\' AS  `0` ,\nsum(  `v1`.`cr`  )  AS  `TRAN` ,\n `v1`.`date`  AS  `date` ,\n `v1`.`sub_head`  AS  `sub_head`  from (  `co-operativebank-124`.`voucher`  `v1`  join  `co-operativebank-124`.`sub_head`  `sh`  ) where ( (  `v1`.`sub_head`  =  `sh`.`code`  ) and (  `v1`.`sub_head`  =  \'28202\' ) and (  `v1`.`date`  =  \'2017-11-01\' ) and (  `v1`.`deposit_type`  =  \'TRANSFER\' ) and (  `v1`.`cr`  <>  \'0\' ) ) group  by  `v1`.`Acc_no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v1`.`Acc_no` AS `acc_no`,`sh`.`sub_head` AS `name`,sum(`v1`.`cr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-124`.`voucher` `v1` join `co-operativebank-124`.`sub_head` `sh`) where ((`v1`.`sub_head` = `sh`.`code`) and (`v1`.`sub_head` = \'28202\') and (`v1`.`date` = \'2017-11-01\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`cr` <> \'0\')) group by `v1`.`Acc_no` union all select `v1`.`Acc_no` AS `acc_no`,`sh`.`sub_head` AS `name`,\'0\' AS `0`,sum(`v1`.`cr`) AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-124`.`voucher` `v1` join `co-operativebank-124`.`sub_head` `sh`) where ((`v1`.`sub_head` = `sh`.`code`) and (`v1`.`sub_head` = \'28202\') and (`v1`.`date` = \'2017-11-01\') and (`v1`.`deposit_type` = \'TRANSFER\') and (`v1`.`cr` <> \'0\')) group by `v1`.`Acc_no`
