TYPE=VIEW
query=select `v`.`no` AS `no`,`v`.`cash_acc` AS `acc_no`,`la`.`name` AS `name`,`la`.`lfno` AS `lfno`,sum(`v`.`cr`) AS `CASH`,\'0\' AS `TRAN`,`v`.`date` AS `date`,`v`.`sub_head` AS `sub_head` from `co-operativebank-mohati`.`voucher` `v` USE INDEX (`by_sub_head`) USE INDEX (`by_date`) USE INDEX (`by_cash_acc`) USE INDEX (`by_acc_no`) join `co-operativebank-mohati`.`quick_name` `la` USE INDEX (`by_acc_no`) where (((`v`.`cash_acc` = `la`.`acc_no`) or (`v`.`Acc_no` = `la`.`acc_no`)) and (`v`.`head` > 40000) and (`v`.`sub_head` = \'52101A\') and (`v`.`date` = \'2025-09-01\') and (`v`.`deposit_type` = \'CASH\') and (`v`.`cr` <> \'0\')) group by `v`.`cash_acc`,`v`.`Acc_no` union all select `v`.`no` AS `no`,`v`.`cash_acc` AS `acc_no`,`la`.`name` AS `name`,`la`.`lfno` AS `lfno`,\'0\' AS `0`,sum(`v`.`cr`) AS `TRAN`,`v`.`date` AS `date`,`v`.`sub_head` AS `sub_head` from `co-operativebank-mohati`.`voucher` `v` USE INDEX (`by_sub_head`) USE INDEX (`by_date`) USE INDEX (`by_cash_acc`) USE INDEX (`by_acc_no`) join `co-operativebank-mohati`.`quick_name` `la` USE INDEX (`by_acc_no`) where (((`v`.`cash_acc` = `la`.`acc_no`) or (`v`.`Acc_no` = `la`.`acc_no`)) and (`v`.`head` > 40000) and (`v`.`sub_head` = \'52101A\') and (`v`.`date` = \'2025-09-01\') and (`v`.`deposit_type` = \'TRANSFER\') and (`v`.`cr` <> \'0\')) group by `v`.`cash_acc`,`v`.`Acc_no`
md5=ccd9126beda5ccf578fb28dde3af48a7
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-09-01 12:03:48
create-version=1
source=select v.no,v.cash_acc as acc_no,LA.name,lfno,sum(V.cr) as CASH,\'0\' as TRAN,V.date,v.sub_head from voucher v USE INDEX (by_acc_no,by_cash_acc,by_date,by_sub_head),quick_name la USE INDEX (by_acc_no) where (v.cash_acc=la.acc_no or v.acc_no=la.acc_no) and v.head>40000 and v.sub_head=\'52101A\' and v.date=\'2025-09-01\' AND DEPOSIT_TYPE=\'CASH\' AND cR<>\'0\' group by v.cash_acc,v.acc_no  UNION ALL select v.no,v.cash_acc as acc_no,LA.name,lfno,\'0\',sum(V.cr) as TRAN,V.date,v.sub_head from voucher v USE INDEX (by_acc_no,by_cash_acc,by_date,by_sub_head),quick_name la USE INDEX (by_acc_no) where (v.cash_acc=la.acc_no or v.acc_no=la.acc_no) and v.head>40000 and v.sub_head=\'52101A\' and v.date=\'2025-09-01\' AND DEPOSIT_TYPE=\'TRANSFER\' AND cR<>\'0\' group by v.cash_acc,v.acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`no` AS `no`,`v`.`cash_acc` AS `acc_no`,`la`.`name` AS `name`,`la`.`lfno` AS `lfno`,sum(`v`.`cr`) AS `CASH`,\'0\' AS `TRAN`,`v`.`date` AS `date`,`v`.`sub_head` AS `sub_head` from `co-operativebank-mohati`.`voucher` `v` USE INDEX (`by_sub_head`) USE INDEX (`by_date`) USE INDEX (`by_cash_acc`) USE INDEX (`by_acc_no`) join `co-operativebank-mohati`.`quick_name` `la` USE INDEX (`by_acc_no`) where (((`v`.`cash_acc` = `la`.`acc_no`) or (`v`.`Acc_no` = `la`.`acc_no`)) and (`v`.`head` > 40000) and (`v`.`sub_head` = \'52101A\') and (`v`.`date` = \'2025-09-01\') and (`v`.`deposit_type` = \'CASH\') and (`v`.`cr` <> \'0\')) group by `v`.`cash_acc`,`v`.`Acc_no` union all select `v`.`no` AS `no`,`v`.`cash_acc` AS `acc_no`,`la`.`name` AS `name`,`la`.`lfno` AS `lfno`,\'0\' AS `0`,sum(`v`.`cr`) AS `TRAN`,`v`.`date` AS `date`,`v`.`sub_head` AS `sub_head` from `co-operativebank-mohati`.`voucher` `v` USE INDEX (`by_sub_head`) USE INDEX (`by_date`) USE INDEX (`by_cash_acc`) USE INDEX (`by_acc_no`) join `co-operativebank-mohati`.`quick_name` `la` USE INDEX (`by_acc_no`) where (((`v`.`cash_acc` = `la`.`acc_no`) or (`v`.`Acc_no` = `la`.`acc_no`)) and (`v`.`head` > 40000) and (`v`.`sub_head` = \'52101A\') and (`v`.`date` = \'2025-09-01\') and (`v`.`deposit_type` = \'TRANSFER\') and (`v`.`cr` <> \'0\')) group by `v`.`cash_acc`,`v`.`Acc_no`
