TYPE=VIEW
query=select `s`.`date_open` AS `date_open`,`s`.`acc_no` AS `acc_no`,`s`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`s`.`name` AS `name`,`s`.`amt` AS `amt`,`s`.`interest` AS `interest`,`s1`.`int_amt` AS `int_amt`,`s1`.`max_dt` AS `max_dt`,`s1`.`subsidy` AS `subsidy`,`s1`.`Due_Amt` AS `Due_Amt`,`s`.`sblfno` AS `sblfno`,`s`.`llfno` AS `llfno`,`s`.`father_name` AS `father_name`,`s`.`address` AS `address`,`s`.`bankacc` AS `bankacc`,`s`.`mobile` AS `mobile`,`s`.`adhar` AS `adhar`,`s`.`status` AS `status`,`s`.`pan` AS `pan`,`s`.`voter` AS `voter`,`s`.`cust` AS `cust`,`s`.`gender` AS `gender`,`s`.`dob` AS `dob`,`s`.`block` AS `block` from (`co-operativebank-dekhaliannapurna`.`subidy` `s` join `co-operativebank-dekhaliannapurna`.`subidy1` `s1`) where ((`s`.`id` = `s1`.`loan_id`) and (`s`.`amt` = `s1`.`prince`)) order by `s1`.`acc_no`
md5=f59bf9828feec138a9fc78cad7b90c39
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-03-17 09:50:42
create-version=1
source=select `s`.`date_open` AS `date_open`,`s`.`acc_no` AS `acc_no`,`s`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`s`.`name` AS `name`,`s`.`amt` AS `amt`,`s`.`interest` AS `interest`,`s1`.`int_amt` AS `int_amt`,`s1`.`max_dt` AS `max_dt`,`s1`.`subsidy` AS `subsidy`,Due_Amt,sblfno,llfno,father_name,address,s.bankacc,mobile,adhar,s.status,pan,voter,cust,gender,dob,block from (`subidy` `s` join `subidy1` `s1`) where ((`s`.`id` = `s1`.`loan_id`) and (`s`.`amt` = `s1`.`prince`)) ORDER BY s1.`acc_no` ASC
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `s`.`date_open` AS `date_open`,`s`.`acc_no` AS `acc_no`,`s`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`s`.`name` AS `name`,`s`.`amt` AS `amt`,`s`.`interest` AS `interest`,`s1`.`int_amt` AS `int_amt`,`s1`.`max_dt` AS `max_dt`,`s1`.`subsidy` AS `subsidy`,`s1`.`Due_Amt` AS `Due_Amt`,`s`.`sblfno` AS `sblfno`,`s`.`llfno` AS `llfno`,`s`.`father_name` AS `father_name`,`s`.`address` AS `address`,`s`.`bankacc` AS `bankacc`,`s`.`mobile` AS `mobile`,`s`.`adhar` AS `adhar`,`s`.`status` AS `status`,`s`.`pan` AS `pan`,`s`.`voter` AS `voter`,`s`.`cust` AS `cust`,`s`.`gender` AS `gender`,`s`.`dob` AS `dob`,`s`.`block` AS `block` from (`co-operativebank-dekhaliannapurna`.`subidy` `s` join `co-operativebank-dekhaliannapurna`.`subidy1` `s1`) where ((`s`.`id` = `s1`.`loan_id`) and (`s`.`amt` = `s1`.`prince`)) order by `s1`.`acc_no`
