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` from `co-operativebank-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`mstr_bnk_deposit` `d` where ((`v`.`Acc_no` = \'604090068786\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2024-04-01\') and (`v`.`date` <= \'2025-05-18\')) 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`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr` from `co-operativebank-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`mstr_bnk_withdrawl` `w` where ((`v`.`Acc_no` = \'604090068786\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2024-04-01\') and (`v`.`date` <= \'2025-05-18\')) 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` from `co-operativebank-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`mstr_shear` `s` where ((`s`.`code` = `v`.`Acc_no`) and (`v`.`date` >= \'2024-04-01\') and (`v`.`date` <= \'2025-05-18\') and (`s`.`code` = \'604090068786\')) group by `v`.`vch_no`
md5=faf4e368e0ffe787ede4f35e97665a46
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-05-18 12:00:39
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 FROM `voucher` v, mstr_bnk_deposit d WHERE v.acc_no=\'604090068786\' and v.vch_no=d.shilp and v.date=d.date and v.acc_no=d.acc_no and v.date>=\'2024-04-01\' and v.date<=\'2025-05-18\' 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) AS vch_type,v.Dr,v.Cr FROM `voucher` v,mstr_bnk_withdrawl w where v.acc_no=\'604090068786\' and v.vch_no=w.slip_no and v.acc_no=w.acc_no and v.date>=\'2024-04-01\' and v.date<=\'2025-05-18\' 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 FROM `voucher` v,mstr_shear s where s.code=v.acc_no and  v.date>=\'2024-04-01\' and v.date<=\'2025-05-18\' and s.code=\'604090068786\' group by v.vch_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`,\' \',`d`.`cheque_acc_no`,\' \',`d`.`cheque_no`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr` from `co-operativebank-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`mstr_bnk_deposit` `d` where ((`v`.`Acc_no` = \'604090068786\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2024-04-01\') and (`v`.`date` <= \'2025-05-18\')) 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`) AS `vch_type`,`v`.`dr` AS `Dr`,`v`.`cr` AS `Cr` from `co-operativebank-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`mstr_bnk_withdrawl` `w` where ((`v`.`Acc_no` = \'604090068786\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2024-04-01\') and (`v`.`date` <= \'2025-05-18\')) 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` from `co-operativebank-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`mstr_shear` `s` where ((`s`.`code` = `v`.`Acc_no`) and (`v`.`date` >= \'2024-04-01\') and (`v`.`date` <= \'2025-05-18\') and (`s`.`code` = \'604090068786\')) group by `v`.`vch_no`
