TYPE=VIEW
query=select `l`.`id` AS `id`,`l`.`date_open` AS `date_open`,`l`.`acc_no` AS `acc_no`,`l`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`j_a`.`name` AS `name`,`l`.`amt` AS `amt`,concat(`l`.`interest`,\'%\') AS `interest`,`j_a`.`lf_no` AS `sblfno`,`l`.`lf_no` AS `llfno`,`j_a`.`father_name` AS `father_name`,`j_a`.`address` AS `address`,`j_a`.`bankacc` AS `bankacc`,`j_a`.`mobile` AS `mobile`,`j_a`.`adhar` AS `adhar`,`j_a`.`status` AS `status`,`j_a`.`pan` AS `pan`,`j_a`.`voter` AS `voter`,`j_a`.`cust` AS `cust`,`j_a`.`gender` AS `gender`,`j_a`.`dob` AS `dob`,`j_a`.`block` AS `block` from `co-operativebank-radhapur`.`loan_acc` `l` join `co-operativebank-radhapur`.`j_a` where ((`l`.`loan_against_sv_acc` = `j_a`.`Acc_No`) and (`l`.`date_open` >= \'2024-04-01\') and (`l`.`date_open` <= \'2025-03-31\') and (`l`.`sub_head` = \'23101B\')) group by `l`.`id`
md5=0f2ea6e46d857b830495d4e9c3ead4f8
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2025-06-03 05:55:32
create-version=1
source=select l.id,l.date_open,l.acc_no,loan_against_sv_acc,name,amt,concat(interest,\'%\') as interest,j_a.lf_no as sblfno,l.lf_no as llfno,father_name,address,j_a.bankacc,mobile,adhar,j_a.status,pan,voter,cust,gender,dob,block FROM `loan_acc` l,j_a WHERE loan_against_sv_acc=j_a.acc_no and  l.date_open>=\'2024-04-01\' and l.date_open<=\'2025-03-31\' and l.sub_head=\'23101B\' group by l.id
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `l`.`id` AS `id`,`l`.`date_open` AS `date_open`,`l`.`acc_no` AS `acc_no`,`l`.`loan_against_sv_acc` AS `loan_against_sv_acc`,`j_a`.`name` AS `name`,`l`.`amt` AS `amt`,concat(`l`.`interest`,\'%\') AS `interest`,`j_a`.`lf_no` AS `sblfno`,`l`.`lf_no` AS `llfno`,`j_a`.`father_name` AS `father_name`,`j_a`.`address` AS `address`,`j_a`.`bankacc` AS `bankacc`,`j_a`.`mobile` AS `mobile`,`j_a`.`adhar` AS `adhar`,`j_a`.`status` AS `status`,`j_a`.`pan` AS `pan`,`j_a`.`voter` AS `voter`,`j_a`.`cust` AS `cust`,`j_a`.`gender` AS `gender`,`j_a`.`dob` AS `dob`,`j_a`.`block` AS `block` from `co-operativebank-radhapur`.`loan_acc` `l` join `co-operativebank-radhapur`.`j_a` where ((`l`.`loan_against_sv_acc` = `j_a`.`Acc_No`) and (`l`.`date_open` >= \'2024-04-01\') and (`l`.`date_open` <= \'2025-03-31\') and (`l`.`sub_head` = \'23101B\')) group by `l`.`id`
