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-198`.`loan_acc` `l` join `co-operativebank-198`.`loan_deposit` `ld`) where ((`ld`.`loan_id` = `l`.`id`) and (`ld`.`Date` >= \'2018-05-03\') and (`ld`.`Date` <= \'2019-03-31\') and (`l`.`sub_head` = \'23101B\')) group by `ld`.`loan_id`
md5=f81759ea07ad7dd6445974c59767ea86
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-07-28 05:49:45
create-version=1
source=select  `ld`.`loan_id`  AS  `loan_id` ,\n `ld`.`Acc_No`  AS  `acc_no` ,\nsum(  `ld`.`intrst_Amt`  )  AS  `int_amt` ,\nsum(  `ld`.`Total_amt`  )  AS  `prince` ,\nmax(  `ld`.`Date`  )  AS  `max_dt` ,\nround( ( ( sum(  `ld`.`intrst_Amt`  )  /  `l`.`interest`  )  *3 ),\n0 ) AS  `subsidy` ,\n(  `l`.`amt`  - sum(  `ld`.`Total_amt`  )  ) AS  `Due_Amt`  from (  `co-operativebank-198`.`loan_acc`  `l`  join  `co-operativebank-198`.`loan_deposit`  `ld`  ) where ( (  `ld`.`loan_id`  =  `l`.`id`  ) and (  `ld`.`Date`  >=  \'2018-05-03\' ) and (  `ld`.`Date`  <=  \'2019-03-31\' ) and (  `l`.`sub_head`  =  \'23101B\' ) ) 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-198`.`loan_acc` `l` join `co-operativebank-198`.`loan_deposit` `ld`) where ((`ld`.`loan_id` = `l`.`id`) and (`ld`.`Date` >= \'2018-05-03\') and (`ld`.`Date` <= \'2019-03-31\') and (`l`.`sub_head` = \'23101B\')) group by `ld`.`loan_id`
