TYPE=VIEW
query=select `v`.`date` AS `date`,if((`v`.`cr` > 0),concat(`sh1`.`sub_head`,\' A/C (\',`da`.`fd_sv_acc_no`,\')\'),concat(`sh2`.`sub_head`,\' A/C (\',`da`.`fd_sv_acc_no`,\')\')) AS `cr_ledger`,if((`v`.`dr` = 0),concat(`sh2`.`sub_head`,\' A/C (\',`v`.`Acc_no`,\')\'),concat(`sh1`.`sub_head`,\'A/C (\',`v`.`cash_acc`,\')\')) AS `dr_ledger`,if((`v`.`cr` > 0),`v`.`cr`,`v`.`dr`) AS `amt`,`l2`.`acc_type` AS `acc_type` from (((((`co-operativebank`.`voucher` `v` join `co-operativebank`.`ledger` `l1`) join `co-operativebank`.`ledger` `l2`) join `co-operativebank`.`sub_head` `sh1`) join `co-operativebank`.`sub_head` `sh2`) join `co-operativebank`.`deposit_acc` `da`) where ((`v`.`cash_acc` = `l1`.`acc_no`) and (`v`.`Acc_no` = `l2`.`acc_no`) and (`l1`.`sub_head` = `sh1`.`code`) and (`l2`.`sub_head` = `sh2`.`code`) and (`da`.`acc_no` = `v`.`Acc_no`))
md5=2860247422a20a30895db119608ef1ec
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2015-10-12 17:31:54
create-version=1
source=select  `v`.`date`  AS  `date` ,\nif( (  `v`.`cr`  >0 ), concat(  `sh1`.`sub_head` ,  \' A/C (\',  `da`.`fd_sv_acc_no` ,  \')\'  ) , concat(  `sh2`.`sub_head` ,  \' A/C (\',  `da`.`fd_sv_acc_no` ,  \')\'  )  )  AS  `cr_ledger` ,\nif( (  `v`.`dr`  =0 ), concat(  `sh2`.`sub_head` ,  \' A/C (\',  `v`.`Acc_no` ,  \')\'  ) , concat(  `sh1`.`sub_head` ,  \'A/C (\',  `v`.`cash_acc` ,  \')\'  )  )  AS  `dr_ledger` ,\nif( (  `v`.`cr`  >0 ),  `v`.`cr` ,  `v`.`dr`  )  AS  `amt` ,\n `l2`.`acc_type`  AS  `acc_type`  from ( ( ( ( (  `co-operativebank`.`voucher`  `v`  join  `co-operativebank`.`ledger`  `l1`  ) join  `co-operativebank`.`ledger`  `l2`  ) join  `co-operativebank`.`sub_head`  `sh1`  ) join  `co-operativebank`.`sub_head`  `sh2`  ) join  `co-operativebank`.`deposit_acc`  `da`  ) where ( (  `v`.`cash_acc`  =  `l1`.`acc_no`  ) and (  `v`.`Acc_no`  =  `l2`.`acc_no`  ) and (  `l1`.`sub_head`  =  `sh1`.`code`  ) and (  `l2`.`sub_head`  =  `sh2`.`code`  ) and (  `da`.`acc_no`  =  `v`.`Acc_no`  ) )
client_cs_name=utf8
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `v`.`date` AS `date`,if((`v`.`cr` > 0),concat(`sh1`.`sub_head`,\' A/C (\',`da`.`fd_sv_acc_no`,\')\'),concat(`sh2`.`sub_head`,\' A/C (\',`da`.`fd_sv_acc_no`,\')\')) AS `cr_ledger`,if((`v`.`dr` = 0),concat(`sh2`.`sub_head`,\' A/C (\',`v`.`Acc_no`,\')\'),concat(`sh1`.`sub_head`,\'A/C (\',`v`.`cash_acc`,\')\')) AS `dr_ledger`,if((`v`.`cr` > 0),`v`.`cr`,`v`.`dr`) AS `amt`,`l2`.`acc_type` AS `acc_type` from (((((`co-operativebank`.`voucher` `v` join `co-operativebank`.`ledger` `l1`) join `co-operativebank`.`ledger` `l2`) join `co-operativebank`.`sub_head` `sh1`) join `co-operativebank`.`sub_head` `sh2`) join `co-operativebank`.`deposit_acc` `da`) where ((`v`.`cash_acc` = `l1`.`acc_no`) and (`v`.`Acc_no` = `l2`.`acc_no`) and (`l1`.`sub_head` = `sh1`.`code`) and (`l2`.`sub_head` = `sh2`.`code`) and (`da`.`acc_no` = `v`.`Acc_no`))
