TYPE=VIEW
query=select \'\' AS `slno`,`a`.`Acc_no` AS `SB_ac_no`,concat(`a`.`Name`,\' - \',`a`.`Father_Name`) AS `name_of_group`,`a`.`Nominee_Name` AS `female_member`,`a`.`Nominee_Name` AS `total_member`,`a`.`Date_open` AS `Account_opeing`,round((sum(`v`.`cr`) - sum(`v`.`dr`)),2) AS `Amount_deposit`,round((select sum(`v1`.`cr`) from `co-operativebank-dkmadhabpur`.`voucher` `v1` where ((`v1`.`Acc_no` = `v`.`Acc_no`) and (`v1`.`date` >= \'2025-01-07\') and (`v1`.`date` <= \'2025-01-07\'))),2) AS `this_month_deposit` from `co-operativebank-dkmadhabpur`.`account` `a` join `co-operativebank-dkmadhabpur`.`voucher` `v` where ((`v`.`Acc_no` = `a`.`Acc_no`) and (`v`.`date` <= \'2025-01-07\') and (`a`.`Sub_Head` = \'14201\')) group by `v`.`Acc_no`
md5=b2056413fef383bc43dabce61b50e9c4
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2025-01-07 06:15:13
create-version=1
source=SELECT \'\' as slno,a.Acc_no as SB_ac_no,concat(Name,\' - \',Father_Name) as name_of_group,Nominee_Name as female_member,Nominee_Name as total_member,Date_open as Account_opeing,round(sum(cr)-sum(dr),2) as Amount_deposit,round((select sum(cr) from voucher v1 where v1.acc_no=v.acc_no and v1.date>=\'2025-01-07\' and v1.date<=\'2025-01-07\'),2) as this_month_deposit  FROM `account` a,voucher v WHERE v.acc_no=a.acc_no and v.date<=\'2025-01-07\' and a.sub_head=\'14201\' group by v.acc_no
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select \'\' AS `slno`,`a`.`Acc_no` AS `SB_ac_no`,concat(`a`.`Name`,\' - \',`a`.`Father_Name`) AS `name_of_group`,`a`.`Nominee_Name` AS `female_member`,`a`.`Nominee_Name` AS `total_member`,`a`.`Date_open` AS `Account_opeing`,round((sum(`v`.`cr`) - sum(`v`.`dr`)),2) AS `Amount_deposit`,round((select sum(`v1`.`cr`) from `co-operativebank-dkmadhabpur`.`voucher` `v1` where ((`v1`.`Acc_no` = `v`.`Acc_no`) and (`v1`.`date` >= \'2025-01-07\') and (`v1`.`date` <= \'2025-01-07\'))),2) AS `this_month_deposit` from `co-operativebank-dkmadhabpur`.`account` `a` join `co-operativebank-dkmadhabpur`.`voucher` `v` where ((`v`.`Acc_no` = `a`.`Acc_no`) and (`v`.`date` <= \'2025-01-07\') and (`a`.`Sub_Head` = \'14201\')) group by `v`.`Acc_no`
