TYPE=VIEW
query=(select `co-operativebank-234`.`synop_details`.`no` AS `no`,`co-operativebank-234`.`synop_details`.`slno` AS `slno`,`co-operativebank-234`.`synop_details`.`sl_no` AS `sl_no`,concat(`co-operativebank-234`.`synop_details`.`sub_head`,\' | \',`co-operativebank-234`.`synop_details`.`account`) AS `account`,`co-operativebank-234`.`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`co-operativebank-234`.`synop_details`.`DetailList` AS `DetailList`,if((sum(`co-operativebank-234`.`synop_details`.`BalanceSheetFigure`) > sum(`co-operativebank-234`.`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`co-operativebank-234`.`synop_details`.`BalanceSheetFigure`) - sum(`co-operativebank-234`.`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`co-operativebank-234`.`synop_details`.`DetailList`) - sum(`co-operativebank-234`.`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`co-operativebank-234`.`synop_details`.`OverduePrin` AS `OverduePrin`,`co-operativebank-234`.`synop_details`.`Interest` AS `Interest`,`co-operativebank-234`.`synop_details`.`OverdueInt` AS `OverdueInt`,`co-operativebank-234`.`synop_details`.`sub_head` AS `sub_head`,`co-operativebank-234`.`synop_details`.`pay_re` AS `pay_rec` from `co-operativebank-234`.`synop_details` where ((`co-operativebank-234`.`synop_details`.`sl_no` = 1) or (`co-operativebank-234`.`synop_details`.`sl_no` = 2) or (`co-operativebank-234`.`synop_details`.`sl_no` = 3)) group by `co-operativebank-234`.`synop_details`.`sub_head` order by `co-operativebank-234`.`synop_details`.`sl_no`,`co-operativebank-234`.`synop_details`.`sub_head`)
md5=e875294bc6d8ebf41e5f65c80a08ed44
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2024-08-01 11:04:35
create-version=1
source=(  select  `synop_details`.`no`  AS  `no` ,\n `synop_details`.`slno`  AS  `slno` ,\n `synop_details`.`sl_no`  AS  `sl_no` ,\nconcat(  `synop_details`.`sub_head` ,  \' | \',  `synop_details`.`account`  )  AS  `account` ,\n `synop_details`.`BalanceSheetFigure`  AS  `BalanceSheetFigure` ,\n `synop_details`.`DetailList`  AS  `DetailList` ,\nif( ( sum(  `synop_details`.`BalanceSheetFigure`  )  > sum(  `synop_details`.`DetailList`  )  ) ,\nconcat(  \'[-] \', ( sum(  `synop_details`.`BalanceSheetFigure`  )  - sum(  `synop_details`.`DetailList`  )  )  ),\nconcat(  \'[+] \', ( sum(  `synop_details`.`DetailList`  )  - sum(  `synop_details`.`BalanceSheetFigure`  )  )  ) ) AS  `Descrepancy` ,\n `synop_details`.`OverduePrin`  AS  `OverduePrin` ,\n `synop_details`.`Interest`  AS  `Interest` ,\n `synop_details`.`OverdueInt`  AS  `OverdueInt` ,\n `synop_details`.`sub_head`  AS  `sub_head` ,\n `synop_details`.`pay_re`  AS  `pay_rec`  from  `co-operativebank-234`.`synop_details`  where ( (  `synop_details`.`sl_no`  =1 ) or (  `synop_details`.`sl_no`  =2 ) or (  `synop_details`.`sl_no`  =3 ) ) group  by  `synop_details`.`sub_head`  order  by  `synop_details`.`sl_no` ,\n `synop_details`.`sub_head`  )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=(select `co-operativebank-234`.`synop_details`.`no` AS `no`,`co-operativebank-234`.`synop_details`.`slno` AS `slno`,`co-operativebank-234`.`synop_details`.`sl_no` AS `sl_no`,concat(`co-operativebank-234`.`synop_details`.`sub_head`,\' | \',`co-operativebank-234`.`synop_details`.`account`) AS `account`,`co-operativebank-234`.`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`co-operativebank-234`.`synop_details`.`DetailList` AS `DetailList`,if((sum(`co-operativebank-234`.`synop_details`.`BalanceSheetFigure`) > sum(`co-operativebank-234`.`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`co-operativebank-234`.`synop_details`.`BalanceSheetFigure`) - sum(`co-operativebank-234`.`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`co-operativebank-234`.`synop_details`.`DetailList`) - sum(`co-operativebank-234`.`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`co-operativebank-234`.`synop_details`.`OverduePrin` AS `OverduePrin`,`co-operativebank-234`.`synop_details`.`Interest` AS `Interest`,`co-operativebank-234`.`synop_details`.`OverdueInt` AS `OverdueInt`,`co-operativebank-234`.`synop_details`.`sub_head` AS `sub_head`,`co-operativebank-234`.`synop_details`.`pay_re` AS `pay_rec` from `co-operativebank-234`.`synop_details` where ((`co-operativebank-234`.`synop_details`.`sl_no` = 1) or (`co-operativebank-234`.`synop_details`.`sl_no` = 2) or (`co-operativebank-234`.`synop_details`.`sl_no` = 3)) group by `co-operativebank-234`.`synop_details`.`sub_head` order by `co-operativebank-234`.`synop_details`.`sl_no`,`co-operativebank-234`.`synop_details`.`sub_head`)
