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-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`deposit` `d`) where ((`v`.`Acc_no` = \'01000100303\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2017-11-25\') and (`v`.`date` <= \'2018-01-06\')) 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-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`withdrawl` `w`) where ((`v`.`Acc_no` = \'01000100303\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2017-11-25\') and (`v`.`date` <= \'2018-01-06\')) 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-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`shares` `s`) where ((`s`.`code` = `v`.`Acc_no`) and (`v`.`date` >= \'2017-11-25\') and (`v`.`date` <= \'2018-01-06\') and (`s`.`code` = \'01000100303\')) group by `v`.`vch_no`
md5=5257c418c8cfe6fee8026333a9c8f896
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-05-30 04:21:37
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`.`vch_type` ,  \' \',  `d`.`cheque_acc_no` ,  \' \',  `d`.`cheque_no`  )  AS  `vch_type` ,\n `v`.`dr`  AS  `Dr` ,\n `v`.`cr`  AS  `Cr` ,\n `d`.`Deposited_by`  AS  `depo_by`  from (  `co-operativebank-mitrachak`.`voucher`  `v`  join  `co-operativebank-mitrachak`.`deposit`  `d`  ) where ( (  `v`.`Acc_no`  =  \'01000100303\' ) and (  `v`.`vch_no`  =  `d`.`shilp`  ) and (  `v`.`date`  =  `d`.`Date`  ) and (  `v`.`Acc_no`  =  `d`.`Acc_No`  ) and (  `v`.`date`  >=  \'2017-11-25\' ) and (  `v`.`date`  <=  \'2018-01-06\' ) ) group  by  `v`.`vch_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` ,  \' \',  `w`.`cheque_no` ,  \' \',  `w`.`trnsfer_acc`  )  AS  `vch_type` ,\n `v`.`dr`  AS  `Dr` ,\n `v`.`cr`  AS  `Cr` ,\n `w`.`Withdrawn_by`  AS  `depo_by`  from (  `co-operativebank-mitrachak`.`voucher`  `v`  join  `co-operativebank-mitrachak`.`withdrawl`  `w`  ) where ( (  `v`.`Acc_no`  =  \'01000100303\' ) and (  `v`.`vch_no`  =  `w`.`slip_no`  ) and (  `v`.`Acc_no`  =  `w`.`Acc_no`  ) and (  `v`.`date`  >=  \'2017-11-25\' ) and (  `v`.`date`  <=  \'2018-01-06\' ) ) group  by  `v`.`vch_no` ,\n `v`.`vch_type` ,\n `v`.`date` ,\n `w`.`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` ,\n `v`.`vch_type`  AS  `vch_type` ,\n `v`.`dr`  AS  `Dr` ,\n `v`.`cr`  AS  `Cr` ,\n \'\' AS  `depo_by`  from (  `co-operativebank-mitrachak`.`voucher`  `v`  join  `co-operativebank-mitrachak`.`shares`  `s`  ) where ( (  `s`.`code`  =  `v`.`Acc_no`  ) and (  `v`.`date`  >=  \'2017-11-25\' ) and (  `v`.`date`  <=  \'2018-01-06\' ) and (  `s`.`code`  =  \'01000100303\' ) ) 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`,`d`.`Deposited_by` AS `depo_by` from (`co-operativebank-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`deposit` `d`) where ((`v`.`Acc_no` = \'01000100303\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2017-11-25\') and (`v`.`date` <= \'2018-01-06\')) 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-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`withdrawl` `w`) where ((`v`.`Acc_no` = \'01000100303\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2017-11-25\') and (`v`.`date` <= \'2018-01-06\')) 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-mitrachak`.`voucher` `v` join `co-operativebank-mitrachak`.`shares` `s`) where ((`s`.`code` = `v`.`Acc_no`) and (`v`.`date` >= \'2017-11-25\') and (`v`.`date` <= \'2018-01-06\') and (`s`.`code` = \'01000100303\')) group by `v`.`vch_no`
