В нашем магазине в ассортименте представлена керамическая плитка, а также ступени, агломерат, ламинат, клей и затирка и многие другие виды продукции.

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 NOT dublicate ORDER BY pricecon ) UNION (SELECT id,header,(C' at line 1 SELECT * FROM ( (SELECT id,header,(CASE currency WHEN 'usd' THEN round(price * 63.74,2) WHEN 'euro' THEN round(price * 77.21,2) WHEN 'rur' THEN price END) as pricecon,picture,descript,price,novelty,special,articul,price_opt,params,manufacture_id,state,dublicate FROM tovar WHERE price AND catalog_id IN () AND NOT dublicate ORDER BY pricecon ) UNION (SELECT id,header,(CASE currency WHEN 'usd' THEN round(price * 63.74,2) WHEN 'euro' THEN round(price * 77.21,2) WHEN 'rur' THEN price END) as pricecon,picture,descript,price,novelty,special,articul,price_opt,params,manufacture_id,state,dublicate FROM tovar WHERE price = 0 AND catalog_id IN () AND NOT dublicate ) ) AS subquery ORDER BY (CASE WHEN (pricecon = 0) THEN 42424242424242424242424242 ELSE pricecon END)