TYPE=VIEW
query=select `l`.`loan_against_sv_acc` AS `SB_accno`,max(`l`.`id`) AS `ID`,`l`.`acc_no` AS `acc_no`,round(max(`l`.`amt`),2) AS `amt_of_loan_issue`,max(`l`.`date_open`) AS `date_of_loan_issue`,`l`.`name_p` AS `Purpose` from `co-operativebank-radhapur`.`loan_acc` `l` join `co-operativebank-radhapur`.`shg_loan_dt` `s` where ((`s`.`acc_no` = `l`.`acc_no`) and ((`l`.`sub_head` = \'23113\') or (`l`.`sub_head` = \'23213\')) and (`s`.`date_of_loan_issue` <= \'2024-11-30\') and (`s`.`ID` = `l`.`id`)) group by `l`.`acc_no`
md5=a985c866c72d739b54a7205e413613cf
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2024-12-03 05:27:46
create-version=1
source=SELECT loan_against_sv_acc as SB_accno,max(l.id) AS ID,l.acc_no,round(max(amt),2) as amt_of_loan_issue,max(date_open) as date_of_loan_issue,name_p as Purpose FROM `loan_acc`l,shg_loan_dt s WHERE s.acc_no=l.acc_no and  (l.sub_head=\'23113\' or l.sub_head=\'23213\') and s.date_of_loan_issue<=\'2024-11-30\' and s.id=l.id group by l.acc_no
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `l`.`loan_against_sv_acc` AS `SB_accno`,max(`l`.`id`) AS `ID`,`l`.`acc_no` AS `acc_no`,round(max(`l`.`amt`),2) AS `amt_of_loan_issue`,max(`l`.`date_open`) AS `date_of_loan_issue`,`l`.`name_p` AS `Purpose` from `co-operativebank-radhapur`.`loan_acc` `l` join `co-operativebank-radhapur`.`shg_loan_dt` `s` where ((`s`.`acc_no` = `l`.`acc_no`) and ((`l`.`sub_head` = \'23113\') or (`l`.`sub_head` = \'23213\')) and (`s`.`date_of_loan_issue` <= \'2024-11-30\') and (`s`.`ID` = `l`.`id`)) group by `l`.`acc_no`
