TYPE=VIEW
query=select `v`.`sub_head` AS `sub_head`,if((length(`v`.`sub_head`) >= 6),concat((`v`.`sub_head` + 29000),right(`v`.`sub_head`,1)),(`v`.`sub_head` + 29000)) AS `int_head` from `co-operativebank-neturia`.`voucher` `v` join `co-operativebank-neturia`.`sub_head` `s` where ((`s`.`code` = `v`.`sub_head`) and (`s`.`Type` = \'cc\') and ((`v`.`head` = \'23100\') or (`v`.`head` = \'23200\') or (`v`.`head` = \'23300\') or (`v`.`head` = \'23400\') or (`v`.`head` = \'23500\') or (`v`.`head` = \'23600\') or (`v`.`head` = \'23700\') or (`v`.`head` = \'23800\') or (`v`.`head` = \'23900\')) and ((`v`.`cr` <> 0) or (`v`.`dr` <> 0))) group by `v`.`sub_head`
md5=f280c8a8541a3da2ee2f2b432e97730a
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2022-09-02 11:23:29
create-version=1
source=select v.sub_head, if(LENGTH(v.sub_head)>=6,concat((v.sub_head+29000), RIGHT( v.sub_head, 1 )),(v.sub_head+29000)) as int_head from voucher v,sub_head s where s.code=v.sub_head and s.type=\'cc\' and (v.head=\'23100\' or v.head=\'23200\' or v.head=\'23300\' or v.head=\'23400\' or v.head=\'23500\' or v.head=\'23600\' or v.head=\'23700\' or v.head=\'23800\' or v.head=\'23900\') and (cr<>0 or dr<>0) group by v.sub_head
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `v`.`sub_head` AS `sub_head`,if((length(`v`.`sub_head`) >= 6),concat((`v`.`sub_head` + 29000),right(`v`.`sub_head`,1)),(`v`.`sub_head` + 29000)) AS `int_head` from `co-operativebank-neturia`.`voucher` `v` join `co-operativebank-neturia`.`sub_head` `s` where ((`s`.`code` = `v`.`sub_head`) and (`s`.`Type` = \'cc\') and ((`v`.`head` = \'23100\') or (`v`.`head` = \'23200\') or (`v`.`head` = \'23300\') or (`v`.`head` = \'23400\') or (`v`.`head` = \'23500\') or (`v`.`head` = \'23600\') or (`v`.`head` = \'23700\') or (`v`.`head` = \'23800\') or (`v`.`head` = \'23900\')) and ((`v`.`cr` <> 0) or (`v`.`dr` <> 0))) group by `v`.`sub_head`
