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`,\' \',`d`.`cheque_acc_no`,\' \',`d`.`cheque_no`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`d`.`Deposited_by` AS `depo_by` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`deposit` `d` where ((`v`.`Acc_no` = \'010001\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2017-12-22\') and (`v`.`date` <= \'2017-12-22\')) group by `v`.`vch_no`,`v`.`vch_type`,`v`.`date`,`d`.`Amt` 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`,\' \',`w`.`cheque_no`,\' \',`w`.`trnsfer_acc`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`w`.`Withdrawn_by` AS `depo_by` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`withdrawl` `w` where ((`v`.`Acc_no` = \'010001\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2017-12-22\') and (`v`.`date` <= \'2017-12-22\')) group by `v`.`vch_no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt` union all select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,`v`.`vch_type` AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,\'\' AS `depo_by` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`shares` `s` where ((`s`.`code` = `v`.`Acc_no`) and (`v`.`date` >= \'2017-12-22\') and (`v`.`date` <= \'2017-12-22\') and (`s`.`code` = \'010001\')) group by `v`.`vch_no`
md5=dc463c2ad5f23682c244fd1c367b34e4
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2017-12-22 04:21:51
create-version=1
source=SELECT v.vch_no,v.no,v.date,v.Acc_no,concat(v.vch_type,\' \',d.cheque_acc_no,\' \',d.cheque_no) vch_type,v.Dr,v.Cr,d.Deposited_by as depo_by FROM `voucher` v, deposit d WHERE v.acc_no=\'010001\' and v.vch_no=d.shilp and v.date=d.date and v.acc_no=d.acc_no and v.date>=\'2017-12-22\' and v.date<=\'2017-12-22\' group by v.vch_no,vch_type,date,amt union all select v.vch_no,v.no,v.date,v.Acc_no,concat(v.vch_type,\' \',w.cheque_no,\' \', w.trnsfer_acc) as vch_type,v.Dr,v.Cr,w.Withdrawn_by as depo_by FROM `voucher` v,withdrawl w where v.acc_no=\'010001\' and v.vch_no=w.slip_no and v.acc_no=w.acc_no and v.date>=\'2017-12-22\' and v.date<=\'2017-12-22\' group by v.vch_no,vch_type,date,amt union all select v.vch_no,v.no,v.date,v.Acc_no,v.vch_type,v.Dr,v.Cr, \'\' as depo_by FROM `voucher` v,shares s where s.code=v.acc_no and  v.date>=\'2017-12-22\' and v.date<=\'2017-12-22\' and s.code=\'010001\' group by v.vch_no
client_cs_name=latin1
connection_cl_name=latin1_swedish_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`,\' \',`d`.`cheque_acc_no`,\' \',`d`.`cheque_no`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`d`.`Deposited_by` AS `depo_by` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`deposit` `d` where ((`v`.`Acc_no` = \'010001\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2017-12-22\') and (`v`.`date` <= \'2017-12-22\')) group by `v`.`vch_no`,`v`.`vch_type`,`v`.`date`,`d`.`Amt` 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`,\' \',`w`.`cheque_no`,\' \',`w`.`trnsfer_acc`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,`w`.`Withdrawn_by` AS `depo_by` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`withdrawl` `w` where ((`v`.`Acc_no` = \'010001\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2017-12-22\') and (`v`.`date` <= \'2017-12-22\')) group by `v`.`vch_no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt` union all select `v`.`vch_no` AS `vch_no`,`v`.`no` AS `no`,`v`.`date` AS `date`,`v`.`Acc_no` AS `Acc_no`,`v`.`vch_type` AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr`,\'\' AS `depo_by` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`shares` `s` where ((`s`.`code` = `v`.`Acc_no`) and (`v`.`date` >= \'2017-12-22\') and (`v`.`date` <= \'2017-12-22\') and (`s`.`code` = \'010001\')) group by `v`.`vch_no`
