TYPE=VIEW
query=select `ld`.`date_open` AS `date_open`,`ld`.`acc_no` AS `acc_no`,`ld`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`ld`.`name` AS `name`,`ld`.`interest` AS `interest`,`ld`.`max_dt` AS `max_dt`,`ld`.`int_amt` AS `int_amt`,`ld`.`subsidy` AS `subsidy`,`ld`.`sblfno` AS `sblfno`,`ld`.`llfno` AS `llfno`,`ld`.`father_name` AS `father_name`,`ld`.`address` AS `address`,`ld`.`bankacc` AS `bankacc`,`ld`.`mobile` AS `mobile`,`ld`.`adhar` AS `adhar`,`ld`.`status` AS `status`,`ld`.`eft` AS `eft`,`ld`.`fdt` AS `fdt`,`ld`.`groupno` AS `groupno`,`ld`.`openbal` AS `openbal`,`ld`.`Due_Amt` AS `Due_Amt` from `co-operativebank-henria`.`shg_subsidy_f1` `ld` where ((`ld`.`max_dt` >= \'2024-10-01\') and (`ld`.`int_amt` <> 0)) group by `ld`.`acc_no` order by `ld`.`loan_against_sv_acc`
md5=0953efdd2c36279dee3d1cf5c28cffc1
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2025-05-06 07:06:38
create-version=1
source=select ld.* from shg_subsidy_f1 ld where ld.max_dt>=\'2024-10-01\'  and int_amt<>0 group by ld.acc_no order by loan_against_sv_acc
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `ld`.`date_open` AS `date_open`,`ld`.`acc_no` AS `acc_no`,`ld`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`ld`.`name` AS `name`,`ld`.`interest` AS `interest`,`ld`.`max_dt` AS `max_dt`,`ld`.`int_amt` AS `int_amt`,`ld`.`subsidy` AS `subsidy`,`ld`.`sblfno` AS `sblfno`,`ld`.`llfno` AS `llfno`,`ld`.`father_name` AS `father_name`,`ld`.`address` AS `address`,`ld`.`bankacc` AS `bankacc`,`ld`.`mobile` AS `mobile`,`ld`.`adhar` AS `adhar`,`ld`.`status` AS `status`,`ld`.`eft` AS `eft`,`ld`.`fdt` AS `fdt`,`ld`.`groupno` AS `groupno`,`ld`.`openbal` AS `openbal`,`ld`.`Due_Amt` AS `Due_Amt` from `co-operativebank-henria`.`shg_subsidy_f1` `ld` where ((`ld`.`max_dt` >= \'2024-10-01\') and (`ld`.`int_amt` <> 0)) group by `ld`.`acc_no` order by `ld`.`loan_against_sv_acc`
