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` = \'010001000741\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2015-04-06\') and (`v`.`date` <= \'2018-03-31\')) 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` from (`co-club`.`voucher` `v` join `co-club`.`withdrawl` `w`) where ((`v`.`Acc_no` = \'010001000741\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2015-04-06\') and (`v`.`date` <= \'2018-03-31\')) group by `v`.`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-club`.`voucher` `v` join `co-club`.`shares` `s`) where ((`s`.`code` = `v`.`Acc_no`) and (`v`.`date` >= \'2015-04-06\') and (`v`.`date` <= \'2018-03-31\') and (`s`.`code` = \'010001000741\')) group by `v`.`vch_no`,`v`.`no`
md5=b78dc73b0f576e2a69f664256bd2f799
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=1
with_check_option=0
timestamp=2018-11-01 09:34:35
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` ,  \' \', 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`  from (  `co-club`.`voucher`  `v`  join  `co-club`.`deposit`  `d`  ) where ( (  `v`.`Acc_no`  =  \'010001000741\' ) and (  `v`.`vch_no`  =  `d`.`shilp`  ) and (  `v`.`date`  =  `d`.`Date`  ) and (  `v`.`Acc_no`  =  `d`.`Acc_No`  ) and (  `v`.`date`  >=  \'2015-04-06\' ) and (  `v`.`date`  <=  \'2018-03-31\' ) ) 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`  from (  `co-club`.`voucher`  `v`  join  `co-club`.`withdrawl`  `w`  ) where ( (  `v`.`Acc_no`  =  \'010001000741\' ) and (  `v`.`vch_no`  =  `w`.`slip_no`  ) and (  `v`.`Acc_no`  =  `w`.`Acc_no`  ) and (  `v`.`date`  >=  \'2015-04-06\' ) and (  `v`.`date`  <=  \'2018-03-31\' ) ) group  by  `v`.`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-club`.`voucher`  `v`  join  `co-club`.`shares`  `s`  ) where ( (  `s`.`code`  =  `v`.`Acc_no`  ) and (  `v`.`date`  >=  \'2015-04-06\' ) and (  `v`.`date`  <=  \'2018-03-31\' ) and (  `s`.`code`  =  \'010001000741\' ) ) group  by  `v`.`vch_no` ,\n `v`.`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` = \'010001000741\') and (`v`.`vch_no` = `d`.`shilp`) and (`v`.`date` = `d`.`Date`) and (`v`.`Acc_no` = `d`.`Acc_No`) and (`v`.`date` >= \'2015-04-06\') and (`v`.`date` <= \'2018-03-31\')) 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` from (`co-club`.`voucher` `v` join `co-club`.`withdrawl` `w`) where ((`v`.`Acc_no` = \'010001000741\') and (`v`.`vch_no` = `w`.`slip_no`) and (`v`.`Acc_no` = `w`.`Acc_no`) and (`v`.`date` >= \'2015-04-06\') and (`v`.`date` <= \'2018-03-31\')) group by `v`.`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-club`.`voucher` `v` join `co-club`.`shares` `s`) where ((`s`.`code` = `v`.`Acc_no`) and (`v`.`date` >= \'2015-04-06\') and (`v`.`date` <= \'2018-03-31\') and (`s`.`code` = \'010001000741\')) group by `v`.`vch_no`,`v`.`no`
