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-bajbajia`.`shg_monthly_report2` `s` join `co-operativebank-bajbajia`.`loan_deposit` `ld` where ((`ld`.`loan_id` = `s`.`ID`) and (`ld`.`Date` <= \'2026-01-07\')) group by `s`.`acc_no`
md5=10c3f29f835e103b3d267b9891f39f39
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-01-07 04:37:46
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<=\'2026-01-07\' 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-bajbajia`.`shg_monthly_report2` `s` join `co-operativebank-bajbajia`.`loan_deposit` `ld` where ((`ld`.`loan_id` = `s`.`ID`) and (`ld`.`Date` <= \'2026-01-07\')) group by `s`.`acc_no`
