TYPE=VIEW
query=select `l`.`loan_against_sv_acc` AS `SB_accno`,max(`l`.`id`) AS `ID`,`l`.`acc_no` AS `acc_no`,max(`l`.`date_open`) AS `date_of_loan_issue` from `co-operativebank-dkmadhabpur`.`loan_acc` `l` where ((`l`.`status` = \'Active\') and ((`l`.`sub_head` = \'23113\') or (`l`.`sub_head` = \'23213\')) and (`l`.`date_open` <= \'2025-01-07\')) group by `l`.`acc_no`
md5=97fbbd73b9813815dc690ba16b78eed3
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-01-07 06:15:13
create-version=1
source=SELECT loan_against_sv_acc as SB_accno,max(l.id) AS ID,l.acc_no,max(date_open) as date_of_loan_issue FROM `loan_acc`l WHERE l.status=\'Active\' and (l.sub_head=\'23113\' or l.sub_head=\'23213\') and l.date_open<=\'2025-01-07\' 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`,max(`l`.`date_open`) AS `date_of_loan_issue` from `co-operativebank-dkmadhabpur`.`loan_acc` `l` where ((`l`.`status` = \'Active\') and ((`l`.`sub_head` = \'23113\') or (`l`.`sub_head` = \'23213\')) and (`l`.`date_open` <= \'2025-01-07\')) group by `l`.`acc_no`
