TYPE=VIEW
query=select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,concat(`v`.`lfnof`,\'\',`v`.`vch_type`,\' \',if((`d`.`cheque_acc_no` = \'\'),`d`.`cheque_no`,`d`.`cheque_acc_no`)) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`d`.`Deposited_by` AS `depo_by`,`v`.`user_code` AS `user_code` from `co-operativebank-henria`.`voucher` `v` join `co-operativebank-henria`.`deposit` `d` where ((`v`.`Acc_no` = \'106103000203\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2009-12-17\') and (`v`.`date` <= \'2021-12-17\') and (`v`.`cr` > 0)) group by `v`.`no` union all select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,concat(`v`.`vch_type`,\' \',if((`w`.`cheque_no` = \'\'),`w`.`trnsfer_acc`,`w`.`cheque_no`)) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`w`.`Withdrawn_by` AS `depo_by`,`v`.`user_code` AS `user_code` from `co-operativebank-henria`.`voucher` `v` join `co-operativebank-henria`.`withdrawl` `w` where ((`v`.`Acc_no` = \'106103000203\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2009-12-17\') and (`v`.`date` <= \'2021-12-17\') and (`v`.`dr` > 0)) group by `v`.`no`
md5=5591cc3316c0ecb94d4f7d1dc910f7ca
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2021-12-17 04:52:04
create-version=1
source=SELECT v.vch_no,v.no,v.date,v.Acc_no,concat(lfnof,\'\',v.vch_type,\' \',if(d.cheque_acc_no=\'\',d.cheque_no,d.cheque_acc_no)) vch_type,v.Dr,v.Cr,d.Deposited_by as depo_by,v.user_code FROM `voucher` v, deposit d WHERE v.acc_no=\'106103000203\' and v.vch_no=d.shilp and v.date=d.date and v.acc_no=d.acc_no and v.date>=\'2009-12-17\' and v.date<=\'2021-12-17\' and cr>0 group by no union all select v.vch_no,v.no,v.date,v.Acc_no,concat(v.vch_type,\' \',if(w.cheque_no=\'\', w.trnsfer_acc,w.cheque_no)) as vch_type,v.Dr,v.Cr,w.Withdrawn_by as depo_by,v.user_code FROM `voucher` v,withdrawl w where v.acc_no=\'106103000203\' and v.vch_no=w.slip_no and v.acc_no=w.acc_no and v.date>=\'2009-12-17\' and v.date<=\'2021-12-17\' and dr>0 group by no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,concat(`v`.`lfnof`,\'\',`v`.`vch_type`,\' \',if((`d`.`cheque_acc_no` = \'\'),`d`.`cheque_no`,`d`.`cheque_acc_no`)) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`d`.`Deposited_by` AS `depo_by`,`v`.`user_code` AS `user_code` from `co-operativebank-henria`.`voucher` `v` join `co-operativebank-henria`.`deposit` `d` where ((`v`.`Acc_no` = \'106103000203\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2009-12-17\') and (`v`.`date` <= \'2021-12-17\') and (`v`.`cr` > 0)) group by `v`.`no` union all select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,concat(`v`.`vch_type`,\' \',if((`w`.`cheque_no` = \'\'),`w`.`trnsfer_acc`,`w`.`cheque_no`)) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`w`.`Withdrawn_by` AS `depo_by`,`v`.`user_code` AS `user_code` from `co-operativebank-henria`.`voucher` `v` join `co-operativebank-henria`.`withdrawl` `w` where ((`v`.`Acc_no` = \'106103000203\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2009-12-17\') and (`v`.`date` <= \'2021-12-17\') and (`v`.`dr` > 0)) group by `v`.`no`
