TYPE=VIEW
query=select `v`.`cash_acc` AS `acc_no`,`la`.`name` AS `name`,`v`.`cr` AS `CASH`,\'0\' AS `TRAN`,`v`.`date` AS `date`,`v`.`sub_head` AS `sub_head` from (`co-operativebank-mohati`.`voucher` `v` join `co-operativebank-mohati`.`loan_account` `la`) where ((`v`.`cash_acc` = `la`.`acc_no`) and (`v`.`head` > 50000) and (`v`.`sub_head` = \'52215\') and (`v`.`date` = \'2017-09-01\') and (`v`.`deposit_type` = \'CASH\') and (`v`.`cr` <> \'0\')) group by `v`.`cash_acc` union all select `v`.`cash_acc` AS `acc_no`,`la`.`name` AS `name`,\'0\' AS `0`,sum(`v`.`cr`) AS `TRAN`,`v`.`date` AS `date`,`v`.`sub_head` AS `sub_head` from (`co-operativebank-mohati`.`voucher` `v` join `co-operativebank-mohati`.`loan_account` `la`) where ((`v`.`cash_acc` = `la`.`acc_no`) and (`v`.`head` > 50000) and (`v`.`sub_head` = \'52215\') and (`v`.`date` = \'2017-09-01\') and (`v`.`deposit_type` = \'TRANSFER\') and (`v`.`cr` <> \'0\')) group by `v`.`cash_acc`
md5=108555ebb7d70e2b76b7c491187d489d
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=1
with_check_option=0
timestamp=2020-10-16 13:11:12
create-version=1
source=select  `v`.`cash_acc`  AS  `acc_no` ,\n `la`.`name`  AS  `name` ,\n `v`.`cr`  AS  `CASH` ,\n \'0\' AS  `TRAN` ,\n `v`.`date`  AS  `date` ,\n `v`.`sub_head`  AS  `sub_head`  from (  `co-operativebank-mohati`.`voucher`  `v`  join  `co-operativebank-mohati`.`loan_account`  `la`  ) where ( (  `v`.`cash_acc`  =  `la`.`acc_no`  ) and (  `v`.`head`  >50000 ) and (  `v`.`sub_head`  =  \'52215\' ) and (  `v`.`date`  =  \'2017-09-01\' ) and (  `v`.`deposit_type`  =  \'CASH\' ) and (  `v`.`cr`  <>  \'0\' ) ) group  by  `v`.`cash_acc`  union  all  select  `v`.`cash_acc`  AS  `acc_no` ,\n `la`.`name`  AS  `name` ,\n \'0\' AS  `0` ,\nsum(  `v`.`cr`  )  AS  `TRAN` ,\n `v`.`date`  AS  `date` ,\n `v`.`sub_head`  AS  `sub_head`  from (  `co-operativebank-mohati`.`voucher`  `v`  join  `co-operativebank-mohati`.`loan_account`  `la`  ) where ( (  `v`.`cash_acc`  =  `la`.`acc_no`  ) and (  `v`.`head`  >50000 ) and (  `v`.`sub_head`  =  \'52215\' ) and (  `v`.`date`  =  \'2017-09-01\' ) and (  `v`.`deposit_type`  =  \'TRANSFER\' ) and (  `v`.`cr`  <>  \'0\' ) ) group  by  `v`.`cash_acc`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`cash_acc` AS `acc_no`,`la`.`name` AS `name`,`v`.`cr` AS `CASH`,\'0\' AS `TRAN`,`v`.`date` AS `date`,`v`.`sub_head` AS `sub_head` from (`co-operativebank-mohati`.`voucher` `v` join `co-operativebank-mohati`.`loan_account` `la`) where ((`v`.`cash_acc` = `la`.`acc_no`) and (`v`.`head` > 50000) and (`v`.`sub_head` = \'52215\') and (`v`.`date` = \'2017-09-01\') and (`v`.`deposit_type` = \'CASH\') and (`v`.`cr` <> \'0\')) group by `v`.`cash_acc` union all select `v`.`cash_acc` AS `acc_no`,`la`.`name` AS `name`,\'0\' AS `0`,sum(`v`.`cr`) AS `TRAN`,`v`.`date` AS `date`,`v`.`sub_head` AS `sub_head` from (`co-operativebank-mohati`.`voucher` `v` join `co-operativebank-mohati`.`loan_account` `la`) where ((`v`.`cash_acc` = `la`.`acc_no`) and (`v`.`head` > 50000) and (`v`.`sub_head` = \'52215\') and (`v`.`date` = \'2017-09-01\') and (`v`.`deposit_type` = \'TRANSFER\') and (`v`.`cr` <> \'0\')) group by `v`.`cash_acc`
