You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and pay_period >= '2024-04-30' and end_bal > 0 GROUP BY D.po_number ' at line 14 SELECT CONCAT(mem_lname, ', ', mem_fname, ' ', LEFT(mem_mname, 1), '.') as maker_name, D.dr_number as dr_number, D.po_number as po_number, pay_period, beg_bal, po_date, A1.maker_id as member_id, A1.sales_id FROM ar_loans_comakers A1 LEFT JOIN mem_members B1 on A1.maker_id = B1.member_id LEFT JOIN ar_loans_subs_detail C on A1.sales_id = C.sales_id LEFT JOIN ar_loans_header D on A1.sales_id = D.sales_id WHERE A1.member_id = and pay_period >= '2024-04-30' and end_bal > 0 GROUP BY D.po_number ORDER BY CONCAT(mem_lname, ', ', mem_fname, ' ', LEFT(mem_mname, 1), '.'), po_date, D.po_number