TYPE=VIEW
query=select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,concat(`a`.`name`,\' \',if(((`v1`.`transtion_by` = \'SELF\') or (`v1`.`transtion_by` = \'\')),\'\',concat(\'[\',`v1`.`transtion_by`,\']\'))) AS `name`,`a`.`lfno` AS `lfno`,(sum(`v1`.`dr`) - sum(`v1`.`interest`)) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-dkmadhabpur`.`voucher` `v1` USE INDEX (`by_sub_head`) USE INDEX (`by_acc_no`) join `co-operativebank-dkmadhabpur`.`quick_name` `a` USE INDEX (`by_acc_no`)) where ((`v1`.`Acc_no` = `a`.`acc_no`) and (`v1`.`sub_head` = \'14101\') and (`v1`.`date` = \'2021-03-31\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`dr` <> \'0\')) group by `v1`.`Acc_no` union all select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,\'0\' AS `0`,(sum(`v1`.`dr`) - sum(`v1`.`interest`)) AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-dkmadhabpur`.`voucher` `v1` USE INDEX (`by_sub_head`) USE INDEX (`by_acc_no`) join `co-operativebank-dkmadhabpur`.`quick_name` `a` USE INDEX (`by_acc_no`)) where ((`v1`.`Acc_no` = `a`.`acc_no`) and (`v1`.`sub_head` = \'14101\') and (`v1`.`date` = \'2021-03-31\') and (`v1`.`deposit_type` = \'TRANSFER\') and (`v1`.`dr` <> \'0\')) group by `a`.`acc_no`
md5=3a258b8d62ad67383f41bed056806103
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=1
with_check_option=0
timestamp=2021-07-22 15:02:00
create-version=1
source=select  `v1`.`no`  AS  `no` ,\n `v1`.`Acc_no`  AS  `acc_no` ,\nconcat(  `a`.`name` ,  \' \', if( ( (  `v1`.`transtion_by`  =  \'SELF\' ) or (  `v1`.`transtion_by`  =  \'\' ) ) ,  \'\', concat(  \'[\',  `v1`.`transtion_by` ,  \']\'  )  )  ) AS  `name` ,\n `a`.`lfno`  AS  `lfno` ,\n( sum(  `v1`.`dr`  )  - sum(  `v1`.`interest`  )  ) AS  `CASH` ,\n \'0\' AS  `TRAN` ,\n `v1`.`date`  AS  `date` ,\n `v1`.`sub_head`  AS  `sub_head`  from (  `co-operativebank-dkmadhabpur`.`voucher`  `v1`  USE  INDEX (  `by_acc_no`  )  USE  INDEX (  `by_sub_head`  )  join  `co-operativebank-dkmadhabpur`.`quick_name`  `a`  USE  INDEX (  `by_acc_no`  )  ) where ( (  `v1`.`Acc_no`  =  `a`.`acc_no`  ) and (  `v1`.`sub_head`  =  \'14101\' ) and (  `v1`.`date`  =  \'2021-03-31\' ) and (  `v1`.`deposit_type`  =  \'CASH\' ) and (  `v1`.`dr`  <>  \'0\' ) ) group  by  `v1`.`Acc_no`  union  all  select  `v1`.`no`  AS  `no` ,\n `v1`.`Acc_no`  AS  `acc_no` ,\n `a`.`name`  AS  `name` ,\n `a`.`lfno`  AS  `lfno` ,\n \'0\' AS  `0` ,\n( sum(  `v1`.`dr`  )  - sum(  `v1`.`interest`  )  ) AS  `TRAN` ,\n `v1`.`date`  AS  `date` ,\n `v1`.`sub_head`  AS  `sub_head`  from (  `co-operativebank-dkmadhabpur`.`voucher`  `v1`  USE  INDEX (  `by_acc_no`  )  USE  INDEX (  `by_sub_head`  )  join  `co-operativebank-dkmadhabpur`.`quick_name`  `a`  USE  INDEX (  `by_acc_no`  )  ) where ( (  `v1`.`Acc_no`  =  `a`.`acc_no`  ) and (  `v1`.`sub_head`  =  \'14101\' ) and (  `v1`.`date`  =  \'2021-03-31\' ) and (  `v1`.`deposit_type`  =  \'TRANSFER\' ) and (  `v1`.`dr`  <>  \'0\' ) ) group  by  `a`.`acc_no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,concat(`a`.`name`,\' \',if(((`v1`.`transtion_by` = \'SELF\') or (`v1`.`transtion_by` = \'\')),\'\',concat(\'[\',`v1`.`transtion_by`,\']\'))) AS `name`,`a`.`lfno` AS `lfno`,(sum(`v1`.`dr`) - sum(`v1`.`interest`)) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-dkmadhabpur`.`voucher` `v1` USE INDEX (`by_sub_head`) USE INDEX (`by_acc_no`) join `co-operativebank-dkmadhabpur`.`quick_name` `a` USE INDEX (`by_acc_no`)) where ((`v1`.`Acc_no` = `a`.`acc_no`) and (`v1`.`sub_head` = \'14101\') and (`v1`.`date` = \'2021-03-31\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`dr` <> \'0\')) group by `v1`.`Acc_no` union all select `v1`.`no` AS `no`,`v1`.`Acc_no` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,\'0\' AS `0`,(sum(`v1`.`dr`) - sum(`v1`.`interest`)) AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-dkmadhabpur`.`voucher` `v1` USE INDEX (`by_sub_head`) USE INDEX (`by_acc_no`) join `co-operativebank-dkmadhabpur`.`quick_name` `a` USE INDEX (`by_acc_no`)) where ((`v1`.`Acc_no` = `a`.`acc_no`) and (`v1`.`sub_head` = \'14101\') and (`v1`.`date` = \'2021-03-31\') and (`v1`.`deposit_type` = \'TRANSFER\') and (`v1`.`dr` <> \'0\')) group by `a`.`acc_no`
