TYPE=VIEW
query=select max(`la`.`date_open`) AS `date_open`,max(`la`.`fianl_date`) AS `fdt`,`la`.`acc_no` AS `acc_no`,`la`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`a`.`name` AS `name`,concat(`la`.`interest`) AS `interest`,max(`ld`.`Date`) AS `max_dt`,`a`.`lf_no` AS `sblfno`,`la`.`lf_no` AS `llfno`,`a`.`father_name` AS `father_name`,`a`.`address` AS `address`,`a`.`bankacc` AS `bankacc`,`a`.`mobile` AS `mobile`,`a`.`adhar` AS `adhar`,`a`.`status` AS `status`,`a`.`groupno` AS `groupno` from ((`co-operativebank-244`.`loan_acc` `la` join `co-operativebank-244`.`j_a` `a`) join `co-operativebank-244`.`loan_deposit` `ld`) where ((`la`.`loan_against_sv_acc` = `a`.`Acc_No`) and (`ld`.`status` <> 0) and (`ld`.`Acc_No` = `la`.`acc_no`) and (`la`.`sub_head` = \'23113\') and (`la`.`id` = `ld`.`loan_id`) and (`ld`.`Date` <= \'2026-02-10\') and (`la`.`date_open` <= \'2026-02-10\')) group by `la`.`acc_no`
md5=c83a4049a6f537777790982030384e6c
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2026-02-10 10:30:59
create-version=1
source=select max(`la`.`date_open`) AS `date_open`,max(la.fianl_date) as fdt,`la`.`acc_no` AS `acc_no`,`la`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`a`.`name` AS `name`,concat(`la`.`interest`) AS `interest`,max(`ld`.`Date`) AS `max_dt`,a.lf_no as sblfno,la.lf_no as llfno,father_name,address,a.bankacc,a.mobile,a.adhar,a.status,a.groupno from ((`loan_acc` `la` join `j_a` `a`) join `loan_deposit` `ld`) where ((`la`.`loan_against_sv_acc` = `a`.`Acc_No`)  and  (`ld`.`status` <> 0) and (`ld`.`Acc_No` = `la`.`acc_no`) and (`la`.`sub_head` = \'23113\')) and la.id=ld.loan_id and ld.date<=\'2026-02-10\' and la.date_open<=\'2026-02-10\' group by `la`.`acc_no`
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select max(`la`.`date_open`) AS `date_open`,max(`la`.`fianl_date`) AS `fdt`,`la`.`acc_no` AS `acc_no`,`la`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`a`.`name` AS `name`,concat(`la`.`interest`) AS `interest`,max(`ld`.`Date`) AS `max_dt`,`a`.`lf_no` AS `sblfno`,`la`.`lf_no` AS `llfno`,`a`.`father_name` AS `father_name`,`a`.`address` AS `address`,`a`.`bankacc` AS `bankacc`,`a`.`mobile` AS `mobile`,`a`.`adhar` AS `adhar`,`a`.`status` AS `status`,`a`.`groupno` AS `groupno` from ((`co-operativebank-244`.`loan_acc` `la` join `co-operativebank-244`.`j_a` `a`) join `co-operativebank-244`.`loan_deposit` `ld`) where ((`la`.`loan_against_sv_acc` = `a`.`Acc_No`) and (`ld`.`status` <> 0) and (`ld`.`Acc_No` = `la`.`acc_no`) and (`la`.`sub_head` = \'23113\') and (`la`.`id` = `ld`.`loan_id`) and (`ld`.`Date` <= \'2026-02-10\') and (`la`.`date_open` <= \'2026-02-10\')) group by `la`.`acc_no`
