SELECT frm.feesrec_no, frm.feesrec_checkno, frm.feesrec_date, frm.feesrec_cash, frm.feesrec_no, frm.feesrec_refno, frm.feesrec_total, frm.feesrec_bankname, frm.feesrec_id, sm.student_id, frm.transaction_id, frm.payment_mode, sd.student_curdiv, CONCAT(sm.student_firstname,' ',sm.student_lastname,' ',sm.student_surname) AS student_name, sec.section_name, sd.student_grno, (select standard_name from sms_standard std where std.standard_id = sd.student_curstd) As standard_name, um.user_name FROM sms_feesrecmaster frm, sms_studentmaster sm, sms_sectionmaster sec, sms_studentdetail sd, sms_usermaster um WHERE sm.student_id=sd.student_id AND frm.student_id = sm.student_id AND frm.student_id = sd.student_id and frm.section_id = sec.section_id AND frm.section_id = sd.section_id AND frm.login_id = um.user_id AND sd.year_id=frm.year_id and frm.school_id = '1' AND sec.school_id = '1' AND frm.year_id = '1' AND frm.feesrec_date >= '2026-08-06' AND frm.feesrec_date <= '2026-08-06' AND frm.login_id = 2 order by frm.feesrec_no ASC