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-201`.`loan_acc` `l` where ((`l`.`sub_head` = \'23113\') and (`l`.`date_open` <= \'2024-01-31\')) group by `l`.`acc_no`
md5=857d1886e6692177c29329c5bd93b5f9
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2024-02-05 07: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 WHERE  l.sub_head=\'23113\' and l.date_open<=\'2024-01-31\' 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-201`.`loan_acc` `l` where ((`l`.`sub_head` = \'23113\') and (`l`.`date_open` <= \'2024-01-31\')) group by `l`.`acc_no`
