Error in Query : SELECT p.iProductId, if(pl.vProductName='' OR pl.vProductName is null, p.vProductName, pl.vProductName) as vProductName, p.fPrice, p.fRetailPrice, p.vImage, p.iCurrentStock, p.eOutofstock, p.iSEOCategoryId, c.vCategory FROM products p LEFT JOIN products_lang pl ON p.iProductId = pl.iProductId AND pl.iLanId = '1' LEFT JOIN category c ON p.iSEOCategoryId = c.iCategoryId WHERE p.iProductId <> '697' AND if(<>0,p.iBrandId='',1) AND p.iStatus = 1 AND p.iCurrentStock > 0 AND p.eFeatured='Y' ORDER BY p.iViewed DESC, rand() LIMIT 0, 12
1064 : 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 '<>0,p.iBrandId='',1) AND p.iStatus = 1 AND p.iCurrentStock > 0 AND p.eFeatured='' at line 1