TYPE=VIEW
query=select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank-mitrachak`.`deposit_acc` `d` join `co-operativebank-mitrachak`.`applicant` `a`) where (`d`.`fd_sv_acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `l`.`code` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank-mitrachak`.`income` `l` join `co-operativebank-mitrachak`.`applicant` `a`) where ((`a`.`Acc_No` = `l`.`code`) and (`l`.`shlip_no` like \'SV-D%\')) group by `l`.`code` union all select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank-mitrachak`.`loan_acc` `d` join `co-operativebank-mitrachak`.`applicant` `a`) where (`d`.`loan_against_sv_acc` = `a`.`Acc_No`) group by `d`.`acc_no` union all select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank-mitrachak`.`mstr_bnk_acc` `d` join `co-operativebank-mitrachak`.`applicant` `a`) where (`d`.`acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `d`.`code` AS `code`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank-mitrachak`.`shares` `d` join `co-operativebank-mitrachak`.`applicant` `a`) where (`d`.`acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`co-operativebank-mitrachak`.`income` `i` join `co-operativebank-mitrachak`.`sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'INC%\')) union all select `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`co-operativebank-mitrachak`.`libities` `i` join `co-operativebank-mitrachak`.`sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'LIB%\'))
md5=a086174c78b4e58d36377d8c7c5a8d64
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-05-30 04:21:26
create-version=1
source=select  `d`.`acc_no`  AS  `acc_no` ,\nconcat(  `a`.`fname` ,  \' \',  `a`.`mname` ,  \' \',  `a`.`lname`  )  AS  `name`  from (  `co-operativebank-mitrachak`.`deposit_acc`  `d`  join  `co-operativebank-mitrachak`.`applicant`  `a`  ) where (  `d`.`fd_sv_acc_no`  =  `a`.`Acc_No`  ) group  by  `a`.`Acc_No`  union  all  select  `l`.`code`  AS  `acc_no` ,\nconcat(  `a`.`fname` ,  \' \',  `a`.`mname` ,  \' \',  `a`.`lname`  )  AS  `name`  from (  `co-operativebank-mitrachak`.`income`  `l`  join  `co-operativebank-mitrachak`.`applicant`  `a`  ) where ( (  `a`.`Acc_No`  =  `l`.`code`  ) and (  `l`.`shlip_no`  like  \'SV-D%\' ) ) group  by  `l`.`code`  union  all  select  `d`.`acc_no`  AS  `acc_no` ,\nconcat(  `a`.`fname` ,  \' \',  `a`.`mname` ,  \' \',  `a`.`lname`  )  AS  `name`  from (  `co-operativebank-mitrachak`.`loan_acc`  `d`  join  `co-operativebank-mitrachak`.`applicant`  `a`  ) where (  `d`.`loan_against_sv_acc`  =  `a`.`Acc_No`  ) group  by  `d`.`acc_no`  union  all  select  `d`.`acc_no`  AS  `acc_no` ,\nconcat(  `a`.`fname` ,  \' \',  `a`.`mname` ,  \' \',  `a`.`lname`  )  AS  `name`  from (  `co-operativebank-mitrachak`.`mstr_bnk_acc`  `d`  join  `co-operativebank-mitrachak`.`applicant`  `a`  ) where (  `d`.`acc_no`  =  `a`.`Acc_No`  ) group  by  `a`.`Acc_No`  union  all  select  `d`.`code`  AS  `code` ,\nconcat(  `a`.`fname` ,  \' \',  `a`.`mname` ,  \' \',  `a`.`lname`  )  AS  `name`  from (  `co-operativebank-mitrachak`.`shares`  `d`  join  `co-operativebank-mitrachak`.`applicant`  `a`  ) where (  `d`.`acc_no`  =  `a`.`Acc_No`  ) group  by  `a`.`Acc_No`  union  all  select  `i`.`code`  AS  `acc_no` ,\nif( (  `i`.`draw_bank`  =  \'\' ),  `s`.`sub_head` ,  `i`.`draw_bank`  )  AS  `name`  from (  `co-operativebank-mitrachak`.`income`  `i`  join  `co-operativebank-mitrachak`.`sub_head`  `s`  ) where ( (  `s`.`code`  =  `i`.`sub_head`  ) and (  `i`.`code`  like  \'INC%\' ) ) union  all  select  `i`.`code`  AS  `acc_no` ,\nif( (  `i`.`draw_bank`  =  \'\' ),  `s`.`sub_head` ,  `i`.`draw_bank`  )  AS  `name`  from (  `co-operativebank-mitrachak`.`libities`  `i`  join  `co-operativebank-mitrachak`.`sub_head`  `s`  ) where ( (  `s`.`code`  =  `i`.`sub_head`  ) and (  `i`.`code`  like  \'LIB%\' ) )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank-mitrachak`.`deposit_acc` `d` join `co-operativebank-mitrachak`.`applicant` `a`) where (`d`.`fd_sv_acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `l`.`code` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank-mitrachak`.`income` `l` join `co-operativebank-mitrachak`.`applicant` `a`) where ((`a`.`Acc_No` = `l`.`code`) and (`l`.`shlip_no` like \'SV-D%\')) group by `l`.`code` union all select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank-mitrachak`.`loan_acc` `d` join `co-operativebank-mitrachak`.`applicant` `a`) where (`d`.`loan_against_sv_acc` = `a`.`Acc_No`) group by `d`.`acc_no` union all select `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank-mitrachak`.`mstr_bnk_acc` `d` join `co-operativebank-mitrachak`.`applicant` `a`) where (`d`.`acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `d`.`code` AS `code`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`co-operativebank-mitrachak`.`shares` `d` join `co-operativebank-mitrachak`.`applicant` `a`) where (`d`.`acc_no` = `a`.`Acc_No`) group by `a`.`Acc_No` union all select `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`co-operativebank-mitrachak`.`income` `i` join `co-operativebank-mitrachak`.`sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'INC%\')) union all select `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`co-operativebank-mitrachak`.`libities` `i` join `co-operativebank-mitrachak`.`sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'LIB%\'))
