TYPE=VIEW
query=select `co-operativebank-243`.`approciation`.`id` AS `id`,`co-operativebank-243`.`approciation`.`sub_head` AS `sub_head`,`co-operativebank-243`.`approciation`.`head` AS `head`,`co-operativebank-243`.`approciation`.`main_head` AS `main_head`,sum(`co-operativebank-243`.`approciation`.`amt`) AS `amt`,`co-operativebank-243`.`approciation`.`date` AS `date`,`co-operativebank-243`.`approciation`.`deperment` AS `deperment` from `co-operativebank-243`.`approciation` where (`co-operativebank-243`.`approciation`.`date` <= \'2019-03-31\') group by `co-operativebank-243`.`approciation`.`sub_head`
md5=b0795336ec2a613a13761a2d99455c92
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=1
with_check_option=0
timestamp=2025-09-15 05:27:52
create-version=1
source=select  `co-operativebank-243`.`approciation`.`id`  AS  `id` ,\n `co-operativebank-243`.`approciation`.`sub_head`  AS  `sub_head` ,\n `co-operativebank-243`.`approciation`.`head`  AS  `head` ,\n `co-operativebank-243`.`approciation`.`main_head`  AS  `main_head` ,\nsum(  `co-operativebank-243`.`approciation`.`amt`  )  AS  `amt` ,\n `co-operativebank-243`.`approciation`.`date`  AS  `date` ,\n `co-operativebank-243`.`approciation`.`deperment`  AS  `deperment`  from  `co-operativebank-243`.`approciation`  where (  `co-operativebank-243`.`approciation`.`date`  <=  \'2019-03-31\' ) group  by  `co-operativebank-243`.`approciation`.`sub_head`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank-243`.`approciation`.`id` AS `id`,`co-operativebank-243`.`approciation`.`sub_head` AS `sub_head`,`co-operativebank-243`.`approciation`.`head` AS `head`,`co-operativebank-243`.`approciation`.`main_head` AS `main_head`,sum(`co-operativebank-243`.`approciation`.`amt`) AS `amt`,`co-operativebank-243`.`approciation`.`date` AS `date`,`co-operativebank-243`.`approciation`.`deperment` AS `deperment` from `co-operativebank-243`.`approciation` where (`co-operativebank-243`.`approciation`.`date` <= \'2019-03-31\') group by `co-operativebank-243`.`approciation`.`sub_head`
