TYPE=VIEW
query=select `v1`.`no` AS `no`,`v1`.`cash_acc` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,sum(`v1`.`dr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-bajbajia`.`voucher` `v1` join `co-operativebank-bajbajia`.`quick_name` `a`) where (((`v1`.`cash_acc` = `a`.`acc_no`) or (`v1`.`Acc_no` = `a`.`acc_no`)) and (`v1`.`sub_head` = \'63404\') and (`v1`.`date` = \'2019-01-05\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`head` > 60000) and (`v1`.`dr` <> \'0\')) group by `v1`.`no` union all select `v1`.`no` AS `no`,`v1`.`cash_acc` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,\'0\' AS `0`,sum(`v1`.`dr`) AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-bajbajia`.`voucher` `v1` join `co-operativebank-bajbajia`.`quick_name` `a`) where (((`v1`.`cash_acc` = `a`.`acc_no`) or (`v1`.`Acc_no` = `a`.`acc_no`)) and (`v1`.`sub_head` = \'63404\') and (`v1`.`date` = \'2019-01-05\') and (`v1`.`deposit_type` = \'TRANSFER\') and (`v1`.`head` > 60000) and (`v1`.`dr` <> \'0\')) group by `v1`.`no`
md5=c27f1e85cd0827ae70c9f8184a43c161
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-01-10 05:51:53
create-version=1
source=select `v1`.`no` AS `no`,`v1`.`cash_acc` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,sum(`v1`.`dr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`voucher` `v1` join `quick_name` `a`) where (((`v1`.`cash_acc` = `a`.`acc_no`) or (`v1`.`Acc_no` = `a`.`acc_no`)) and (`v1`.`sub_head` = \'63404\') and (`v1`.`date` = \'2019-01-05\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`head` > 60000) and (`v1`.`dr` <> \'0\')) group by `v1`.`no` union all select `v1`.`no` AS `no`,`v1`.`cash_acc` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,\'0\' AS `0`,sum(`v1`.`dr`) AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`voucher` `v1` join `quick_name` `a`) where (((`v1`.`cash_acc` = `a`.`acc_no`) or (`v1`.`Acc_no` = `a`.`acc_no`)) and (`v1`.`sub_head` = \'63404\') and (`v1`.`date` = \'2019-01-05\') and (`v1`.`deposit_type` = \'TRANSFER\') and (`v1`.`head` > 60000) and (`v1`.`dr` <> \'0\')) group by `v1`.`no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v1`.`no` AS `no`,`v1`.`cash_acc` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,sum(`v1`.`dr`) AS `CASH`,\'0\' AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-bajbajia`.`voucher` `v1` join `co-operativebank-bajbajia`.`quick_name` `a`) where (((`v1`.`cash_acc` = `a`.`acc_no`) or (`v1`.`Acc_no` = `a`.`acc_no`)) and (`v1`.`sub_head` = \'63404\') and (`v1`.`date` = \'2019-01-05\') and (`v1`.`deposit_type` = \'CASH\') and (`v1`.`head` > 60000) and (`v1`.`dr` <> \'0\')) group by `v1`.`no` union all select `v1`.`no` AS `no`,`v1`.`cash_acc` AS `acc_no`,`a`.`name` AS `name`,`a`.`lfno` AS `lfno`,\'0\' AS `0`,sum(`v1`.`dr`) AS `TRAN`,`v1`.`date` AS `date`,`v1`.`sub_head` AS `sub_head` from (`co-operativebank-bajbajia`.`voucher` `v1` join `co-operativebank-bajbajia`.`quick_name` `a`) where (((`v1`.`cash_acc` = `a`.`acc_no`) or (`v1`.`Acc_no` = `a`.`acc_no`)) and (`v1`.`sub_head` = \'63404\') and (`v1`.`date` = \'2019-01-05\') and (`v1`.`deposit_type` = \'TRANSFER\') and (`v1`.`head` > 60000) and (`v1`.`dr` <> \'0\')) group by `v1`.`no`
