Query Error : SELECT M1.*,RV0.LBL_VALUE AS LV_PRODUCT,RV1.LBL_VALUE AS LV_DESCR,RV2.LBL_VALUE AS LV_FULLDESCR,RV3.LBL_VALUE AS LV_KEYWORDS FROM SBCWEB_PRODUCT M1 INNER JOIN SBCWEB_RESOURCE_VALUE RV0 ON M1.PRODUCT_LBLID = RV0.RESOURCE_ID INNER JOIN SBCWEB_RESOURCE_VALUE RV1 ON M1.DESCR_LBLID = RV1.RESOURCE_ID INNER JOIN SBCWEB_RESOURCE_VALUE RV2 ON M1.FULLDESCR_LBLID = RV2.RESOURCE_ID INNER JOIN SBCWEB_RESOURCE_VALUE RV3 ON M1.KEYWORDS_LBLID = RV3.RESOURCE_ID WHERE RV0.LANG_ID = 1 AND RV1.LANG_ID = 1 AND RV2.LANG_ID = 1 AND RV3.LANG_ID = 1 AND M1.IS_PURGED = 0 AND M1.XID = AND FORSALE != 'N' ORDER BY XID ASC
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 FORSALE != 'N' ORDER BY XID ASC' at line 1