TYPE=VIEW
query=select `co-operativebank-221`.`applicant`.`no` AS `no`,`co-operativebank-221`.`applicant`.`code` AS `code`,`co-operativebank-221`.`applicant`.`initial` AS `initial`,`co-operativebank-221`.`applicant`.`fname` AS `fname`,`co-operativebank-221`.`applicant`.`mname` AS `mname`,`co-operativebank-221`.`applicant`.`lname` AS `lname`,`co-operativebank-221`.`applicant`.`father_name` AS `father_name`,`co-operativebank-221`.`applicant`.`gender` AS `gender`,`co-operativebank-221`.`applicant`.`dob` AS `dob`,`co-operativebank-221`.`applicant`.`address` AS `address`,`co-operativebank-221`.`applicant`.`city` AS `city`,`co-operativebank-221`.`applicant`.`state` AS `state`,`co-operativebank-221`.`applicant`.`pin` AS `pin`,`co-operativebank-221`.`applicant`.`mobile` AS `mobile`,`co-operativebank-221`.`applicant`.`pan` AS `pan`,`co-operativebank-221`.`applicant`.`adhar` AS `adhar`,`co-operativebank-221`.`applicant`.`voter` AS `voter`,`co-operativebank-221`.`applicant`.`occupation` AS `occupation`,`co-operativebank-221`.`applicant`.`income` AS `income`,`co-operativebank-221`.`applicant`.`verify` AS `verify`,`co-operativebank-221`.`applicant`.`cust` AS `cust`,`co-operativebank-221`.`applicant`.`Acc_No` AS `Acc_No`,concat(`co-operativebank-221`.`applicant`.`initial`,\' \',`co-operativebank-221`.`applicant`.`fname`,\' \',`co-operativebank-221`.`applicant`.`mname`,\' \',`co-operativebank-221`.`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-221`.`applicant` join `co-operativebank-221`.`deposit_acc` `dc`) where (`co-operativebank-221`.`applicant`.`code` = `dc`.`app_code`) group by `co-operativebank-221`.`applicant`.`Acc_No` union all select `co-operativebank-221`.`applicant`.`no` AS `no`,`co-operativebank-221`.`applicant`.`code` AS `code`,`co-operativebank-221`.`applicant`.`initial` AS `initial`,`co-operativebank-221`.`applicant`.`fname` AS `fname`,`co-operativebank-221`.`applicant`.`mname` AS `mname`,`co-operativebank-221`.`applicant`.`lname` AS `lname`,`co-operativebank-221`.`applicant`.`father_name` AS `father_name`,`co-operativebank-221`.`applicant`.`gender` AS `gender`,`co-operativebank-221`.`applicant`.`dob` AS `dob`,`co-operativebank-221`.`applicant`.`address` AS `address`,`co-operativebank-221`.`applicant`.`city` AS `city`,`co-operativebank-221`.`applicant`.`state` AS `state`,`co-operativebank-221`.`applicant`.`pin` AS `pin`,`co-operativebank-221`.`applicant`.`mobile` AS `mobile`,`co-operativebank-221`.`applicant`.`pan` AS `pan`,`co-operativebank-221`.`applicant`.`adhar` AS `adhar`,`co-operativebank-221`.`applicant`.`voter` AS `voter`,`co-operativebank-221`.`applicant`.`occupation` AS `occupation`,`co-operativebank-221`.`applicant`.`income` AS `income`,`co-operativebank-221`.`applicant`.`verify` AS `verify`,`co-operativebank-221`.`applicant`.`cust` AS `cust`,`co-operativebank-221`.`applicant`.`Acc_No` AS `Acc_No`,concat(`co-operativebank-221`.`applicant`.`initial`,\' \',`co-operativebank-221`.`applicant`.`fname`,\' \',`co-operativebank-221`.`applicant`.`mname`,\' \',`co-operativebank-221`.`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-221`.`applicant` USE INDEX (`by_acc_no`) join `co-operativebank-221`.`mstr_bnk_acc` `dc` USE INDEX (`by_acc_no`)) where (`co-operativebank-221`.`applicant`.`Acc_No` = `dc`.`acc_no`) group by `co-operativebank-221`.`applicant`.`Acc_No`
md5=fea982d36742e49c42edd3a67caefa33
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-04-29 12:54:21
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`,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 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=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-221`.`applicant`.`no` AS `no`,`co-operativebank-221`.`applicant`.`code` AS `code`,`co-operativebank-221`.`applicant`.`initial` AS `initial`,`co-operativebank-221`.`applicant`.`fname` AS `fname`,`co-operativebank-221`.`applicant`.`mname` AS `mname`,`co-operativebank-221`.`applicant`.`lname` AS `lname`,`co-operativebank-221`.`applicant`.`father_name` AS `father_name`,`co-operativebank-221`.`applicant`.`gender` AS `gender`,`co-operativebank-221`.`applicant`.`dob` AS `dob`,`co-operativebank-221`.`applicant`.`address` AS `address`,`co-operativebank-221`.`applicant`.`city` AS `city`,`co-operativebank-221`.`applicant`.`state` AS `state`,`co-operativebank-221`.`applicant`.`pin` AS `pin`,`co-operativebank-221`.`applicant`.`mobile` AS `mobile`,`co-operativebank-221`.`applicant`.`pan` AS `pan`,`co-operativebank-221`.`applicant`.`adhar` AS `adhar`,`co-operativebank-221`.`applicant`.`voter` AS `voter`,`co-operativebank-221`.`applicant`.`occupation` AS `occupation`,`co-operativebank-221`.`applicant`.`income` AS `income`,`co-operativebank-221`.`applicant`.`verify` AS `verify`,`co-operativebank-221`.`applicant`.`cust` AS `cust`,`co-operativebank-221`.`applicant`.`Acc_No` AS `Acc_No`,concat(`co-operativebank-221`.`applicant`.`initial`,\' \',`co-operativebank-221`.`applicant`.`fname`,\' \',`co-operativebank-221`.`applicant`.`mname`,\' \',`co-operativebank-221`.`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-221`.`applicant` join `co-operativebank-221`.`deposit_acc` `dc`) where (`co-operativebank-221`.`applicant`.`code` = `dc`.`app_code`) group by `co-operativebank-221`.`applicant`.`Acc_No` union all select `co-operativebank-221`.`applicant`.`no` AS `no`,`co-operativebank-221`.`applicant`.`code` AS `code`,`co-operativebank-221`.`applicant`.`initial` AS `initial`,`co-operativebank-221`.`applicant`.`fname` AS `fname`,`co-operativebank-221`.`applicant`.`mname` AS `mname`,`co-operativebank-221`.`applicant`.`lname` AS `lname`,`co-operativebank-221`.`applicant`.`father_name` AS `father_name`,`co-operativebank-221`.`applicant`.`gender` AS `gender`,`co-operativebank-221`.`applicant`.`dob` AS `dob`,`co-operativebank-221`.`applicant`.`address` AS `address`,`co-operativebank-221`.`applicant`.`city` AS `city`,`co-operativebank-221`.`applicant`.`state` AS `state`,`co-operativebank-221`.`applicant`.`pin` AS `pin`,`co-operativebank-221`.`applicant`.`mobile` AS `mobile`,`co-operativebank-221`.`applicant`.`pan` AS `pan`,`co-operativebank-221`.`applicant`.`adhar` AS `adhar`,`co-operativebank-221`.`applicant`.`voter` AS `voter`,`co-operativebank-221`.`applicant`.`occupation` AS `occupation`,`co-operativebank-221`.`applicant`.`income` AS `income`,`co-operativebank-221`.`applicant`.`verify` AS `verify`,`co-operativebank-221`.`applicant`.`cust` AS `cust`,`co-operativebank-221`.`applicant`.`Acc_No` AS `Acc_No`,concat(`co-operativebank-221`.`applicant`.`initial`,\' \',`co-operativebank-221`.`applicant`.`fname`,\' \',`co-operativebank-221`.`applicant`.`mname`,\' \',`co-operativebank-221`.`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-221`.`applicant` USE INDEX (`by_acc_no`) join `co-operativebank-221`.`mstr_bnk_acc` `dc` USE INDEX (`by_acc_no`)) where (`co-operativebank-221`.`applicant`.`Acc_No` = `dc`.`acc_no`) group by `co-operativebank-221`.`applicant`.`Acc_No`
