TYPE=VIEW
query=select `co-operativebank-198`.`loan_acc`.`sub_head` AS `sub_head`,max(`co-operativebank-198`.`loan_acc`.`id`) AS `id`,`co-operativebank-198`.`loan_acc`.`acc_no` AS `acc_no`,max(`co-operativebank-198`.`loan_acc`.`date_open`) AS `issue_date`,max(`co-operativebank-198`.`loan_acc`.`fianl_date`) AS `due_data`,max(`co-operativebank-198`.`loan_acc`.`amt`) AS `Loan_amount`,0 AS `gap_amt`,0 AS `crop_amt`,0 AS `from_chr`,0 AS `share_amt`,`co-operativebank-198`.`loan_acc`.`c_status` AS `c_status` from `co-operativebank-198`.`loan_acc` where (`co-operativebank-198`.`loan_acc`.`sub_head` = \'23101A\') group by `co-operativebank-198`.`loan_acc`.`acc_no`
md5=46560c62f55b001cedb07148ab707d4a
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-07-28 05:49:34
create-version=1
source=select  `co-operativebank-198`.`loan_acc`.`sub_head`  AS  `sub_head` ,\nmax(  `co-operativebank-198`.`loan_acc`.`id`  )  AS  `id` ,\n `co-operativebank-198`.`loan_acc`.`acc_no`  AS  `acc_no` ,\nmax(  `co-operativebank-198`.`loan_acc`.`date_open`  )  AS  `issue_date` ,\nmax(  `co-operativebank-198`.`loan_acc`.`fianl_date`  )  AS  `due_data` ,\nmax(  `co-operativebank-198`.`loan_acc`.`amt`  )  AS  `Loan_amount` ,\n0 AS  `gap_amt` ,\n0 AS  `crop_amt` ,\n0 AS  `from_chr` ,\n0 AS  `share_amt` ,\n `co-operativebank-198`.`loan_acc`.`c_status`  AS  `c_status`  from  `co-operativebank-198`.`loan_acc`  where (  `co-operativebank-198`.`loan_acc`.`sub_head`  =  \'23101A\' ) group  by  `co-operativebank-198`.`loan_acc`.`acc_no`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-198`.`loan_acc`.`sub_head` AS `sub_head`,max(`co-operativebank-198`.`loan_acc`.`id`) AS `id`,`co-operativebank-198`.`loan_acc`.`acc_no` AS `acc_no`,max(`co-operativebank-198`.`loan_acc`.`date_open`) AS `issue_date`,max(`co-operativebank-198`.`loan_acc`.`fianl_date`) AS `due_data`,max(`co-operativebank-198`.`loan_acc`.`amt`) AS `Loan_amount`,0 AS `gap_amt`,0 AS `crop_amt`,0 AS `from_chr`,0 AS `share_amt`,`co-operativebank-198`.`loan_acc`.`c_status` AS `c_status` from `co-operativebank-198`.`loan_acc` where (`co-operativebank-198`.`loan_acc`.`sub_head` = \'23101A\') group by `co-operativebank-198`.`loan_acc`.`acc_no`
