TYPE=VIEW
query=select `s`.`SB_accno` AS `SB_accno`,`s`.`ID` AS `ID`,`s`.`acc_no` AS `acc_no`,`s`.`amt_of_loan_issue` AS `amt_of_loan_issue`,`s`.`date_of_loan_issue` AS `date_of_loan_issue`,`s`.`Purpose` AS `Purpose`,round((`s`.`amt_of_loan_issue` - sum(`ld`.`Total_amt`)),2) AS `Amt_of_Loan_os`,round(((sum(`ld`.`Total_amt`) / `s`.`amt_of_loan_issue`) * 100),2) AS `Recovery_amt` from `co-operativebank-henria`.`shg_monthly_report2` `s` join `co-operativebank-henria`.`loan_deposit` `ld` where ((`ld`.`loan_id` = `s`.`ID`) and (`ld`.`Date` <= \'2024-02-06\')) group by `s`.`acc_no`
md5=a88046c309f73c96ebb718854c75044d
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2024-02-06 03:07:48
create-version=1
source=SELECT s.*,round(amt_of_loan_issue-sum(total_amt),2) as Amt_of_Loan_os,round(((sum(Total_amt)/amt_of_loan_issue)*100),2) as Recovery_amt FROM `shg_monthly_report2` s,loan_deposit ld WHERE ld.loan_id=s.id and date<=\'2024-02-06\' group by s.acc_no
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `s`.`SB_accno` AS `SB_accno`,`s`.`ID` AS `ID`,`s`.`acc_no` AS `acc_no`,`s`.`amt_of_loan_issue` AS `amt_of_loan_issue`,`s`.`date_of_loan_issue` AS `date_of_loan_issue`,`s`.`Purpose` AS `Purpose`,round((`s`.`amt_of_loan_issue` - sum(`ld`.`Total_amt`)),2) AS `Amt_of_Loan_os`,round(((sum(`ld`.`Total_amt`) / `s`.`amt_of_loan_issue`) * 100),2) AS `Recovery_amt` from `co-operativebank-henria`.`shg_monthly_report2` `s` join `co-operativebank-henria`.`loan_deposit` `ld` where ((`ld`.`loan_id` = `s`.`ID`) and (`ld`.`Date` <= \'2024-02-06\')) group by `s`.`acc_no`
