TYPE=VIEW
query=select `ld`.`loan_id` AS `loan_id`,`ld`.`Acc_No` AS `acc_no`,sum(`ld`.`intrst_Amt`) AS `int_amt`,sum(`ld`.`Total_amt`) AS `prince`,max(`ld`.`Date`) AS `max_dt`,round(((sum(`ld`.`intrst_Amt`) / `l`.`interest`) * 3),0) AS `subsidy`,(`l`.`amt` - sum(`ld`.`Total_amt`)) AS `Due_Amt` from `co-operativebank-keshabchak`.`loan_acc` `l` join `co-operativebank-keshabchak`.`loan_deposit` `ld` where ((`ld`.`loan_id` = `l`.`id`) and (`ld`.`Date` >= \'2025-03-01\') and (`ld`.`Date` <= \'2025-11-01\') and (`l`.`sub_head` = \'23118\')) group by `ld`.`loan_id`
md5=74ca56ba4b7b89ba8ae5b0ba0245a536
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-11-04 10:03:57
create-version=1
source=SELECT loan_id,ld.acc_no,sum(intrst_Amt) as int_amt,sum(Total_amt) as prince,max(date) as max_dt,round((sum(intrst_amt)/interest*3),0) subsidy,(l.amt-sum(`ld`.`Total_amt`)) as Due_Amt FROM `loan_acc` l,loan_deposit ld  WHERE ld.loan_id=l.id and date>=\'2025-03-01\' and date<=\'2025-11-01\' and sub_head=\'23118\' group by ld.loan_id
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `ld`.`loan_id` AS `loan_id`,`ld`.`Acc_No` AS `acc_no`,sum(`ld`.`intrst_Amt`) AS `int_amt`,sum(`ld`.`Total_amt`) AS `prince`,max(`ld`.`Date`) AS `max_dt`,round(((sum(`ld`.`intrst_Amt`) / `l`.`interest`) * 3),0) AS `subsidy`,(`l`.`amt` - sum(`ld`.`Total_amt`)) AS `Due_Amt` from `co-operativebank-keshabchak`.`loan_acc` `l` join `co-operativebank-keshabchak`.`loan_deposit` `ld` where ((`ld`.`loan_id` = `l`.`id`) and (`ld`.`Date` >= \'2025-03-01\') and (`ld`.`Date` <= \'2025-11-01\') and (`l`.`sub_head` = \'23118\')) group by `ld`.`loan_id`
