TYPE=VIEW
query=select (sum(`v`.`cr`) - sum(`v`.`dr`)) AS `opbal` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`head` `h` where ((`v`.`head` = `h`.`code`) and (`v`.`deposit_type` = \'CASH\') and ((`h`.`head_type` = \'14000\') or (`h`.`head_type` = \'23000\')) and (`v`.`date` < \'2015-03-30\')) group by `v`.`head` union all select (sum(`v`.`cr`) - sum(`v`.`dr`)) AS `opbal` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`head` `h` where ((`v`.`head` = `h`.`code`) and (`v`.`deposit_type` = \'CASH\') and (`h`.`head_type` <> \'28000\') and (`h`.`head_type` <> \'62000\') and (`h`.`head_type` <> \'20000\') and (`h`.`head_type` <> \'\') and ((`h`.`head_type` < \'50000\') or (`h`.`head_type` > \'60000\')) and (`v`.`date` < \'2015-03-30\')) group by `v`.`head` union all select (sum(`v`.`dr`) - sum(`v`.`cr`)) AS `opbal` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`head` `h` where ((`v`.`head` = `h`.`code`) and (`v`.`deposit_type` = \'CASH\') and (`h`.`head_type` > \'50000\') and (`h`.`head_type` < \'60000\') and (`v`.`date` < \'2015-03-30\')) group by `v`.`head`
md5=0b5a2e20ddc526493274e4d44aa0142a
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2016-03-30 06:48:09
create-version=1
source=select sum(cr)-sum(dr) opbal from voucher v,head h where v.head=h.code and V.deposit_type=\'CASH\' and (h.head_type=\'14000\' or h.head_type=\'23000\') and v.date<\'2015-03-30\' group by v.head  union ALL select sum(cr)-sum(dr) opbal from voucher v,head h where v.head=h.code and V.deposit_type=\'CASH\' and  (h.head_type<>\'28000\' and h.head_type<>\'62000\' and h.head_type<>\'20000\' and h.head_type<>\'\') and (h.head_type<\'50000\' or h.head_type>\'60000\') and v.date<\'2015-03-30\' group by v.head  union ALL select sum(dr)-sum(cr) opbal from voucher v,head h where v.head=h.code and V.deposit_type=\'CASH\' and (h.head_type>\'50000\' and h.head_type<\'60000\') and v.date<\'2015-03-30\' group by v.head
client_cs_name=latin1
connection_cl_name=latin1_swedish_ci
view_body_utf8=select (sum(`v`.`cr`) - sum(`v`.`dr`)) AS `opbal` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`head` `h` where ((`v`.`head` = `h`.`code`) and (`v`.`deposit_type` = \'CASH\') and ((`h`.`head_type` = \'14000\') or (`h`.`head_type` = \'23000\')) and (`v`.`date` < \'2015-03-30\')) group by `v`.`head` union all select (sum(`v`.`cr`) - sum(`v`.`dr`)) AS `opbal` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`head` `h` where ((`v`.`head` = `h`.`code`) and (`v`.`deposit_type` = \'CASH\') and (`h`.`head_type` <> \'28000\') and (`h`.`head_type` <> \'62000\') and (`h`.`head_type` <> \'20000\') and (`h`.`head_type` <> \'\') and ((`h`.`head_type` < \'50000\') or (`h`.`head_type` > \'60000\')) and (`v`.`date` < \'2015-03-30\')) group by `v`.`head` union all select (sum(`v`.`dr`) - sum(`v`.`cr`)) AS `opbal` from `co-operativebank`.`voucher` `v` join `co-operativebank`.`head` `h` where ((`v`.`head` = `h`.`code`) and (`v`.`deposit_type` = \'CASH\') and (`h`.`head_type` > \'50000\') and (`h`.`head_type` < \'60000\') and (`v`.`date` < \'2015-03-30\')) group by `v`.`head`
