TYPE=VIEW
query=select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,1 AS `slno`,1 AS `sl_no`,\'Paid Up Share-Capital\' AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00001\' AS `sub_head`,0 AS `pay_re` from `co-operativebank-mitrachak`.`synopsis` where (`co-operativebank-mitrachak`.`synopsis`.`sl_no` = \'1\') group by `co-operativebank-mitrachak`.`synopsis`.`sl_no` union all select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,2 AS `slno`,2 AS `sl_no`,\'Deposit\' AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00002\' AS `sub_head`,0 AS `pay_re` from `co-operativebank-mitrachak`.`synopsis` where (`co-operativebank-mitrachak`.`synopsis`.`sl_no` = \'2\') group by `co-operativebank-mitrachak`.`synopsis`.`sl_no` union all select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,3 AS `slno`,3 AS `sl_no`,\'Borrowings From C.C.B Ltd.\' AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,\'\' AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00003\' AS `sub_head`,0 AS `pay_rec` from `co-operativebank-mitrachak`.`synopsis` where (`co-operativebank-mitrachak`.`synopsis`.`sl_no` = \'3\') group by `co-operativebank-mitrachak`.`synopsis`.`sl_no` union all select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,4 AS `slno`,4 AS `sl_no`,\'Bank Deposits & Investments\' AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00004\' AS `sub_head`,0 AS `pay_rec` from `co-operativebank-mitrachak`.`synopsis` where (`co-operativebank-mitrachak`.`synopsis`.`sl_no` = \'4\') group by `co-operativebank-mitrachak`.`synopsis`.`sl_no` union all select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,5 AS `slno`,5 AS `sl_no`,\'Share Investment\' AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00005\' AS `sub_head`,0 AS `pay_rec` from `co-operativebank-mitrachak`.`synopsis` where (`co-operativebank-mitrachak`.`synopsis`.`sl_no` = \'5\') group by `co-operativebank-mitrachak`.`synopsis`.`sl_no` union all select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,6 AS `slno`,6 AS `sl_no`,\'Loan and Advances To Members\' AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00006\' AS `sub_head`,0 AS `pay_re` from `co-operativebank-mitrachak`.`synopsis` where (`co-operativebank-mitrachak`.`synopsis`.`sl_no` = \'6\') group by `co-operativebank-mitrachak`.`synopsis`.`sl_no` union all select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,\'\' AS `slno`,`co-operativebank-mitrachak`.`synopsis`.`sl_no` AS `sl_no`,concat(\' \',`co-operativebank-mitrachak`.`synopsis`.`account`) AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,round((sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) - sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`)),2) AS `Descrepancy`,sum(`co-operativebank-mitrachak`.`synopsis`.`OverduePrin`) AS `OverduePrin`,sum(`co-operativebank-mitrachak`.`synopsis`.`Interest`) AS `Interest`,sum(`co-operativebank-mitrachak`.`synopsis`.`OverdueInt`) AS `OverdueInt`,`co-operativebank-mitrachak`.`synopsis`.`sub_head` AS `sub_head`,sum(`co-operativebank-mitrachak`.`synopsis`.`pay_rec`) AS `pay_rec` from `co-operativebank-mitrachak`.`synopsis` group by `co-operativebank-mitrachak`.`synopsis`.`sub_head`
md5=9bc4c16064e680da136bf34fea6044d6
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2025-06-03 06:53:05
create-version=1
source=select `synopsis`.`no` AS `no`,1 AS `slno`,1 AS `sl_no`,\'Paid Up Share-Capital\' AS `account`,sum(`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00001\' AS `sub_head`,0 AS `pay_re` from `synopsis` where (`synopsis`.`sl_no` = \'1\') group by `synopsis`.`sl_no` union all select `synopsis`.`no` AS `no`,2 AS `slno`,2 AS `sl_no`,\'Deposit\' AS `account`,sum(`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00002\' AS `sub_head`,0 AS `pay_re` from `synopsis` where (`synopsis`.`sl_no` = \'2\') group by `synopsis`.`sl_no` union all select `synopsis`.`no` AS `no`,3 AS `slno`,3 AS `sl_no`,\'Borrowings From C.C.B Ltd.\' AS `account`,sum(`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`synopsis`.`DetailList`) AS `DetailList`,\'\' AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00003\' AS `sub_head`,0 AS `pay_rec` from `synopsis` where (`synopsis`.`sl_no` = \'3\') group by `synopsis`.`sl_no` union all select `synopsis`.`no` AS `no`,4 AS `slno`,4 AS `sl_no`,\'Bank Deposits & Investments\' AS `account`,sum(`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00004\' AS `sub_head`,0 AS `pay_rec` from `synopsis` where (`synopsis`.`sl_no` = \'4\') group by `synopsis`.`sl_no` union all select `synopsis`.`no` AS `no`,5 AS `slno`,5 AS `sl_no`,\'Share Investment\' AS `account`,sum(`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00005\' AS `sub_head`,0 AS `pay_rec` from `synopsis` where (`synopsis`.`sl_no` = \'5\') group by `synopsis`.`sl_no` union all select `synopsis`.`no` AS `no`,6 AS `slno`,6 AS `sl_no`,\'Loan and Advances To Members\' AS `account`,sum(`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00006\' AS `sub_head`,0 AS `pay_re` from `synopsis` where (`synopsis`.`sl_no` = \'6\') group by `synopsis`.`sl_no` union all select `synopsis`.`no` AS `no`,\'\' AS `slno`,`synopsis`.`sl_no` AS `sl_no`,concat(\' \',`synopsis`.`account`) AS `account`,sum(`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`synopsis`.`DetailList`) AS `DetailList`,round((sum(`synopsis`.`BalanceSheetFigure`) - sum(`synopsis`.`DetailList`)),2) AS `Descrepancy`,sum(`synopsis`.`OverduePrin`) AS `OverduePrin`,sum(`synopsis`.`Interest`) AS `Interest`,sum(`synopsis`.`OverdueInt`) AS `OverdueInt`,`synopsis`.`sub_head` AS `sub_head`,sum(`synopsis`.`pay_rec`) AS `pay_rec` from `synopsis` group by `synopsis`.`sub_head`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,1 AS `slno`,1 AS `sl_no`,\'Paid Up Share-Capital\' AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00001\' AS `sub_head`,0 AS `pay_re` from `co-operativebank-mitrachak`.`synopsis` where (`co-operativebank-mitrachak`.`synopsis`.`sl_no` = \'1\') group by `co-operativebank-mitrachak`.`synopsis`.`sl_no` union all select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,2 AS `slno`,2 AS `sl_no`,\'Deposit\' AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00002\' AS `sub_head`,0 AS `pay_re` from `co-operativebank-mitrachak`.`synopsis` where (`co-operativebank-mitrachak`.`synopsis`.`sl_no` = \'2\') group by `co-operativebank-mitrachak`.`synopsis`.`sl_no` union all select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,3 AS `slno`,3 AS `sl_no`,\'Borrowings From C.C.B Ltd.\' AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,\'\' AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00003\' AS `sub_head`,0 AS `pay_rec` from `co-operativebank-mitrachak`.`synopsis` where (`co-operativebank-mitrachak`.`synopsis`.`sl_no` = \'3\') group by `co-operativebank-mitrachak`.`synopsis`.`sl_no` union all select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,4 AS `slno`,4 AS `sl_no`,\'Bank Deposits & Investments\' AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00004\' AS `sub_head`,0 AS `pay_rec` from `co-operativebank-mitrachak`.`synopsis` where (`co-operativebank-mitrachak`.`synopsis`.`sl_no` = \'4\') group by `co-operativebank-mitrachak`.`synopsis`.`sl_no` union all select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,5 AS `slno`,5 AS `sl_no`,\'Share Investment\' AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00005\' AS `sub_head`,0 AS `pay_rec` from `co-operativebank-mitrachak`.`synopsis` where (`co-operativebank-mitrachak`.`synopsis`.`sl_no` = \'5\') group by `co-operativebank-mitrachak`.`synopsis`.`sl_no` union all select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,6 AS `slno`,6 AS `sl_no`,\'Loan and Advances To Members\' AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,0 AS `Descrepancy`,0 AS `OverduePrin`,0 AS `Interest`,0 AS `OverdueInt`,\'00006\' AS `sub_head`,0 AS `pay_re` from `co-operativebank-mitrachak`.`synopsis` where (`co-operativebank-mitrachak`.`synopsis`.`sl_no` = \'6\') group by `co-operativebank-mitrachak`.`synopsis`.`sl_no` union all select `co-operativebank-mitrachak`.`synopsis`.`no` AS `no`,\'\' AS `slno`,`co-operativebank-mitrachak`.`synopsis`.`sl_no` AS `sl_no`,concat(\' \',`co-operativebank-mitrachak`.`synopsis`.`account`) AS `account`,sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) AS `BalanceSheetFigure`,sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`) AS `DetailList`,round((sum(`co-operativebank-mitrachak`.`synopsis`.`BalanceSheetFigure`) - sum(`co-operativebank-mitrachak`.`synopsis`.`DetailList`)),2) AS `Descrepancy`,sum(`co-operativebank-mitrachak`.`synopsis`.`OverduePrin`) AS `OverduePrin`,sum(`co-operativebank-mitrachak`.`synopsis`.`Interest`) AS `Interest`,sum(`co-operativebank-mitrachak`.`synopsis`.`OverdueInt`) AS `OverdueInt`,`co-operativebank-mitrachak`.`synopsis`.`sub_head` AS `sub_head`,sum(`co-operativebank-mitrachak`.`synopsis`.`pay_rec`) AS `pay_rec` from `co-operativebank-mitrachak`.`synopsis` group by `co-operativebank-mitrachak`.`synopsis`.`sub_head`
