TYPE=VIEW
query=select `v1`.`Acc_no` AS `acc_no`,concat(`a`.`name`,\' \',convert(if((`v1`.`vch_type` = \'Opnn Bal\'),\'[NEW]\',\'\') using latin1)) AS `name`,`a`.`lfno` AS `lfno`,sum(`v1`.`cr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank-mohati`.`voucher` `v1` join `co-operativebank-mohati`.`quick_name` `a` where ((`v1`.`Acc_no` = `a`.`acc_no`) and (`v1`.`cr` <> \'0\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`sub_head` = \'14101\') and (`v1`.`date` = \'2020-10-16\')) group by `a`.`acc_no`
md5=d8a327e7c82ce6f2a8c71774ee16a6a7
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2020-10-16 18:05:04
create-version=1
source=select v1.acc_no,concat(name,\' \',if(vch_type=\'Opnn Bal\',\'[NEW]\',\'\')) as name,lfno,sum(V1.cr) as CASH,\'0\' as TRAN,date,sub_head from voucher v1,quick_name a where (v1.acc_no=a.acc_no  AND v1.cR<>\'0\' AND v1.DEPOSIT_TYPE=\'CASH\') and sub_head=\'14101\' and date=\'2020-10-16\'  GROUP BY A.ACC_NO
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v1`.`Acc_no` AS `acc_no`,concat(`a`.`name`,\' \',convert(if((`v1`.`vch_type` = \'Opnn Bal\'),\'[NEW]\',\'\') using latin1)) AS `name`,`a`.`lfno` AS `lfno`,sum(`v1`.`cr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from `co-operativebank-mohati`.`voucher` `v1` join `co-operativebank-mohati`.`quick_name` `a` where ((`v1`.`Acc_no` = `a`.`acc_no`) and (`v1`.`cr` <> \'0\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`sub_head` = \'14101\') and (`v1`.`date` = \'2020-10-16\')) group by `a`.`acc_no`
