TYPE=VIEW
query=select if(((sum(`h1`.`cr`) - sum(`h1`.`dr`)) > -(100000)),(sum(`h1`.`cr`) - sum(`h1`.`dr`)),0) AS `br`,if(((select if((sum(`h2`.`cr`) > 0),sum(`h2`.`cr`),0) AS `ln1` from `co-operativebank-radhapur`.`headvoucher` `h2` where ((`h2`.`hcode` = `h1`.`hcode`) and (`h2`.`htcode` = \'15000\') and ((`h2`.`date` >= \'2025-04-01\') + interval -(1) year) and ((`h2`.`date` <= \'2026-03-31\') + interval -(1) year)) group by `h2`.`hcode`) > 0),(select if((sum(`h2`.`cr`) > 0),sum(`h2`.`cr`),0) AS `ln1` from `co-operativebank-radhapur`.`headvoucher` `h2` where ((`h2`.`hcode` = `h1`.`hcode`) and (`h2`.`htcode` = \'15000\') and ((`h2`.`date` >= \'2025-04-01\') + interval -(1) year) and ((`h2`.`date` <= \'2026-03-31\') + interval -(1) year)) group by `h2`.`hcode`),0) AS `br1`,(`h1`.`hcode` + 46000) AS `hcode`,`h1`.`head` AS `head` from `co-operativebank-radhapur`.`headvoucher` `h1` where ((`h1`.`htcode` = \'15000\') and (`h1`.`date` <= \'2024-03-31\')) group by `h1`.`hcode`
md5=84eb60d31cb60686f503dcbd0dbe5773
updatable=0
algorithm=0
definer_user=admin
definer_host=%
suid=2
with_check_option=0
timestamp=2025-10-07 09:24:11
create-version=1
source=select if(((sum(`h1`.`cr`) - sum(`h1`.`dr`)) > -(100000)),(sum(`h1`.`cr`) - sum(`h1`.`dr`)),0) AS `br`,if(((select if(((sum(`h2`.`cr`) ) > 0),(sum(`h2`.`cr`) ),0) AS `ln1` from `headvoucher` `h2` where ((`h2`.`hcode` = `h1`.`hcode`) and (`h2`.`htcode` = \'15000\') and date_add((`h2`.`date` >= \'2025-04-01\'), interval -1 year) and date_add((`h2`.`date` <= \'2026-03-31\'), interval -1 year)) group by `h2`.`hcode`) > 0),(select if(((sum(`h2`.`cr`) ) > 0),(sum(`h2`.`cr`) ),0) AS `ln1` from `headvoucher` `h2` where ((`h2`.`hcode` = `h1`.`hcode`) and (`h2`.`htcode` = \'15000\') and date_add((`h2`.`date` >= \'2025-04-01\'), interval -1 year) and date_add((`h2`.`date` <= \'2026-03-31\'), interval -1 year)) group by `h2`.`hcode`),0) AS `br1`,(`h1`.`hcode` + 46000) AS `hcode`,h1.head from `headvoucher` `h1` where ((`h1`.`htcode` = \'15000\') and (`h1`.`date` <= \'2024-03-31\')) group by `h1`.`hcode`
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select if(((sum(`h1`.`cr`) - sum(`h1`.`dr`)) > -(100000)),(sum(`h1`.`cr`) - sum(`h1`.`dr`)),0) AS `br`,if(((select if((sum(`h2`.`cr`) > 0),sum(`h2`.`cr`),0) AS `ln1` from `co-operativebank-radhapur`.`headvoucher` `h2` where ((`h2`.`hcode` = `h1`.`hcode`) and (`h2`.`htcode` = \'15000\') and ((`h2`.`date` >= \'2025-04-01\') + interval -(1) year) and ((`h2`.`date` <= \'2026-03-31\') + interval -(1) year)) group by `h2`.`hcode`) > 0),(select if((sum(`h2`.`cr`) > 0),sum(`h2`.`cr`),0) AS `ln1` from `co-operativebank-radhapur`.`headvoucher` `h2` where ((`h2`.`hcode` = `h1`.`hcode`) and (`h2`.`htcode` = \'15000\') and ((`h2`.`date` >= \'2025-04-01\') + interval -(1) year) and ((`h2`.`date` <= \'2026-03-31\') + interval -(1) year)) group by `h2`.`hcode`),0) AS `br1`,(`h1`.`hcode` + 46000) AS `hcode`,`h1`.`head` AS `head` from `co-operativebank-radhapur`.`headvoucher` `h1` where ((`h1`.`htcode` = \'15000\') and (`h1`.`date` <= \'2024-03-31\')) group by `h1`.`hcode`
