TYPE=VIEW
query=select `v`.`Acc_no` AS `sv_acc`,`lc`.`acc_no` AS `loan_acc`,round(((sum(`v`.`cr`) - sum(`v`.`dr`)) / (select count(0) from `co-operativebank-radhapur`.`loan_acc` where (`lc`.`acc_no` = `co-operativebank-radhapur`.`loan_acc`.`acc_no`) group by `lc`.`acc_no`)),0) AS `bal`,`lc`.`sub_head` AS `sub_head`,(select count(0) from `co-operativebank-radhapur`.`loan_acc` where (`lc`.`acc_no` = `co-operativebank-radhapur`.`loan_acc`.`acc_no`) group by `lc`.`acc_no`) AS `total_p` from (`co-operativebank-radhapur`.`voucher` `v` join `co-operativebank-radhapur`.`loan_acc` `lc` on((`lc`.`loan_against_sv_acc` = `v`.`Acc_no`))) where ((`lc`.`sub_head` = \'23113\') and (`v`.`sub_head` = \'14201\') and (`v`.`date` <= \'2026-02-26\')) group by `lc`.`acc_no` order by `lc`.`date_open`
md5=d1e3f447434272cd6c30d9e993fe9877
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2026-02-26 12:33:07
create-version=1
source=select v.acc_no as sv_acc,lc.acc_no as loan_acc,round((sum(cr)-sum(dr))/(select count(*) from loan_acc where lc.acc_no=acc_no group by lc.acc_no)) as bal,lc.sub_head,(select count(*) from loan_acc where lc.acc_no=acc_no group by lc.acc_no) as total_p FROM voucher v JOIN loan_acc lc ON lc.loan_against_sv_acc = v.acc_no where  lc.sub_head=\'23113\' and  v.sub_head=\'14201\' and v.date<=\'2026-02-26\'  group by lc.acc_no order by date_open
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `v`.`Acc_no` AS `sv_acc`,`lc`.`acc_no` AS `loan_acc`,round(((sum(`v`.`cr`) - sum(`v`.`dr`)) / (select count(0) from `co-operativebank-radhapur`.`loan_acc` where (`lc`.`acc_no` = `co-operativebank-radhapur`.`loan_acc`.`acc_no`) group by `lc`.`acc_no`)),0) AS `bal`,`lc`.`sub_head` AS `sub_head`,(select count(0) from `co-operativebank-radhapur`.`loan_acc` where (`lc`.`acc_no` = `co-operativebank-radhapur`.`loan_acc`.`acc_no`) group by `lc`.`acc_no`) AS `total_p` from (`co-operativebank-radhapur`.`voucher` `v` join `co-operativebank-radhapur`.`loan_acc` `lc` on((`lc`.`loan_against_sv_acc` = `v`.`Acc_no`))) where ((`lc`.`sub_head` = \'23113\') and (`v`.`sub_head` = \'14201\') and (`v`.`date` <= \'2026-02-26\')) group by `lc`.`acc_no` order by `lc`.`date_open`
