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` from ((`co-operativebank-mohati`.`loan_acc` `la` join `co-operativebank-mohati`.`j_a` `a`) join `co-operativebank-mohati`.`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` <= \'2023-03-31\') and (`la`.`date_open` <= \'2023-03-31\')) group by `la`.`acc_no`
md5=ef524afecf01a0c3b38be18b2980cb04
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2023-05-28 04:14:10
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 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<=\'2023-03-31\' and la.date_open<=\'2023-03-31\' group by `la`.`acc_no`
client_cs_name=utf8
connection_cl_name=utf8_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` from ((`co-operativebank-mohati`.`loan_acc` `la` join `co-operativebank-mohati`.`j_a` `a`) join `co-operativebank-mohati`.`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` <= \'2023-03-31\') and (`la`.`date_open` <= \'2023-03-31\')) group by `la`.`acc_no`
