TYPE=VIEW
query=select `co-operativebank-radhapur`.`loan_acc`.`acc_no` AS `acc_no`,`co-operativebank-radhapur`.`loan_acc`.`sub_head` AS `sub_head`,max(`co-operativebank-radhapur`.`loan_acc`.`fianl_date`) AS `fianl_date`,`co-operativebank-radhapur`.`loan_acc`.`loan_against_sv_acc` AS `loan_against_sv_acc`,max(`co-operativebank-radhapur`.`loan_acc`.`date_open`) AS `date_open`,max(`co-operativebank-radhapur`.`loan_acc`.`id`) AS `id` from `co-operativebank-radhapur`.`loan_acc` group by `co-operativebank-radhapur`.`loan_acc`.`acc_no`,`co-operativebank-radhapur`.`loan_acc`.`sub_head`
md5=aa16cab71c62411f0c7918fca3f7421a
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-05-13 07:59:07
create-version=1
source=select acc_no,sub_head,max(fianl_date) as fianl_date,loan_against_sv_acc,max(date_open) as date_open,max(id) as id from `loan_acc` group by `loan_acc`.`acc_no`,`loan_acc`.`sub_head`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-radhapur`.`loan_acc`.`acc_no` AS `acc_no`,`co-operativebank-radhapur`.`loan_acc`.`sub_head` AS `sub_head`,max(`co-operativebank-radhapur`.`loan_acc`.`fianl_date`) AS `fianl_date`,`co-operativebank-radhapur`.`loan_acc`.`loan_against_sv_acc` AS `loan_against_sv_acc`,max(`co-operativebank-radhapur`.`loan_acc`.`date_open`) AS `date_open`,max(`co-operativebank-radhapur`.`loan_acc`.`id`) AS `id` from `co-operativebank-radhapur`.`loan_acc` group by `co-operativebank-radhapur`.`loan_acc`.`acc_no`,`co-operativebank-radhapur`.`loan_acc`.`sub_head`
