TYPE=VIEW
query=select `v`.`sub_head` AS `code` from `co-operativebank`.`voucher` `v` where ((`v`.`sub_head` > \'20000\') and (`v`.`sub_head` < \'30000\') and (`v`.`date` < \'2010-07-02\')) group by `v`.`sub_head`
md5=679ed5085d7f814ecf8f8109e25dffcf
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2016-07-02 09:30:41
create-version=1
source=select sub_head code from voucher v where (v.sub_head>\'20000\' and v.sub_head<\'30000\') and date<\'2010-07-02\'  group by sub_head
client_cs_name=latin1
connection_cl_name=latin1_swedish_ci
view_body_utf8=select `v`.`sub_head` AS `code` from `co-operativebank`.`voucher` `v` where ((`v`.`sub_head` > \'20000\') and (`v`.`sub_head` < \'30000\') and (`v`.`date` < \'2010-07-02\')) group by `v`.`sub_head`
