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`,concat(`ss`.`interest`,\'%\') AS `interest`,`ss`.`max_dt` AS `max_dt`,sum(`ld`.`intrst_Amt`) AS `int_amt`,round(((sum(`ld`.`intrst_Amt`) / `ss`.`interest`) * 9),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`,`ss`.`groupno` AS `groupno` from `co-operativebank-keshabchak`.`shg_subsidy` `ss` join `co-operativebank-keshabchak`.`loan_deposit` `ld` where ((`ss`.`max_dt` <= `ss`.`fdt`) and (`ld`.`Acc_No` = `ss`.`acc_no`) and (`ld`.`Date` >= \'2023-10-01\') and (`ld`.`Date` <= \'2024-03-31\')) group by `ss`.`acc_no`
md5=e6a4c75ba15a1a548e6955ea1af3809e
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2024-06-20 10:31:29
create-version=1
source=SELECT ss.`date_open`, ss.`acc_no`, ss.`loan_against_sv_acc`, ss.`name`, concat(`ss`.`interest`,\'%\') AS `interest`,ss.`max_dt`, sum(ld.intrst_Amt) as int_amt, round(((sum(`ld`.`intrst_Amt`) / `ss`.`interest`) * 9),0) as`subsidy`,sblfno,llfno,father_name,address ,bankacc,mobile,adhar,ss.status,ss.bankacc as eft,fdt,groupno FROM `shg_subsidy` ss, loan_deposit ld WHERE max_dt<=fdt and ld.acc_no=ss.acc_no  and ld.date>=\'2023-10-01\' and ld.date<=\'2024-03-31\' 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`,concat(`ss`.`interest`,\'%\') AS `interest`,`ss`.`max_dt` AS `max_dt`,sum(`ld`.`intrst_Amt`) AS `int_amt`,round(((sum(`ld`.`intrst_Amt`) / `ss`.`interest`) * 9),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`,`ss`.`groupno` AS `groupno` from `co-operativebank-keshabchak`.`shg_subsidy` `ss` join `co-operativebank-keshabchak`.`loan_deposit` `ld` where ((`ss`.`max_dt` <= `ss`.`fdt`) and (`ld`.`Acc_No` = `ss`.`acc_no`) and (`ld`.`Date` >= \'2023-10-01\') and (`ld`.`Date` <= \'2024-03-31\')) group by `ss`.`acc_no`
