TYPE=VIEW
query=select `a`.`lf_no` AS `lf_no`,`a`.`Acc_no` AS `acc_no`,max(`r`.`date_open`) AS `date_open`,max(`r`.`maturity_date`) AS `Maturity_Date`,`a`.`Maturity_Amount` AS `Maturity_Amount`,`a`.`Name` AS `name`,`ab`.`bal` AS `Principle_Amount`,`a`.`interest` AS `interest` from `co-operativebank-mohati`.`account` `a` join `co-operativebank-mohati`.`account_balance` `ab` join `co-operativebank-mohati`.`renew` `r` where ((`r`.`acc_no` = `a`.`Acc_no`) and (`r`.`acc_no` = `ab`.`acc_no`) and (`a`.`Acc_no` = `ab`.`acc_no`) and (`a`.`Date_open` > \'2000-01-01\') and (`r`.`date_open` <= \'2025-03-31\') and (`a`.`Acc_Type` = \'reinv\') and (`ab`.`bal` <> 0)) group by `r`.`acc_no`
md5=aec7c63bc1d462fc65f5fac150e23c40
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-06-20 12:09:52
create-version=1
source=SELECT  a.lf_no,a.acc_no, max(r.date_open) as date_open, max(r.Maturity_Date) as Maturity_Date,a.Maturity_Amount, a.name, ab.bal Principle_Amount, a.interest FROM account a, account_balance ab,renew r WHERE (r.acc_no = a.acc_no) And (r.acc_no = ab.acc_no)  And a.acc_no = ab.acc_no AND (a.date_open >  \'2000-01-01\' and r.date_open<=\'2025-03-31\') AND a.acc_type =\'reinv\' AND ab.bal <>0 group by r.acc_no
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `a`.`lf_no` AS `lf_no`,`a`.`Acc_no` AS `acc_no`,max(`r`.`date_open`) AS `date_open`,max(`r`.`maturity_date`) AS `Maturity_Date`,`a`.`Maturity_Amount` AS `Maturity_Amount`,`a`.`Name` AS `name`,`ab`.`bal` AS `Principle_Amount`,`a`.`interest` AS `interest` from `co-operativebank-mohati`.`account` `a` join `co-operativebank-mohati`.`account_balance` `ab` join `co-operativebank-mohati`.`renew` `r` where ((`r`.`acc_no` = `a`.`Acc_no`) and (`r`.`acc_no` = `ab`.`acc_no`) and (`a`.`Acc_no` = `ab`.`acc_no`) and (`a`.`Date_open` > \'2000-01-01\') and (`r`.`date_open` <= \'2025-03-31\') and (`a`.`Acc_Type` = \'reinv\') and (`ab`.`bal` <> 0)) group by `r`.`acc_no`
