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`,sum(`ld`.`intrst_Amt`) AS `int_amt`,round(((sum(`ld`.`intrst_Amt`) / `ss`.`interest`) * 2),0) AS `subsidy` from (`co-operativebank-230`.`shg_subsidy` `ss` join `co-operativebank-230`.`loan_deposit` `ld`) where ((`ld`.`Acc_No` = `ss`.`acc_no`) and (`ld`.`Date` >= \'2017-04-01\') and (`ld`.`Date` <= \'2017-09-30\')) group by `ss`.`acc_no`
md5=11d3ed60dac2f6a20f2caac9105d1a8b
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2024-04-20 10:56:44
create-version=1
source=select  `ss`.`date_open`  AS  `date_open` ,\n `ss`.`acc_no`  AS  `acc_no` ,\n `ss`.`loan_against_sv_acc`  AS  `loan_against_sv_acc` ,\n `ss`.`name`  AS  `name` ,\n `ss`.`amt`  AS  `amt` ,\nconcat(  `ss`.`interest` ,  \'%\'  )  AS  `interest` ,\n `ss`.`max_dt`  AS  `max_dt` ,\nsum(  `ld`.`intrst_Amt`  )  AS  `int_amt` ,\nround( ( ( sum(  `ld`.`intrst_Amt`  )  /  `ss`.`interest`  )  *2 ),\n0 ) AS  `subsidy`  from (  `co-operativebank-230`.`shg_subsidy`  `ss`  join  `co-operativebank-230`.`loan_deposit`  `ld`  ) where ( (  `ld`.`Acc_No`  =  `ss`.`acc_no`  ) and (  `ld`.`Date`  >=  \'2017-04-01\' ) and (  `ld`.`Date`  <=  \'2017-09-30\' ) ) 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`,sum(`ld`.`intrst_Amt`) AS `int_amt`,round(((sum(`ld`.`intrst_Amt`) / `ss`.`interest`) * 2),0) AS `subsidy` from (`co-operativebank-230`.`shg_subsidy` `ss` join `co-operativebank-230`.`loan_deposit` `ld`) where ((`ld`.`Acc_No` = `ss`.`acc_no`) and (`ld`.`Date` >= \'2017-04-01\') and (`ld`.`Date` <= \'2017-09-30\')) group by `ss`.`acc_no`
