SELECT SG.SKU_GRP_ID, SG.SKU_GRP_NM, SG.SKU_GRP_DSC, SG.SKU_GRP_IMG_200, MIN(US_PRICE) AS MIN_PRICE, MAX(US_PRICE) AS MAX_PRICE, MIN(US_SALE_PRICE) AS MIN_SALE_PRICE, MAX(US_SALE_PRICE) AS MAX_SALE_PRICE, MIN(LEADTIME) AS MIN_LEADTIME, SALE_START_DATE, SALE_END_DATE, M.BRAND_NM, SG.MFR_ID, SG.PRIORITY_LVL FROM SKU_GROUP_NEW AS SG INNER JOIN ITEM AS I ON I.SKU_GRP_ID = SG.SKU_GRP_ID INNER JOIN ITEM_PRICING AS IP ON IP.ITEM_ID = I.ITEM_ID INNER JOIN ITEM_SHIPPING AS ISHIP ON ISHIP.ITEM_ID = I.ITEM_ID INNER JOIN MANUFACTURER AS M ON M.MFR_ID = SG.MFR_ID WHERE SG.ACTIVE = 1 AND I.ACTIVE LIKE 'TRUE' AND AND SITE_IDS LIKE '%2%' GROUP BY SKU_GRP_ID ORDER BY PRIORITY_LVL: 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 SITE_IDS LIKE '%2%' GROUP BY SKU_GRP_ID ORDER BY PRIORITY_LVL' at line 1