FUNCTION product.IF does not exist<hr>SELECT `product`.productID, `product`.IF(LENGTH(`name_pl`), `name_pl`, `name_ru`) AS name, Price, in_stock, slug, `category`.categoryID as categoryID, product_code, `product`.`discount1`, `product`.`discount2`, `product`.`discount3` from SC_products as `product` LEFT JOIN SC_category_product as `category` ON (`product`.productID=`category`.productID) WHERE `category`.categoryID&gt;1 and Price&gt;0 and enabled=1 AND (`product`.`categoryID` &gt;686 AND `product`.`categoryID` &lt;700 AND `product`.`categoryID` &lt;&gt;701 AND `product`.`categoryID` &lt;&gt;706 AND `product`.`categoryID` &lt;&gt;707 AND `product`.`categoryID` &gt;721 AND `product`.`categoryID` &lt;726) order by CategoryID, name;