TYPE=VIEW
query=select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,sum(`v1`.`dr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`head` AS `sub_head` from `co-operativebank-keshabchak`.`voucher` `v1` USE INDEX (`by_sub_head`) USE INDEX (`by_acc_no`) join `co-operativebank-keshabchak`.`shares` `s` USE INDEX (`by_code`) join `co-operativebank-keshabchak`.`quick_name` `a` USE INDEX (`by_acc_no`) where ((`v1`.`Acc_no` = `s`.`code`) and (`s`.`acc_no` = `a`.`acc_no`) and (`v1`.`head` = \'11200\') and (`v1`.`date` = \'2021-03-31\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`dr` <> \'0\')) group by `v1`.`Acc_no` union all select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,\'0\' AS `0`,sum(`v1`.`dr`) AS `TRAN`,`v1`.`date` AS `date`,`v1`.`head` AS `sub_head` from `co-operativebank-keshabchak`.`voucher` `v1` USE INDEX (`by_sub_head`) USE INDEX (`by_acc_no`) join `co-operativebank-keshabchak`.`shares` `s` USE INDEX (`by_code`) join `co-operativebank-keshabchak`.`quick_name` `a` USE INDEX (`by_acc_no`) where ((`v1`.`Acc_no` = `s`.`code`) and (`s`.`acc_no` = `a`.`acc_no`) and (`v1`.`head` = \'11200\') and (`v1`.`date` = \'2021-03-31\') and (`v1`.`deposit_type` = \'TRANSFER\') and (`v1`.`dr` <> \'0\')) group by `v1`.`Acc_no`
md5=451fe70797a0d8c928ede0e612b64ad7
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2021-11-04 10:32:10
create-version=1
source=select v1.no,v1.acc_no,a.name,lfno,sum(dr) as CASH,\'0\' as TRAN,V1.date,v1.head as sub_head from voucher v1 USE INDEX (by_acc_no,by_sub_head),shares s USE INDEX (by_code),quick_name a USE INDEX (by_acc_no) where  v1.acc_no=s.code and s.acc_no=a.acc_no and v1.head=\'11200\' and v1.date=\'2021-03-31\' AND DEPOSIT_TYPE=\'CASH\' and dr<>\'0\' group by v1.acc_no  UNION ALL select v1.no,v1.acc_no,a.name,lfno,\'0\',sum(dr) as TRAN,V1.date,v1.head as sub_head from voucher v1 USE INDEX (by_acc_no,by_sub_head),shares s USE INDEX (by_code),quick_name a USE INDEX (by_acc_no) where v1.acc_no=s.code and s.acc_no=a.acc_no and v1.head=\'11200\' and v1.date=\'2021-03-31\' AND DEPOSIT_TYPE=\'TRANSFER\' and dr<>\'0\' group by v1.acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,sum(`v1`.`dr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`head` AS `sub_head` from `co-operativebank-keshabchak`.`voucher` `v1` USE INDEX (`by_sub_head`) USE INDEX (`by_acc_no`) join `co-operativebank-keshabchak`.`shares` `s` USE INDEX (`by_code`) join `co-operativebank-keshabchak`.`quick_name` `a` USE INDEX (`by_acc_no`) where ((`v1`.`Acc_no` = `s`.`code`) and (`s`.`acc_no` = `a`.`acc_no`) and (`v1`.`head` = \'11200\') and (`v1`.`date` = \'2021-03-31\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`dr` <> \'0\')) group by `v1`.`Acc_no` union all select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,\'0\' AS `0`,sum(`v1`.`dr`) AS `TRAN`,`v1`.`date` AS `date`,`v1`.`head` AS `sub_head` from `co-operativebank-keshabchak`.`voucher` `v1` USE INDEX (`by_sub_head`) USE INDEX (`by_acc_no`) join `co-operativebank-keshabchak`.`shares` `s` USE INDEX (`by_code`) join `co-operativebank-keshabchak`.`quick_name` `a` USE INDEX (`by_acc_no`) where ((`v1`.`Acc_no` = `s`.`code`) and (`s`.`acc_no` = `a`.`acc_no`) and (`v1`.`head` = \'11200\') and (`v1`.`date` = \'2021-03-31\') and (`v1`.`deposit_type` = \'TRANSFER\') and (`v1`.`dr` <> \'0\')) group by `v1`.`Acc_no`
