TYPE=VIEW
query=select `co-operativebank-242`.`applicant`.`no` AS `no`,`co-operativebank-242`.`applicant`.`code` AS `code`,`co-operativebank-242`.`applicant`.`initial` AS `initial`,`co-operativebank-242`.`applicant`.`fname` AS `fname`,`co-operativebank-242`.`applicant`.`mname` AS `mname`,`co-operativebank-242`.`applicant`.`lname` AS `lname`,`co-operativebank-242`.`applicant`.`father_name` AS `father_name`,`co-operativebank-242`.`applicant`.`gender` AS `gender`,`co-operativebank-242`.`applicant`.`dob` AS `dob`,`co-operativebank-242`.`applicant`.`address` AS `address`,`co-operativebank-242`.`applicant`.`city` AS `city`,`co-operativebank-242`.`applicant`.`state` AS `state`,`co-operativebank-242`.`applicant`.`pin` AS `pin`,`co-operativebank-242`.`applicant`.`mobile` AS `mobile`,`co-operativebank-242`.`applicant`.`pan` AS `pan`,`co-operativebank-242`.`applicant`.`adhar` AS `adhar`,`co-operativebank-242`.`applicant`.`voter` AS `voter`,`co-operativebank-242`.`applicant`.`occupation` AS `occupation`,`co-operativebank-242`.`applicant`.`income` AS `income`,`co-operativebank-242`.`applicant`.`verify` AS `verify`,`co-operativebank-242`.`applicant`.`cust` AS `cust`,`co-operativebank-242`.`applicant`.`Acc_No` AS `Acc_No`,concat(`co-operativebank-242`.`applicant`.`initial`,\' \',`co-operativebank-242`.`applicant`.`fname`,\' \',`co-operativebank-242`.`applicant`.`mname`,\' \',`co-operativebank-242`.`applicant`.`lname`) AS `name`,`dc`.`lf_no` AS `lf_no`,`dc`.`status` AS `status`,`dc`.`bankacc` AS `bankacc`,`dc`.`block` AS `block`,`dc`.`groupno` AS `groupno`,`dc`.`sub_head` AS `sub_head`,`dc`.`date_open` AS `date_open` from (`co-operativebank-242`.`applicant` join `co-operativebank-242`.`deposit_acc` `dc`) where (`co-operativebank-242`.`applicant`.`code` = `dc`.`app_code`) group by `co-operativebank-242`.`applicant`.`Acc_No` union all select `co-operativebank-242`.`applicant`.`no` AS `no`,`co-operativebank-242`.`applicant`.`code` AS `code`,`co-operativebank-242`.`applicant`.`initial` AS `initial`,`co-operativebank-242`.`applicant`.`fname` AS `fname`,`co-operativebank-242`.`applicant`.`mname` AS `mname`,`co-operativebank-242`.`applicant`.`lname` AS `lname`,`co-operativebank-242`.`applicant`.`father_name` AS `father_name`,`co-operativebank-242`.`applicant`.`gender` AS `gender`,`co-operativebank-242`.`applicant`.`dob` AS `dob`,`co-operativebank-242`.`applicant`.`address` AS `address`,`co-operativebank-242`.`applicant`.`city` AS `city`,`co-operativebank-242`.`applicant`.`state` AS `state`,`co-operativebank-242`.`applicant`.`pin` AS `pin`,`co-operativebank-242`.`applicant`.`mobile` AS `mobile`,`co-operativebank-242`.`applicant`.`pan` AS `pan`,`co-operativebank-242`.`applicant`.`adhar` AS `adhar`,`co-operativebank-242`.`applicant`.`voter` AS `voter`,`co-operativebank-242`.`applicant`.`occupation` AS `occupation`,`co-operativebank-242`.`applicant`.`income` AS `income`,`co-operativebank-242`.`applicant`.`verify` AS `verify`,`co-operativebank-242`.`applicant`.`cust` AS `cust`,`co-operativebank-242`.`applicant`.`Acc_No` AS `Acc_No`,concat(`co-operativebank-242`.`applicant`.`initial`,\' \',`co-operativebank-242`.`applicant`.`fname`,\' \',`co-operativebank-242`.`applicant`.`mname`,\' \',`co-operativebank-242`.`applicant`.`lname`) AS `name`,\'\' AS `lf_no`,`dc`.`status` AS `status`,\'\' AS `bankacc`,\'\' AS `block`,\'\' AS `groupno`,`dc`.`sub_head` AS `sub_head`,`dc`.`date_open` AS `date_open` from (`co-operativebank-242`.`applicant` USE INDEX (`by_acc_no`) join `co-operativebank-242`.`mstr_bnk_acc` `dc` USE INDEX (`by_acc_no`)) where (`co-operativebank-242`.`applicant`.`Acc_No` = `dc`.`acc_no`) group by `co-operativebank-242`.`applicant`.`Acc_No`
md5=7cec8bcdd5dcff167f4eb4d2c6038394
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-09-15 05:24:38
create-version=1
source=select  `co-operativebank-242`.`applicant`.`no`  AS  `no` ,\n `co-operativebank-242`.`applicant`.`code`  AS  `code` ,\n `co-operativebank-242`.`applicant`.`initial`  AS  `initial` ,\n `co-operativebank-242`.`applicant`.`fname`  AS  `fname` ,\n `co-operativebank-242`.`applicant`.`mname`  AS  `mname` ,\n `co-operativebank-242`.`applicant`.`lname`  AS  `lname` ,\n `co-operativebank-242`.`applicant`.`father_name`  AS  `father_name` ,\n `co-operativebank-242`.`applicant`.`gender`  AS  `gender` ,\n `co-operativebank-242`.`applicant`.`dob`  AS  `dob` ,\n `co-operativebank-242`.`applicant`.`address`  AS  `address` ,\n `co-operativebank-242`.`applicant`.`city`  AS  `city` ,\n `co-operativebank-242`.`applicant`.`state`  AS  `state` ,\n `co-operativebank-242`.`applicant`.`pin`  AS  `pin` ,\n `co-operativebank-242`.`applicant`.`mobile`  AS  `mobile` ,\n `co-operativebank-242`.`applicant`.`pan`  AS  `pan` ,\n `co-operativebank-242`.`applicant`.`adhar`  AS  `adhar` ,\n `co-operativebank-242`.`applicant`.`voter`  AS  `voter` ,\n `co-operativebank-242`.`applicant`.`occupation`  AS  `occupation` ,\n `co-operativebank-242`.`applicant`.`income`  AS  `income` ,\n `co-operativebank-242`.`applicant`.`verify`  AS  `verify` ,\n `co-operativebank-242`.`applicant`.`cust`  AS  `cust` ,\n `co-operativebank-242`.`applicant`.`Acc_No`  AS  `Acc_No` ,\nconcat(  `co-operativebank-242`.`applicant`.`initial` ,  \' \',  `co-operativebank-242`.`applicant`.`fname` ,  \' \',  `co-operativebank-242`.`applicant`.`mname` ,  \' \',  `co-operativebank-242`.`applicant`.`lname`  )  AS  `name` ,\n `dc`.`lf_no`  AS  `lf_no` ,\n `dc`.`status`  AS  `status` ,\n `dc`.`bankacc`  AS  `bankacc` ,\n `dc`.`block`  AS  `block` ,\n `dc`.`groupno`  AS  `groupno` ,\n `dc`.`sub_head`  AS  `sub_head` ,\n `dc`.`date_open`  AS  `date_open`  from (  `co-operativebank-242`.`applicant`  join  `co-operativebank-242`.`deposit_acc`  `dc`  ) where (  `co-operativebank-242`.`applicant`.`code`  =  `dc`.`app_code`  ) group  by  `co-operativebank-242`.`applicant`.`Acc_No`  union  all  select  `co-operativebank-242`.`applicant`.`no`  AS  `no` ,\n `co-operativebank-242`.`applicant`.`code`  AS  `code` ,\n `co-operativebank-242`.`applicant`.`initial`  AS  `initial` ,\n `co-operativebank-242`.`applicant`.`fname`  AS  `fname` ,\n `co-operativebank-242`.`applicant`.`mname`  AS  `mname` ,\n `co-operativebank-242`.`applicant`.`lname`  AS  `lname` ,\n `co-operativebank-242`.`applicant`.`father_name`  AS  `father_name` ,\n `co-operativebank-242`.`applicant`.`gender`  AS  `gender` ,\n `co-operativebank-242`.`applicant`.`dob`  AS  `dob` ,\n `co-operativebank-242`.`applicant`.`address`  AS  `address` ,\n `co-operativebank-242`.`applicant`.`city`  AS  `city` ,\n `co-operativebank-242`.`applicant`.`state`  AS  `state` ,\n `co-operativebank-242`.`applicant`.`pin`  AS  `pin` ,\n `co-operativebank-242`.`applicant`.`mobile`  AS  `mobile` ,\n `co-operativebank-242`.`applicant`.`pan`  AS  `pan` ,\n `co-operativebank-242`.`applicant`.`adhar`  AS  `adhar` ,\n `co-operativebank-242`.`applicant`.`voter`  AS  `voter` ,\n `co-operativebank-242`.`applicant`.`occupation`  AS  `occupation` ,\n `co-operativebank-242`.`applicant`.`income`  AS  `income` ,\n `co-operativebank-242`.`applicant`.`verify`  AS  `verify` ,\n `co-operativebank-242`.`applicant`.`cust`  AS  `cust` ,\n `co-operativebank-242`.`applicant`.`Acc_No`  AS  `Acc_No` ,\nconcat(  `co-operativebank-242`.`applicant`.`initial` ,  \' \',  `co-operativebank-242`.`applicant`.`fname` ,  \' \',  `co-operativebank-242`.`applicant`.`mname` ,  \' \',  `co-operativebank-242`.`applicant`.`lname`  )  AS  `name` ,\n \'\' AS  `lf_no` ,\n `dc`.`status`  AS  `status` ,\n \'\' AS  `bankacc` ,\n \'\' AS  `block` ,\n \'\' AS  `groupno` ,\n `dc`.`sub_head`  AS  `sub_head` ,\n `dc`.`date_open`  AS  `date_open`  from (  `co-operativebank-242`.`applicant`  USE  INDEX (  `by_acc_no`  )  join  `co-operativebank-242`.`mstr_bnk_acc`  `dc`  USE  INDEX (  `by_acc_no`  )  ) where (  `co-operativebank-242`.`applicant`.`Acc_No`  =  `dc`.`acc_no`  ) group  by  `co-operativebank-242`.`applicant`.`Acc_No`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-242`.`applicant`.`no` AS `no`,`co-operativebank-242`.`applicant`.`code` AS `code`,`co-operativebank-242`.`applicant`.`initial` AS `initial`,`co-operativebank-242`.`applicant`.`fname` AS `fname`,`co-operativebank-242`.`applicant`.`mname` AS `mname`,`co-operativebank-242`.`applicant`.`lname` AS `lname`,`co-operativebank-242`.`applicant`.`father_name` AS `father_name`,`co-operativebank-242`.`applicant`.`gender` AS `gender`,`co-operativebank-242`.`applicant`.`dob` AS `dob`,`co-operativebank-242`.`applicant`.`address` AS `address`,`co-operativebank-242`.`applicant`.`city` AS `city`,`co-operativebank-242`.`applicant`.`state` AS `state`,`co-operativebank-242`.`applicant`.`pin` AS `pin`,`co-operativebank-242`.`applicant`.`mobile` AS `mobile`,`co-operativebank-242`.`applicant`.`pan` AS `pan`,`co-operativebank-242`.`applicant`.`adhar` AS `adhar`,`co-operativebank-242`.`applicant`.`voter` AS `voter`,`co-operativebank-242`.`applicant`.`occupation` AS `occupation`,`co-operativebank-242`.`applicant`.`income` AS `income`,`co-operativebank-242`.`applicant`.`verify` AS `verify`,`co-operativebank-242`.`applicant`.`cust` AS `cust`,`co-operativebank-242`.`applicant`.`Acc_No` AS `Acc_No`,concat(`co-operativebank-242`.`applicant`.`initial`,\' \',`co-operativebank-242`.`applicant`.`fname`,\' \',`co-operativebank-242`.`applicant`.`mname`,\' \',`co-operativebank-242`.`applicant`.`lname`) AS `name`,`dc`.`lf_no` AS `lf_no`,`dc`.`status` AS `status`,`dc`.`bankacc` AS `bankacc`,`dc`.`block` AS `block`,`dc`.`groupno` AS `groupno`,`dc`.`sub_head` AS `sub_head`,`dc`.`date_open` AS `date_open` from (`co-operativebank-242`.`applicant` join `co-operativebank-242`.`deposit_acc` `dc`) where (`co-operativebank-242`.`applicant`.`code` = `dc`.`app_code`) group by `co-operativebank-242`.`applicant`.`Acc_No` union all select `co-operativebank-242`.`applicant`.`no` AS `no`,`co-operativebank-242`.`applicant`.`code` AS `code`,`co-operativebank-242`.`applicant`.`initial` AS `initial`,`co-operativebank-242`.`applicant`.`fname` AS `fname`,`co-operativebank-242`.`applicant`.`mname` AS `mname`,`co-operativebank-242`.`applicant`.`lname` AS `lname`,`co-operativebank-242`.`applicant`.`father_name` AS `father_name`,`co-operativebank-242`.`applicant`.`gender` AS `gender`,`co-operativebank-242`.`applicant`.`dob` AS `dob`,`co-operativebank-242`.`applicant`.`address` AS `address`,`co-operativebank-242`.`applicant`.`city` AS `city`,`co-operativebank-242`.`applicant`.`state` AS `state`,`co-operativebank-242`.`applicant`.`pin` AS `pin`,`co-operativebank-242`.`applicant`.`mobile` AS `mobile`,`co-operativebank-242`.`applicant`.`pan` AS `pan`,`co-operativebank-242`.`applicant`.`adhar` AS `adhar`,`co-operativebank-242`.`applicant`.`voter` AS `voter`,`co-operativebank-242`.`applicant`.`occupation` AS `occupation`,`co-operativebank-242`.`applicant`.`income` AS `income`,`co-operativebank-242`.`applicant`.`verify` AS `verify`,`co-operativebank-242`.`applicant`.`cust` AS `cust`,`co-operativebank-242`.`applicant`.`Acc_No` AS `Acc_No`,concat(`co-operativebank-242`.`applicant`.`initial`,\' \',`co-operativebank-242`.`applicant`.`fname`,\' \',`co-operativebank-242`.`applicant`.`mname`,\' \',`co-operativebank-242`.`applicant`.`lname`) AS `name`,\'\' AS `lf_no`,`dc`.`status` AS `status`,\'\' AS `bankacc`,\'\' AS `block`,\'\' AS `groupno`,`dc`.`sub_head` AS `sub_head`,`dc`.`date_open` AS `date_open` from (`co-operativebank-242`.`applicant` USE INDEX (`by_acc_no`) join `co-operativebank-242`.`mstr_bnk_acc` `dc` USE INDEX (`by_acc_no`)) where (`co-operativebank-242`.`applicant`.`Acc_No` = `dc`.`acc_no`) group by `co-operativebank-242`.`applicant`.`Acc_No`
