TYPE=VIEW
query=(select `synop_details`.`no` AS `no`,`synop_details`.`slno` AS `slno`,`synop_details`.`sl_no` AS `sl_no`,concat(`synop_details`.`sub_head`,\' | \',`synop_details`.`account`) AS `account`,`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`synop_details`.`DetailList` AS `DetailList`,if((sum(`synop_details`.`BalanceSheetFigure`) > sum(`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`synop_details`.`BalanceSheetFigure`) - sum(`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`synop_details`.`DetailList`) - sum(`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`synop_details`.`OverduePrin` AS `OverduePrin`,`synop_details`.`Interest` AS `Interest`,`synop_details`.`OverdueInt` AS `OverdueInt`,`synop_details`.`sub_head` AS `sub_head`,`synop_details`.`pay_re` AS `pay_rec`,`synop_details`.`tolmem` AS `tolmem` from `co-operativebank-242`.`synop_details` where (`synop_details`.`slno` = 4) group by `synop_details`.`sub_head`) union (select `synop_details`.`no` AS `no`,`synop_details`.`slno` AS `slno`,`synop_details`.`sl_no` AS `sl_no`,concat(`synop_details`.`sub_head`,\' | \',`synop_details`.`account`) AS `account`,`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`synop_details`.`DetailList` AS `DetailList`,if((sum(`synop_details`.`BalanceSheetFigure`) > sum(`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`synop_details`.`BalanceSheetFigure`) - sum(`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`synop_details`.`DetailList`) - sum(`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`synop_details`.`OverduePrin` AS `OverduePrin`,`synop_details`.`Interest` AS `Interest`,`synop_details`.`OverdueInt` AS `OverdueInt`,`synop_details`.`sub_head` AS `sub_head`,`synop_details`.`pay_re` AS `pay_rec`,`synop_details`.`tolmem` AS `tolmem` from `co-operativebank-242`.`synop_details` where ((`synop_details`.`sl_no` = 4) and (`synop_details`.`slno` <> 4) and (`synop_details`.`sub_head` like \'28%\')) group by `synop_details`.`sub_head` order by `sl_no`,`sub_head`) union (select `synop_details`.`no` AS `no`,`synop_details`.`slno` AS `slno`,`synop_details`.`sl_no` AS `sl_no`,concat(`synop_details`.`sub_head`,\' | \',`synop_details`.`account`) AS `account`,`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`synop_details`.`DetailList` AS `DetailList`,if((sum(`synop_details`.`BalanceSheetFigure`) > sum(`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`synop_details`.`BalanceSheetFigure`) - sum(`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`synop_details`.`DetailList`) - sum(`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`synop_details`.`OverduePrin` AS `OverduePrin`,`synop_details`.`Interest` AS `Interest`,`synop_details`.`OverdueInt` AS `OverdueInt`,`synop_details`.`sub_head` AS `sub_head`,`synop_details`.`pay_re` AS `pay_rec`,`synop_details`.`tolmem` AS `tolmem` from `co-operativebank-242`.`synop_details` where ((`synop_details`.`sl_no` = 4) and (`synop_details`.`slno` <> 4) and (not((`synop_details`.`sub_head` like \'28%\')))) group by `synop_details`.`sub_head` order by `synop_details`.`sl_no`,`sub_head`)
md5=81770248159f874925a7add2b56fc2fb
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-09-19 15:21:46
create-version=1
source=(select `synop_details`.`no` AS `no`,`synop_details`.`slno` AS `slno`,`synop_details`.`sl_no` AS `sl_no`,concat(`synop_details`.`sub_head`,\' | \',`synop_details`.`account`) AS `account`,`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`synop_details`.`DetailList` AS `DetailList`,if((sum(`synop_details`.`BalanceSheetFigure`) > sum(`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`synop_details`.`BalanceSheetFigure`) - sum(`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`synop_details`.`DetailList`) - sum(`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`synop_details`.`OverduePrin` AS `OverduePrin`,`synop_details`.`Interest` AS `Interest`,`synop_details`.`OverdueInt` AS `OverdueInt`,`synop_details`.`sub_head` AS `sub_head`,`synop_details`.`pay_re` AS `pay_rec`,`synop_details`.`tolmem` AS `tolmem` from `synop_details` where (`synop_details`.`slno` = 4) group by `synop_details`.`sub_head`) union (select `synop_details`.`no` AS `no`,`synop_details`.`slno` AS `slno`,`synop_details`.`sl_no` AS `sl_no`,concat(`synop_details`.`sub_head`,\' | \',`synop_details`.`account`) AS `account`,`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`synop_details`.`DetailList` AS `DetailList`,if((sum(`synop_details`.`BalanceSheetFigure`) > sum(`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`synop_details`.`BalanceSheetFigure`) - sum(`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`synop_details`.`DetailList`) - sum(`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`synop_details`.`OverduePrin` AS `OverduePrin`,`synop_details`.`Interest` AS `Interest`,`synop_details`.`OverdueInt` AS `OverdueInt`,`synop_details`.`sub_head` AS `sub_head`,`synop_details`.`pay_re` AS `pay_rec`,`synop_details`.`tolmem` AS `tolmem` from `synop_details` where ((`synop_details`.`sl_no` = 4) and (`synop_details`.`slno` <> 4) and (`synop_details`.`sub_head` like \'28%\')) group by `synop_details`.`sub_head` order by `sl_no`,`sub_head`) union (select `synop_details`.`no` AS `no`,`synop_details`.`slno` AS `slno`,`synop_details`.`sl_no` AS `sl_no`,concat(`synop_details`.`sub_head`,\' | \',`synop_details`.`account`) AS `account`,`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`synop_details`.`DetailList` AS `DetailList`,if((sum(`synop_details`.`BalanceSheetFigure`) > sum(`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`synop_details`.`BalanceSheetFigure`) - sum(`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`synop_details`.`DetailList`) - sum(`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`synop_details`.`OverduePrin` AS `OverduePrin`,`synop_details`.`Interest` AS `Interest`,`synop_details`.`OverdueInt` AS `OverdueInt`,`synop_details`.`sub_head` AS `sub_head`,`synop_details`.`pay_re` AS `pay_rec`,`synop_details`.`tolmem` AS `tolmem` from `synop_details` where ((`synop_details`.`sl_no` = 4) and (`synop_details`.`slno` <> 4) and (not((`synop_details`.`sub_head` like \'28%\')))) group by `synop_details`.`sub_head` order by `synop_details`.`sl_no`,`sub_head`)
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=(select `synop_details`.`no` AS `no`,`synop_details`.`slno` AS `slno`,`synop_details`.`sl_no` AS `sl_no`,concat(`synop_details`.`sub_head`,\' | \',`synop_details`.`account`) AS `account`,`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`synop_details`.`DetailList` AS `DetailList`,if((sum(`synop_details`.`BalanceSheetFigure`) > sum(`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`synop_details`.`BalanceSheetFigure`) - sum(`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`synop_details`.`DetailList`) - sum(`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`synop_details`.`OverduePrin` AS `OverduePrin`,`synop_details`.`Interest` AS `Interest`,`synop_details`.`OverdueInt` AS `OverdueInt`,`synop_details`.`sub_head` AS `sub_head`,`synop_details`.`pay_re` AS `pay_rec`,`synop_details`.`tolmem` AS `tolmem` from `co-operativebank-242`.`synop_details` where (`synop_details`.`slno` = 4) group by `synop_details`.`sub_head`) union (select `synop_details`.`no` AS `no`,`synop_details`.`slno` AS `slno`,`synop_details`.`sl_no` AS `sl_no`,concat(`synop_details`.`sub_head`,\' | \',`synop_details`.`account`) AS `account`,`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`synop_details`.`DetailList` AS `DetailList`,if((sum(`synop_details`.`BalanceSheetFigure`) > sum(`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`synop_details`.`BalanceSheetFigure`) - sum(`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`synop_details`.`DetailList`) - sum(`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`synop_details`.`OverduePrin` AS `OverduePrin`,`synop_details`.`Interest` AS `Interest`,`synop_details`.`OverdueInt` AS `OverdueInt`,`synop_details`.`sub_head` AS `sub_head`,`synop_details`.`pay_re` AS `pay_rec`,`synop_details`.`tolmem` AS `tolmem` from `co-operativebank-242`.`synop_details` where ((`synop_details`.`sl_no` = 4) and (`synop_details`.`slno` <> 4) and (`synop_details`.`sub_head` like \'28%\')) group by `synop_details`.`sub_head` order by `sl_no`,`sub_head`) union (select `synop_details`.`no` AS `no`,`synop_details`.`slno` AS `slno`,`synop_details`.`sl_no` AS `sl_no`,concat(`synop_details`.`sub_head`,\' | \',`synop_details`.`account`) AS `account`,`synop_details`.`BalanceSheetFigure` AS `BalanceSheetFigure`,`synop_details`.`DetailList` AS `DetailList`,if((sum(`synop_details`.`BalanceSheetFigure`) > sum(`synop_details`.`DetailList`)),concat(\'[-] \',(sum(`synop_details`.`BalanceSheetFigure`) - sum(`synop_details`.`DetailList`))),concat(\'[+] \',(sum(`synop_details`.`DetailList`) - sum(`synop_details`.`BalanceSheetFigure`)))) AS `Descrepancy`,`synop_details`.`OverduePrin` AS `OverduePrin`,`synop_details`.`Interest` AS `Interest`,`synop_details`.`OverdueInt` AS `OverdueInt`,`synop_details`.`sub_head` AS `sub_head`,`synop_details`.`pay_re` AS `pay_rec`,`synop_details`.`tolmem` AS `tolmem` from `co-operativebank-242`.`synop_details` where ((`synop_details`.`sl_no` = 4) and (`synop_details`.`slno` <> 4) and (not((`synop_details`.`sub_head` like \'28%\')))) group by `synop_details`.`sub_head` order by `synop_details`.`sl_no`,`sub_head`)
