TYPE=VIEW
query=select `lc`.`sub_head` AS `sub_head`,sum(`ld`.`od`) AS `od_amt`,sum(`ld`.`od_int`) AS `od_int` from `co-operativebank-durgapur`.`loan_deposit` `ld` join `co-operativebank-durgapur`.`loan_acc` `lc` where ((`lc`.`id` = `ld`.`loan_id`) and (`ld`.`Date` >= \'2025-04-01\') and (`ld`.`Date` <= \'2026-03-05\')) group by `lc`.`sub_head`
md5=3f6aef7ab30e82a24b3b0aa2daf02761
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-03-05 06:24:00
create-version=1
source=SELECT sub_head,sum(ld.od) as od_amt, sum(ld.od_int) as od_int FROM `loan_deposit` ld,loan_acc lc WHERE lc.id=ld.loan_id  and ld.date>=\'2025-04-01\' and ld.date<=\'2026-03-05\' group by sub_head
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `lc`.`sub_head` AS `sub_head`,sum(`ld`.`od`) AS `od_amt`,sum(`ld`.`od_int`) AS `od_int` from `co-operativebank-durgapur`.`loan_deposit` `ld` join `co-operativebank-durgapur`.`loan_acc` `lc` where ((`lc`.`id` = `ld`.`loan_id`) and (`ld`.`Date` >= \'2025-04-01\') and (`ld`.`Date` <= \'2026-03-05\')) group by `lc`.`sub_head`
