FUNCTION product.IF does not exist<hr>SELECT `product`.productID, `product`.IF(LENGTH(`name_ua`), `name_ua`, `name_ru`) AS name, 
				`product`.Price, `product`.in_stock, `product`.slug, `product`.categoryID, `product`.product_code,
				MIN( `product_mod`.Price ) as `mod_price`
				
				FROM SC_products as `product`
				LEFT JOIN SC_modifications as `mods` ON `product`.productID = `mods`.productID
				LEFT JOIN SC_products as `product_mod` ON `mods`.modID = `product_mod`.`productID`
							
				WHERE `product`.categoryID&gt;1 and `product`.Price&gt;0 and `product`.enabled=1 
				GROUP BY `product`.productID
				order by `product`.sort_order, `product`.productID