TYPE=VIEW
query=select `co-operativebank`.`voucher`.`sub_head` AS `sub_head`,(sum(`co-operativebank`.`voucher`.`cr`) - sum(`co-operativebank`.`voucher`.`dr`)) AS `bal` from `co-operativebank`.`voucher` where ((((`co-operativebank`.`voucher`.`sub_head` > \'10000\') and (`co-operativebank`.`voucher`.`sub_head` < \'20000\')) or ((`co-operativebank`.`voucher`.`sub_head` > \'50000\') and (`co-operativebank`.`voucher`.`sub_head` < \'60000\'))) and (`co-operativebank`.`voucher`.`date` < \'2016-04-01\')) group by `co-operativebank`.`voucher`.`sub_head`
md5=c8661a1bdd0ba03135bebdad47fce681
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2017-06-09 05:12:52
create-version=1
source=select `voucher`.`sub_head` AS `sub_head`,(sum(`voucher`.`cr`) - sum(`voucher`.`dr`)) AS `bal` from `voucher` where ((sub_head>\'10000\' and sub_head<\'20000\') or (sub_head>\'50000\' and sub_head<\'60000\')) and date<\'2016-04-01\' group by `voucher`.`sub_head`
client_cs_name=latin1
connection_cl_name=latin1_swedish_ci
view_body_utf8=select `co-operativebank`.`voucher`.`sub_head` AS `sub_head`,(sum(`co-operativebank`.`voucher`.`cr`) - sum(`co-operativebank`.`voucher`.`dr`)) AS `bal` from `co-operativebank`.`voucher` where ((((`co-operativebank`.`voucher`.`sub_head` > \'10000\') and (`co-operativebank`.`voucher`.`sub_head` < \'20000\')) or ((`co-operativebank`.`voucher`.`sub_head` > \'50000\') and (`co-operativebank`.`voucher`.`sub_head` < \'60000\'))) and (`co-operativebank`.`voucher`.`date` < \'2016-04-01\')) group by `co-operativebank`.`voucher`.`sub_head`
