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`.`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` from `co-club`.`voucher` `v` join `co-club`.`deposit` `d` where ((`v`.`Acc_no` = \'01SH01001427\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2000-04-01\') and (`v`.`date` <= \'2019-03-23\') 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` from `co-club`.`voucher` `v` join `co-club`.`withdrawl` `w` where ((`v`.`Acc_no` = \'01SH01001427\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2000-04-01\') and (`v`.`date` <= \'2019-03-23\') and (`v`.`dr` > 0)) group by `v`.`no`
md5=0cae6fa54ab00c561df65cabb252acf5
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2019-03-23 12:46:50
create-version=1
source=SELECT v.vch_no,v.no,v.date,v.Acc_no,concat(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 FROM `voucher` v, deposit d WHERE v.acc_no=\'01SH01001427\' and v.vch_no=d.shilp and v.date=d.date and v.acc_no=d.acc_no and v.date>=\'2000-04-01\' and v.date<=\'2019-03-23\' 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 FROM `voucher` v,withdrawl w where v.acc_no=\'01SH01001427\' and v.vch_no=w.slip_no and v.acc_no=w.acc_no and v.date>=\'2000-04-01\' and v.date<=\'2019-03-23\' 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`.`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` from `co-club`.`voucher` `v` join `co-club`.`deposit` `d` where ((`v`.`Acc_no` = \'01SH01001427\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2000-04-01\') and (`v`.`date` <= \'2019-03-23\') 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` from `co-club`.`voucher` `v` join `co-club`.`withdrawl` `w` where ((`v`.`Acc_no` = \'01SH01001427\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2000-04-01\') and (`v`.`date` <= \'2019-03-23\') and (`v`.`dr` > 0)) group by `v`.`no`
