TYPE=VIEW
query=select `ss`.`date_open` AS `date_open`,`ss`.`acc_no` AS `acc_no`,`ss`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`ss`.`name` AS `name`,`ss`.`amt` AS `amt`,concat(`ss`.`interest`,\'%\') AS `interest`,`ss`.`max_dt` AS `max_dt`,(select sum(`lld`.`intrst_Amt`) from `co-operativebank-radhapur`.`loan_deposit` `lld` where ((`lld`.`Acc_No` = `ld`.`Acc_No`) and (`lld`.`Acc_No` = `ss`.`acc_no`) and (`lld`.`Date` >= \'2024-04-28\') and (`lld`.`Date` <= \'2024-04-28\')) group by `lld`.`Acc_No`) AS `int_amt`,round((((select sum(`lld`.`intrst_Amt`) from `co-operativebank-radhapur`.`loan_deposit` `lld` where ((`lld`.`Acc_No` = `ld`.`Acc_No`) and (`lld`.`Acc_No` = `ss`.`acc_no`) and (`lld`.`Date` >= \'2024-04-28\') and (`lld`.`Date` <= \'2024-04-28\')) group by `lld`.`Acc_No`) / `ss`.`interest`) * 3),0) AS `subsidy`,`ss`.`sblfno` AS `sblfno`,`ss`.`llfno` AS `llfno`,`ss`.`father_name` AS `father_name`,`ss`.`address` AS `address`,`ss`.`bankacc` AS `bankacc`,`ss`.`mobile` AS `mobile`,`ss`.`adhar` AS `adhar`,`ss`.`status` AS `status`,`ss`.`bankacc` AS `eft`,`ss`.`fdt` AS `fdt` from `co-operativebank-radhapur`.`shg_subsidy` `ss` join `co-operativebank-radhapur`.`loan_deposit` `ld` where ((`ss`.`max_dt` <= `ss`.`fdt`) and (`ld`.`Acc_No` = `ss`.`acc_no`) and (`ld`.`Date` >= \'2024-04-28\') and (`ld`.`Date` <= \'2024-04-28\')) group by `ss`.`acc_no`
md5=eb095158183ae4d76b4192437125e589
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2024-04-28 11:58:49
create-version=1
source=SELECT ss.`date_open`, ss.`acc_no`, ss.`loan_against_sv_acc`, ss.`name`,ss.amt, concat(`ss`.`interest`,\'%\') AS `interest`,ss.`max_dt`,(select sum(`lld`.`intrst_Amt`) from loan_deposit lld where lld.acc_no=ld.acc_no and lld.acc_no=ss.acc_no and ((`lld`.`Date` >= \'2024-04-28\') and (`lld`.`Date` <= \'2024-04-28\')) group by lld.acc_no ) as int_amt, round((((select sum(`lld`.`intrst_Amt`) from loan_deposit lld where lld.acc_no=ld.acc_no and lld.acc_no=ss.acc_no and ((`lld`.`Date` >= \'2024-04-28\') and (`lld`.`Date` <= \'2024-04-28\')) group by lld.acc_no ) / `ss`.`interest`) * 3),0) as`subsidy`,sblfno,llfno,father_name,address,bankacc,mobile,adhar,ss.status,ss.bankacc as eft,fdt FROM `shg_subsidy` ss, loan_deposit ld WHERE max_dt<=fdt and ld.acc_no=ss.acc_no  and ld.date>=\'2024-04-28\' and ld.date<=\'2024-04-28\' group by ss.acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `ss`.`date_open` AS `date_open`,`ss`.`acc_no` AS `acc_no`,`ss`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`ss`.`name` AS `name`,`ss`.`amt` AS `amt`,concat(`ss`.`interest`,\'%\') AS `interest`,`ss`.`max_dt` AS `max_dt`,(select sum(`lld`.`intrst_Amt`) from `co-operativebank-radhapur`.`loan_deposit` `lld` where ((`lld`.`Acc_No` = `ld`.`Acc_No`) and (`lld`.`Acc_No` = `ss`.`acc_no`) and (`lld`.`Date` >= \'2024-04-28\') and (`lld`.`Date` <= \'2024-04-28\')) group by `lld`.`Acc_No`) AS `int_amt`,round((((select sum(`lld`.`intrst_Amt`) from `co-operativebank-radhapur`.`loan_deposit` `lld` where ((`lld`.`Acc_No` = `ld`.`Acc_No`) and (`lld`.`Acc_No` = `ss`.`acc_no`) and (`lld`.`Date` >= \'2024-04-28\') and (`lld`.`Date` <= \'2024-04-28\')) group by `lld`.`Acc_No`) / `ss`.`interest`) * 3),0) AS `subsidy`,`ss`.`sblfno` AS `sblfno`,`ss`.`llfno` AS `llfno`,`ss`.`father_name` AS `father_name`,`ss`.`address` AS `address`,`ss`.`bankacc` AS `bankacc`,`ss`.`mobile` AS `mobile`,`ss`.`adhar` AS `adhar`,`ss`.`status` AS `status`,`ss`.`bankacc` AS `eft`,`ss`.`fdt` AS `fdt` from `co-operativebank-radhapur`.`shg_subsidy` `ss` join `co-operativebank-radhapur`.`loan_deposit` `ld` where ((`ss`.`max_dt` <= `ss`.`fdt`) and (`ld`.`Acc_No` = `ss`.`acc_no`) and (`ld`.`Date` >= \'2024-04-28\') and (`ld`.`Date` <= \'2024-04-28\')) group by `ss`.`acc_no`
