TYPE=VIEW
query=select `co-operativebank-durgapur`.`applicant`.`no` AS `no`,`co-operativebank-durgapur`.`applicant`.`code` AS `code`,`co-operativebank-durgapur`.`applicant`.`initial` AS `initial`,`co-operativebank-durgapur`.`applicant`.`fname` AS `fname`,`co-operativebank-durgapur`.`applicant`.`mname` AS `mname`,`co-operativebank-durgapur`.`applicant`.`lname` AS `lname`,`co-operativebank-durgapur`.`applicant`.`father_name` AS `father_name`,`co-operativebank-durgapur`.`applicant`.`gender` AS `gender`,`co-operativebank-durgapur`.`applicant`.`dob` AS `dob`,`co-operativebank-durgapur`.`applicant`.`address` AS `address`,`co-operativebank-durgapur`.`applicant`.`city` AS `city`,`co-operativebank-durgapur`.`applicant`.`state` AS `state`,`co-operativebank-durgapur`.`applicant`.`pin` AS `pin`,`co-operativebank-durgapur`.`applicant`.`mobile` AS `mobile`,`co-operativebank-durgapur`.`applicant`.`pan` AS `pan`,`co-operativebank-durgapur`.`applicant`.`adhar` AS `adhar`,`co-operativebank-durgapur`.`applicant`.`voter` AS `voter`,`co-operativebank-durgapur`.`applicant`.`occupation` AS `occupation`,`co-operativebank-durgapur`.`applicant`.`income` AS `income`,`co-operativebank-durgapur`.`applicant`.`verify` AS `verify`,`co-operativebank-durgapur`.`applicant`.`cust` AS `cust`,`co-operativebank-durgapur`.`applicant`.`Acc_No` AS `Acc_No`,concat(`co-operativebank-durgapur`.`applicant`.`initial`,\' \',`co-operativebank-durgapur`.`applicant`.`fname`,\' \',`co-operativebank-durgapur`.`applicant`.`mname`,\' \',`co-operativebank-durgapur`.`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`,(select `s`.`head` from `co-operativebank-durgapur`.`sub_head` `s` where (`dc`.`sub_head` = `s`.`code`)) AS `head`,`dc`.`date_open` AS `date_open` from (`co-operativebank-durgapur`.`applicant` join `co-operativebank-durgapur`.`deposit_acc` `dc`) where (`co-operativebank-durgapur`.`applicant`.`code` = `dc`.`app_code`) group by `co-operativebank-durgapur`.`applicant`.`Acc_No` union all select `co-operativebank-durgapur`.`applicant`.`no` AS `no`,`co-operativebank-durgapur`.`applicant`.`code` AS `code`,`co-operativebank-durgapur`.`applicant`.`initial` AS `initial`,`co-operativebank-durgapur`.`applicant`.`fname` AS `fname`,`co-operativebank-durgapur`.`applicant`.`mname` AS `mname`,`co-operativebank-durgapur`.`applicant`.`lname` AS `lname`,`co-operativebank-durgapur`.`applicant`.`father_name` AS `father_name`,`co-operativebank-durgapur`.`applicant`.`gender` AS `gender`,`co-operativebank-durgapur`.`applicant`.`dob` AS `dob`,`co-operativebank-durgapur`.`applicant`.`address` AS `address`,`co-operativebank-durgapur`.`applicant`.`city` AS `city`,`co-operativebank-durgapur`.`applicant`.`state` AS `state`,`co-operativebank-durgapur`.`applicant`.`pin` AS `pin`,`co-operativebank-durgapur`.`applicant`.`mobile` AS `mobile`,`co-operativebank-durgapur`.`applicant`.`pan` AS `pan`,`co-operativebank-durgapur`.`applicant`.`adhar` AS `adhar`,`co-operativebank-durgapur`.`applicant`.`voter` AS `voter`,`co-operativebank-durgapur`.`applicant`.`occupation` AS `occupation`,`co-operativebank-durgapur`.`applicant`.`income` AS `income`,`co-operativebank-durgapur`.`applicant`.`verify` AS `verify`,`co-operativebank-durgapur`.`applicant`.`cust` AS `cust`,`co-operativebank-durgapur`.`applicant`.`Acc_No` AS `Acc_No`,concat(`co-operativebank-durgapur`.`applicant`.`initial`,\' \',`co-operativebank-durgapur`.`applicant`.`fname`,\' \',`co-operativebank-durgapur`.`applicant`.`mname`,\' \',`co-operativebank-durgapur`.`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`,(select `s`.`head` from `co-operativebank-durgapur`.`sub_head` `s` where (`dc`.`sub_head` = `s`.`code`)) AS `head` from (`co-operativebank-durgapur`.`applicant` USE INDEX (`by_acc_no`) join `co-operativebank-durgapur`.`mstr_bnk_acc` `dc` USE INDEX (`by_acc_no`)) where (`co-operativebank-durgapur`.`applicant`.`Acc_No` = `dc`.`acc_no`) group by `co-operativebank-durgapur`.`applicant`.`Acc_No`
md5=902edb8068999347502f7edbc31e6654
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2026-02-17 05:16:30
create-version=1
source=select `applicant`.`no` AS `no`,`applicant`.`code` AS `code`,`applicant`.`initial` AS `initial`,`applicant`.`fname` AS `fname`,`applicant`.`mname` AS `mname`,`applicant`.`lname` AS `lname`,`applicant`.`father_name` AS `father_name`,`applicant`.`gender` AS `gender`,`applicant`.`dob` AS `dob`,`applicant`.`address` AS `address`,`applicant`.`city` AS `city`,`applicant`.`state` AS `state`,`applicant`.`pin` AS `pin`,`applicant`.`mobile` AS `mobile`,`applicant`.`pan` AS `pan`,`applicant`.`adhar` AS `adhar`,`applicant`.`voter` AS `voter`,`applicant`.`occupation` AS `occupation`,`applicant`.`income` AS `income`,`applicant`.`verify` AS `verify`,`applicant`.`cust` AS `cust`,`applicant`.`Acc_No` AS `Acc_No`,concat(`applicant`.`initial`,\' \',`applicant`.`fname`,\' \',`applicant`.`mname`,\' \',`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`,(select head from sub_head s where dc.sub_head=s.code) as head,dc.date_open from (`applicant` join `deposit_acc` `dc`) where (`applicant`.`code` = `dc`.`app_code`) group by `applicant`.`Acc_No` union all select `applicant`.`no` AS `no`,`applicant`.`code` AS `code`,`applicant`.`initial` AS `initial`,`applicant`.`fname` AS `fname`,`applicant`.`mname` AS `mname`,`applicant`.`lname` AS `lname`,`applicant`.`father_name` AS `father_name`,`applicant`.`gender` AS `gender`,`applicant`.`dob` AS `dob`,`applicant`.`address` AS `address`,`applicant`.`city` AS `city`,`applicant`.`state` AS `state`,`applicant`.`pin` AS `pin`,`applicant`.`mobile` AS `mobile`,`applicant`.`pan` AS `pan`,`applicant`.`adhar` AS `adhar`,`applicant`.`voter` AS `voter`,`applicant`.`occupation` AS `occupation`,`applicant`.`income` AS `income`,`applicant`.`verify` AS `verify`,`applicant`.`cust` AS `cust`,`applicant`.`Acc_No` AS `Acc_No`,concat(`applicant`.`initial`,\' \',`applicant`.`fname`,\' \',`applicant`.`mname`,\' \',`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,(select head from sub_head s where dc.sub_head=s.code) as head from (`applicant` USE INDEX (`by_acc_no`) join `mstr_bnk_acc` `dc` USE INDEX (`by_acc_no`)) where (`applicant`.`Acc_No` = `dc`.`acc_no`) group by `applicant`.`Acc_No`
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `co-operativebank-durgapur`.`applicant`.`no` AS `no`,`co-operativebank-durgapur`.`applicant`.`code` AS `code`,`co-operativebank-durgapur`.`applicant`.`initial` AS `initial`,`co-operativebank-durgapur`.`applicant`.`fname` AS `fname`,`co-operativebank-durgapur`.`applicant`.`mname` AS `mname`,`co-operativebank-durgapur`.`applicant`.`lname` AS `lname`,`co-operativebank-durgapur`.`applicant`.`father_name` AS `father_name`,`co-operativebank-durgapur`.`applicant`.`gender` AS `gender`,`co-operativebank-durgapur`.`applicant`.`dob` AS `dob`,`co-operativebank-durgapur`.`applicant`.`address` AS `address`,`co-operativebank-durgapur`.`applicant`.`city` AS `city`,`co-operativebank-durgapur`.`applicant`.`state` AS `state`,`co-operativebank-durgapur`.`applicant`.`pin` AS `pin`,`co-operativebank-durgapur`.`applicant`.`mobile` AS `mobile`,`co-operativebank-durgapur`.`applicant`.`pan` AS `pan`,`co-operativebank-durgapur`.`applicant`.`adhar` AS `adhar`,`co-operativebank-durgapur`.`applicant`.`voter` AS `voter`,`co-operativebank-durgapur`.`applicant`.`occupation` AS `occupation`,`co-operativebank-durgapur`.`applicant`.`income` AS `income`,`co-operativebank-durgapur`.`applicant`.`verify` AS `verify`,`co-operativebank-durgapur`.`applicant`.`cust` AS `cust`,`co-operativebank-durgapur`.`applicant`.`Acc_No` AS `Acc_No`,concat(`co-operativebank-durgapur`.`applicant`.`initial`,\' \',`co-operativebank-durgapur`.`applicant`.`fname`,\' \',`co-operativebank-durgapur`.`applicant`.`mname`,\' \',`co-operativebank-durgapur`.`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`,(select `s`.`head` from `co-operativebank-durgapur`.`sub_head` `s` where (`dc`.`sub_head` = `s`.`code`)) AS `head`,`dc`.`date_open` AS `date_open` from (`co-operativebank-durgapur`.`applicant` join `co-operativebank-durgapur`.`deposit_acc` `dc`) where (`co-operativebank-durgapur`.`applicant`.`code` = `dc`.`app_code`) group by `co-operativebank-durgapur`.`applicant`.`Acc_No` union all select `co-operativebank-durgapur`.`applicant`.`no` AS `no`,`co-operativebank-durgapur`.`applicant`.`code` AS `code`,`co-operativebank-durgapur`.`applicant`.`initial` AS `initial`,`co-operativebank-durgapur`.`applicant`.`fname` AS `fname`,`co-operativebank-durgapur`.`applicant`.`mname` AS `mname`,`co-operativebank-durgapur`.`applicant`.`lname` AS `lname`,`co-operativebank-durgapur`.`applicant`.`father_name` AS `father_name`,`co-operativebank-durgapur`.`applicant`.`gender` AS `gender`,`co-operativebank-durgapur`.`applicant`.`dob` AS `dob`,`co-operativebank-durgapur`.`applicant`.`address` AS `address`,`co-operativebank-durgapur`.`applicant`.`city` AS `city`,`co-operativebank-durgapur`.`applicant`.`state` AS `state`,`co-operativebank-durgapur`.`applicant`.`pin` AS `pin`,`co-operativebank-durgapur`.`applicant`.`mobile` AS `mobile`,`co-operativebank-durgapur`.`applicant`.`pan` AS `pan`,`co-operativebank-durgapur`.`applicant`.`adhar` AS `adhar`,`co-operativebank-durgapur`.`applicant`.`voter` AS `voter`,`co-operativebank-durgapur`.`applicant`.`occupation` AS `occupation`,`co-operativebank-durgapur`.`applicant`.`income` AS `income`,`co-operativebank-durgapur`.`applicant`.`verify` AS `verify`,`co-operativebank-durgapur`.`applicant`.`cust` AS `cust`,`co-operativebank-durgapur`.`applicant`.`Acc_No` AS `Acc_No`,concat(`co-operativebank-durgapur`.`applicant`.`initial`,\' \',`co-operativebank-durgapur`.`applicant`.`fname`,\' \',`co-operativebank-durgapur`.`applicant`.`mname`,\' \',`co-operativebank-durgapur`.`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`,(select `s`.`head` from `co-operativebank-durgapur`.`sub_head` `s` where (`dc`.`sub_head` = `s`.`code`)) AS `head` from (`co-operativebank-durgapur`.`applicant` USE INDEX (`by_acc_no`) join `co-operativebank-durgapur`.`mstr_bnk_acc` `dc` USE INDEX (`by_acc_no`)) where (`co-operativebank-durgapur`.`applicant`.`Acc_No` = `dc`.`acc_no`) group by `co-operativebank-durgapur`.`applicant`.`Acc_No`
