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-238`.`loan_acc` `l` join `co-operativebank-238`.`j_a`) where ((`l`.`loan_against_sv_acc` = `j_a`.`Acc_No`) and (`l`.`date_open` >= \'2018-05-03\') and (`l`.`date_open` <= \'2019-03-31\') and (`l`.`sub_head` = \'23101B\')) group by `l`.`id`
md5=594dffbb4a348ff50cd101739b971baa
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2024-10-05 11:15:39
create-version=1
source=select  `l`.`id`  AS  `id` ,\n `l`.`date_open`  AS  `date_open` ,\n `l`.`acc_no`  AS  `acc_no` ,\n `l`.`loan_against_sv_acc`  AS  `loan_against_sv_acc` ,\n `j_a`.`name`  AS  `name` ,\n `l`.`amt`  AS  `amt` ,\nconcat(  `l`.`interest` ,  \'%\'  )  AS  `interest` ,\n `j_a`.`lf_no`  AS  `sblfno` ,\n `l`.`lf_no`  AS  `llfno` ,\n `j_a`.`father_name`  AS  `father_name` ,\n `j_a`.`address`  AS  `address` ,\n `j_a`.`bankacc`  AS  `bankacc` ,\n `j_a`.`mobile`  AS  `mobile` ,\n `j_a`.`adhar`  AS  `adhar` ,\n `j_a`.`status`  AS  `status` ,\n `j_a`.`pan`  AS  `pan` ,\n `j_a`.`voter`  AS  `voter` ,\n `j_a`.`cust`  AS  `cust` ,\n `j_a`.`gender`  AS  `gender` ,\n `j_a`.`dob`  AS  `dob` ,\n `j_a`.`block`  AS  `block`  from (  `co-operativebank-238`.`loan_acc`  `l`  join  `co-operativebank-238`.`j_a`  ) where ( (  `l`.`loan_against_sv_acc`  =  `j_a`.`Acc_No`  ) and (  `l`.`date_open`  >=  \'2018-05-03\' ) and (  `l`.`date_open`  <=  \'2019-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-238`.`loan_acc` `l` join `co-operativebank-238`.`j_a`) where ((`l`.`loan_against_sv_acc` = `j_a`.`Acc_No`) and (`l`.`date_open` >= \'2018-05-03\') and (`l`.`date_open` <= \'2019-03-31\') and (`l`.`sub_head` = \'23101B\')) group by `l`.`id`
