TYPE=VIEW
query=select `s1`.`slno` AS `slno`,`s1`.`SB_ac_no` AS `SB_ac_no`,`s1`.`name_of_group` AS `name_of_group`,`s1`.`female_member` AS `female_member`,`s1`.`total_member` AS `total_member`,`s1`.`Account_opeing` AS `Account_opeing`,`s1`.`Amount_deposit` AS `Amount_deposit`,`s1`.`this_month_deposit` AS `this_month_deposit`,`s3`.`SB_accno` AS `SB_accno`,`s3`.`ID` AS `ID`,`s3`.`acc_no` AS `acc_no`,`s3`.`amt_of_loan_issue` AS `amt_of_loan_issue`,`s3`.`date_of_loan_issue` AS `date_of_loan_issue`,`s3`.`Purpose` AS `Purpose`,`s3`.`Amt_of_Loan_os` AS `Amt_of_Loan_os`,`s3`.`Recovery_amt` AS `Recovery_amt` from `co-operativebank-234`.`shg_monthly_report1` `s1` join `co-operativebank-234`.`shg_monthly_report3` `s3` where (`s1`.`SB_ac_no` = `s3`.`SB_accno`) union all select `s1`.`slno` AS `slno`,`s1`.`SB_ac_no` AS `SB_ac_no`,`s1`.`name_of_group` AS `name_of_group`,`s1`.`female_member` AS `female_member`,`s1`.`total_member` AS `total_member`,`s1`.`Account_opeing` AS `Account_opeing`,`s1`.`Amount_deposit` AS `Amount_deposit`,`s1`.`this_month_deposit` AS `this_month_deposit`,`s1`.`SB_ac_no` AS `SB_accno`,\'\' AS `ID`,\'\' AS `acc_no`,\'\' AS `amt_of_loan_issue`,\'\' AS `date_of_loan_issue`,\'\' AS `Purpose`,\'\' AS `Amt_of_Loan_os`,\'\' AS `Recovery_amt` from `co-operativebank-234`.`shg_monthly_report1` `s1` where ((`s1`.`name_of_group` <> \'\') and (not(exists(select 1 from `co-operativebank-234`.`shg_monthly_report3` `s3` where (`s1`.`SB_ac_no` = `s3`.`SB_accno`)))))
md5=55e2d596eaf242fc0dc5ef5f00d95c48
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-07-03 06:16:29
create-version=1
source=SELECT  s1.*,s3.* FROM `shg_monthly_report1` s1, shg_monthly_report3 s3   WHERE s1.SB_ac_no=s3.`SB_accno` union all SELECT  s1.*,SB_ac_no as SB_accno,\'\' as ID,\'\' as acc_no,\'\' as amt_of_loan_issue,\'\' as date_of_loan_issue,\'\'as Purpose,\'\' as Amt_of_Loan_os,\'\' as Recovery_amt FROM `shg_monthly_report1` s1   WHERE name_of_group<>\'\'  and not EXISTS (SELECT s3.* from shg_monthly_report3 s3 WHERE   s1.SB_ac_no = s3.`SB_accno`  )
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `s1`.`slno` AS `slno`,`s1`.`SB_ac_no` AS `SB_ac_no`,`s1`.`name_of_group` AS `name_of_group`,`s1`.`female_member` AS `female_member`,`s1`.`total_member` AS `total_member`,`s1`.`Account_opeing` AS `Account_opeing`,`s1`.`Amount_deposit` AS `Amount_deposit`,`s1`.`this_month_deposit` AS `this_month_deposit`,`s3`.`SB_accno` AS `SB_accno`,`s3`.`ID` AS `ID`,`s3`.`acc_no` AS `acc_no`,`s3`.`amt_of_loan_issue` AS `amt_of_loan_issue`,`s3`.`date_of_loan_issue` AS `date_of_loan_issue`,`s3`.`Purpose` AS `Purpose`,`s3`.`Amt_of_Loan_os` AS `Amt_of_Loan_os`,`s3`.`Recovery_amt` AS `Recovery_amt` from `co-operativebank-234`.`shg_monthly_report1` `s1` join `co-operativebank-234`.`shg_monthly_report3` `s3` where (`s1`.`SB_ac_no` = `s3`.`SB_accno`) union all select `s1`.`slno` AS `slno`,`s1`.`SB_ac_no` AS `SB_ac_no`,`s1`.`name_of_group` AS `name_of_group`,`s1`.`female_member` AS `female_member`,`s1`.`total_member` AS `total_member`,`s1`.`Account_opeing` AS `Account_opeing`,`s1`.`Amount_deposit` AS `Amount_deposit`,`s1`.`this_month_deposit` AS `this_month_deposit`,`s1`.`SB_ac_no` AS `SB_accno`,\'\' AS `ID`,\'\' AS `acc_no`,\'\' AS `amt_of_loan_issue`,\'\' AS `date_of_loan_issue`,\'\' AS `Purpose`,\'\' AS `Amt_of_Loan_os`,\'\' AS `Recovery_amt` from `co-operativebank-234`.`shg_monthly_report1` `s1` where ((`s1`.`name_of_group` <> \'\') and (not(exists(select 1 from `co-operativebank-234`.`shg_monthly_report3` `s3` where (`s1`.`SB_ac_no` = `s3`.`SB_accno`)))))
