TYPE=VIEW
query=select `co-operativebank-bajbajia`.`approciation`.`id` AS `id`,`co-operativebank-bajbajia`.`approciation`.`sub_head` AS `sub_head`,`co-operativebank-bajbajia`.`approciation`.`head` AS `head`,`co-operativebank-bajbajia`.`approciation`.`main_head` AS `main_head`,sum(`co-operativebank-bajbajia`.`approciation`.`amt`) AS `amt`,`co-operativebank-bajbajia`.`approciation`.`date` AS `date`,`co-operativebank-bajbajia`.`approciation`.`deperment` AS `deperment` from `co-operativebank-bajbajia`.`approciation` where (`co-operativebank-bajbajia`.`approciation`.`date` <= \'2026-04-16\') group by `co-operativebank-bajbajia`.`approciation`.`sub_head`
md5=d2991b462b331b08a5554a2ce2b2e552
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-04-20 06:18:02
create-version=1
source=SELECT `id`, `sub_head`, `head`, `main_head`,sum( `amt`) as amt, `date`, `deperment` FROM `approciation` WHERE date<=\'2026-04-16\' group by sub_head
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `co-operativebank-bajbajia`.`approciation`.`id` AS `id`,`co-operativebank-bajbajia`.`approciation`.`sub_head` AS `sub_head`,`co-operativebank-bajbajia`.`approciation`.`head` AS `head`,`co-operativebank-bajbajia`.`approciation`.`main_head` AS `main_head`,sum(`co-operativebank-bajbajia`.`approciation`.`amt`) AS `amt`,`co-operativebank-bajbajia`.`approciation`.`date` AS `date`,`co-operativebank-bajbajia`.`approciation`.`deperment` AS `deperment` from `co-operativebank-bajbajia`.`approciation` where (`co-operativebank-bajbajia`.`approciation`.`date` <= \'2026-04-16\') group by `co-operativebank-bajbajia`.`approciation`.`sub_head`
