TYPE=VIEW
query=select `co-operativebank-bajbajia`.`voucher`.`sub_head` AS `sub_head`,`co-operativebank-bajbajia`.`head`.`code` AS `code`,`co-operativebank-bajbajia`.`head_type`.`code` AS `head_type`,(sum(`co-operativebank-bajbajia`.`voucher`.`dr`) - sum(`co-operativebank-bajbajia`.`voucher`.`cr`)) AS `bal` from (((`co-operativebank-bajbajia`.`voucher` join `co-operativebank-bajbajia`.`sub_head`) join `co-operativebank-bajbajia`.`head`) join `co-operativebank-bajbajia`.`head_type`) where ((`co-operativebank-bajbajia`.`voucher`.`sub_head` = `co-operativebank-bajbajia`.`sub_head`.`code`) and (`co-operativebank-bajbajia`.`sub_head`.`head` = `co-operativebank-bajbajia`.`head`.`code`) and (`co-operativebank-bajbajia`.`head`.`head_type` = `co-operativebank-bajbajia`.`head_type`.`code`) and (((`co-operativebank-bajbajia`.`voucher`.`sub_head` > \'60000\') and (`co-operativebank-bajbajia`.`voucher`.`sub_head` < \'70000\')) or (`co-operativebank-bajbajia`.`head_type`.`code` = \'23000\') or (`co-operativebank-bajbajia`.`head_type`.`code` = \'21000\')) and (`co-operativebank-bajbajia`.`voucher`.`date` < \'2015-03-31\')) group by `co-operativebank-bajbajia`.`voucher`.`sub_head` union all select `co-operativebank-bajbajia`.`voucher`.`sub_head` AS `sub_head`,`co-operativebank-bajbajia`.`head`.`code` AS `code`,`co-operativebank-bajbajia`.`head_type`.`code` AS `head_type`,(sum(`co-operativebank-bajbajia`.`voucher`.`cr`) - sum(`co-operativebank-bajbajia`.`voucher`.`dr`)) AS `(sum(cr)-sum(dr))` from (((`co-operativebank-bajbajia`.`voucher` join `co-operativebank-bajbajia`.`sub_head`) join `co-operativebank-bajbajia`.`head`) join `co-operativebank-bajbajia`.`head_type`) where ((`co-operativebank-bajbajia`.`voucher`.`sub_head` = `co-operativebank-bajbajia`.`sub_head`.`code`) and (`co-operativebank-bajbajia`.`sub_head`.`head` = `co-operativebank-bajbajia`.`head`.`code`) and (`co-operativebank-bajbajia`.`head`.`head_type` = `co-operativebank-bajbajia`.`head_type`.`code`) and (`co-operativebank-bajbajia`.`voucher`.`date` < \'2015-03-31\') and ((`co-operativebank-bajbajia`.`head_type`.`code` = \'22000\') or (`co-operativebank-bajbajia`.`head_type`.`code` = \'28000\'))) group by `co-operativebank-bajbajia`.`voucher`.`sub_head`
md5=cf06bda87bf44c7d769fdf0bc45c423e
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-01-10 05:52:03
create-version=1
source=select `voucher`.`sub_head` AS `sub_head`,`head`.`code` AS `code`,`head_type`.`code` AS `head_type`,(sum(`voucher`.`dr`) - sum(`voucher`.`cr`)) AS `bal` from (((`voucher` join `sub_head`) join `head`) join `head_type`) where ((`voucher`.`sub_head` = `sub_head`.`code`) and (`sub_head`.`head` = `head`.`code`) and (`head`.`head_type` = `head_type`.`code`) and (((`voucher`.`sub_head` > \'60000\') and (`voucher`.`sub_head` < \'70000\')) or (`head_type`.`code` = \'23000\') or (`head_type`.`code` = \'21000\')) and (`voucher`.`date` < \'2015-03-31\')) group by `voucher`.`sub_head` union all select `voucher`.`sub_head` AS `sub_head`,`head`.`code` AS `code`,`head_type`.`code` AS `head_type`,(sum(`voucher`.`cr`) - sum(`voucher`.`dr`)) AS `(sum(cr)-sum(dr))` from (((`voucher` join `sub_head`) join `head`) join `head_type`) where ((`voucher`.`sub_head` = `sub_head`.`code`) and (`sub_head`.`head` = `head`.`code`) and (`head`.`head_type` = `head_type`.`code`) and (`voucher`.`date` < \'2015-03-31\') and ((`head_type`.`code` = \'22000\') or (`head_type`.`code` = \'28000\'))) group by `voucher`.`sub_head`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-bajbajia`.`voucher`.`sub_head` AS `sub_head`,`co-operativebank-bajbajia`.`head`.`code` AS `code`,`co-operativebank-bajbajia`.`head_type`.`code` AS `head_type`,(sum(`co-operativebank-bajbajia`.`voucher`.`dr`) - sum(`co-operativebank-bajbajia`.`voucher`.`cr`)) AS `bal` from (((`co-operativebank-bajbajia`.`voucher` join `co-operativebank-bajbajia`.`sub_head`) join `co-operativebank-bajbajia`.`head`) join `co-operativebank-bajbajia`.`head_type`) where ((`co-operativebank-bajbajia`.`voucher`.`sub_head` = `co-operativebank-bajbajia`.`sub_head`.`code`) and (`co-operativebank-bajbajia`.`sub_head`.`head` = `co-operativebank-bajbajia`.`head`.`code`) and (`co-operativebank-bajbajia`.`head`.`head_type` = `co-operativebank-bajbajia`.`head_type`.`code`) and (((`co-operativebank-bajbajia`.`voucher`.`sub_head` > \'60000\') and (`co-operativebank-bajbajia`.`voucher`.`sub_head` < \'70000\')) or (`co-operativebank-bajbajia`.`head_type`.`code` = \'23000\') or (`co-operativebank-bajbajia`.`head_type`.`code` = \'21000\')) and (`co-operativebank-bajbajia`.`voucher`.`date` < \'2015-03-31\')) group by `co-operativebank-bajbajia`.`voucher`.`sub_head` union all select `co-operativebank-bajbajia`.`voucher`.`sub_head` AS `sub_head`,`co-operativebank-bajbajia`.`head`.`code` AS `code`,`co-operativebank-bajbajia`.`head_type`.`code` AS `head_type`,(sum(`co-operativebank-bajbajia`.`voucher`.`cr`) - sum(`co-operativebank-bajbajia`.`voucher`.`dr`)) AS `(sum(cr)-sum(dr))` from (((`co-operativebank-bajbajia`.`voucher` join `co-operativebank-bajbajia`.`sub_head`) join `co-operativebank-bajbajia`.`head`) join `co-operativebank-bajbajia`.`head_type`) where ((`co-operativebank-bajbajia`.`voucher`.`sub_head` = `co-operativebank-bajbajia`.`sub_head`.`code`) and (`co-operativebank-bajbajia`.`sub_head`.`head` = `co-operativebank-bajbajia`.`head`.`code`) and (`co-operativebank-bajbajia`.`head`.`head_type` = `co-operativebank-bajbajia`.`head_type`.`code`) and (`co-operativebank-bajbajia`.`voucher`.`date` < \'2015-03-31\') and ((`co-operativebank-bajbajia`.`head_type`.`code` = \'22000\') or (`co-operativebank-bajbajia`.`head_type`.`code` = \'28000\'))) group by `co-operativebank-bajbajia`.`voucher`.`sub_head`
