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,REF_TYPE,FILENAME,SPRICE.PRICE,SEO.STATIC_IDENTIFIER,COMPLETE_URL,MANUFACTURER_ID 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
INNER JOIN SBCWEB_IMAGE SBIMG ON (SBIMG.ID = M1.XID AND SBIMG.REF_TYPE = 'T' AND SBIMG.IS_PURGED = 0)
INNER JOIN SBCWEB_PRICING SPRICE ON (SPRICE.PRODUCT_ID = AND SPRICE.VARIANT_ID = 0 AND SPRICE.IS_PURGED = 0)
INNER JOIN SBCWEB_SEO_URL SEO ON (M1.META_ID = SEO.META_ID AND SEO.REF_XID = 0)
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 M1.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 SPRICE.VARIANT_ID = 0 AND SPRICE.IS_PURGED = 0)
INNER JOIN SBCWEB_SEO_' at line 8 | 
