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-keshabchak`.`voucher` `v` join `co-operativebank-keshabchak`.`deposit` `d`) where ((`v`.`Acc_no` = \'010001001245\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2017-01-01\') and (`v`.`date` <= \'2019-08-01\')) group by `v`.`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`,\' \',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-keshabchak`.`voucher` `v` join `co-operativebank-keshabchak`.`withdrawl` `w`) where ((`v`.`Acc_no` = \'010001001245\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2017-01-01\') and (`v`.`date` <= \'2019-08-01\')) group by `v`.`no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt`
md5=ae0c1f3b22a71e221db47d5275dee88f
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=1
with_check_option=0
timestamp=2021-07-12 04:17:18
create-version=1
source=select  `v`.`vch_no`  AS  `vch_no` ,\n `v`.`no`  AS  `no` ,\n `v`.`date`  AS  `date` ,\n `v`.`Acc_no`  AS  `Acc_no` ,\nconcat(  `v`.`lfnof` ,  \'\',  `v`.`vch_type` ,  \' \', if( (  `d`.`cheque_acc_no`  =  \'\' ),  `d`.`cheque_no` ,  `d`.`cheque_acc_no`  )  )  AS  `vch_type` ,\n `v`.`dr`  AS  `Dr` ,\n `v`.`cr`  AS  `Cr` ,\n `d`.`Deposited_by`  AS  `depo_by` ,\n `v`.`user_code`  AS  `user_code`  from (  `co-operativebank-keshabchak`.`voucher`  `v`  join  `co-operativebank-keshabchak`.`deposit`  `d`  ) where ( (  `v`.`Acc_no`  =  \'010001001245\' ) and (  `v`.`vch_no`  =  `d`.`shilp`  ) and (  `v`.`date`  =  `d`.`Date`  ) and (  `v`.`Acc_no`  =  `d`.`Acc_No`  ) and (  `v`.`date`  >=  \'2017-01-01\' ) and (  `v`.`date`  <=  \'2019-08-01\' ) ) group  by  `v`.`no` ,\n `v`.`vch_type` ,\n `v`.`date` ,\n `d`.`Amt`  union  all  select  `v`.`vch_no`  AS  `vch_no` ,\n `v`.`no`  AS  `no` ,\n `v`.`date`  AS  `date` ,\n `v`.`Acc_no`  AS  `Acc_no` ,\nconcat(  `v`.`vch_type` ,  \' \', if( (  `w`.`cheque_no`  =  \'\' ),  `w`.`trnsfer_acc` ,  `w`.`cheque_no`  )  )  AS  `vch_type` ,\n `v`.`dr`  AS  `Dr` ,\n `v`.`cr`  AS  `Cr` ,\n `w`.`Withdrawn_by`  AS  `depo_by` ,\n `v`.`user_code`  AS  `user_code`  from (  `co-operativebank-keshabchak`.`voucher`  `v`  join  `co-operativebank-keshabchak`.`withdrawl`  `w`  ) where ( (  `v`.`Acc_no`  =  \'010001001245\' ) and (  `v`.`vch_no`  =  `w`.`slip_no`  ) and (  `v`.`Acc_no`  =  `w`.`Acc_no`  ) and (  `v`.`date`  >=  \'2017-01-01\' ) and (  `v`.`date`  <=  \'2019-08-01\' ) ) group  by  `v`.`no` ,\n `v`.`vch_type` ,\n `v`.`date` ,\n `w`.`Amt`
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-keshabchak`.`voucher` `v` join `co-operativebank-keshabchak`.`deposit` `d`) where ((`v`.`Acc_no` = \'010001001245\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2017-01-01\') and (`v`.`date` <= \'2019-08-01\')) group by `v`.`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`,\' \',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-keshabchak`.`voucher` `v` join `co-operativebank-keshabchak`.`withdrawl` `w`) where ((`v`.`Acc_no` = \'010001001245\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2017-01-01\') and (`v`.`date` <= \'2019-08-01\')) group by `v`.`no`,`v`.`vch_type`,`v`.`date`,`w`.`Amt`
