QUERY: SELECT
	                  
            p.products_id,
            p.products_model,
            p.label_ids,
            p.main_category,
            p.products_ean,
            p.products_fsk18,
            p.products_quantity,
            p.products_quantity_min,
            p.products_quantity_step,
            p.products_price,
            p.products_price_small_opt,
            p.products_price_opt,
            p.products_purchase_price,
            p.small_opt_purchase_price,
            p.count_small_opt_purchase_price,
            p.count_opt_purchase_price,
            p.opt_purchase_price,
            p.postavshik,
            p.suplier_catalog_id,
            p.postavshik_comment,
            p.name_catalog_id,
            p.products_tax_class_id,
            p.products_image,
            p.products_vpe,
            p.products_vpe_status,
            p.products_vpe_value,
            p.products_currency,
            p.products_page_url,
            p.video,
            p.show_video,
            pd.products_short_description,
	        p.rev_total,
	        p.rev_rating,
            pd.products_name,
	                  p.products_ordered,
	                  pd.products_short_description,
	                  s.status,
	                  IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
	                  m.manufacturers_name,
	                  m.manufacturers_id FROM products  AS p 
	LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id) 
	LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
	LEFT JOIN specials AS s on p.products_id = s.products_id
	LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id) 
	LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1  AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(4970671,8573243,7202367,7202371,7202373,7202375,7202378,7202381,7202383,7202384,7202385,7202386,7202388,7202390,7202392,7202394,7202396,7202398,7202400,7202402,7202404,7202406,7202408,7202410,7202413,7202415,7202417,7202421,7202423,7202425,7202427,7202430,7202432,10855820,10855822,10855824,10855825,10855826,10855827,10855828,10855829,10855830,10855845,10855847,10855858,10855863,10941262,8908708,8908709,8908710,8908711,8908713,8908714,8908717,8908718,8908722,8908723,8908730,8908738,8908739,8908741,8908746,8908747,8908751,8908752,8908754,8908758,8908759,8908760,8908761,8908762,10838793,8905186,8905187,8905188,8905192,8905195,7155257,7155258,7155259,9220274,10610568,10610570,10610573,10610576,10610578,10610580,10610585,10610586,10610587,10610588,10610594,10610598,10610604,10610611,10610613,10610615,10610627,10610634,10610635,10610636,10610637,10610638,10610639,10610640,10610644,10610657,10610658,10610659,10117593,10117596,10117599,10117600,10117602,9911989,9912001,8850289,8850291,8850305,8850306,8850309,8850310,8850311,8850312,8850313,8850314,8850315,8850316,8850317,8850318,8850319,8850320,8850321,8850332,8850334,8850343,8850348,3963319,10467907,10467909,10467910,10467911,10467912,10467913,10467914,10467915,10427640,10883526,10883528,10883531,10883532,10883533,10883534,10883535,10883536,10883548,10883551,10883552,10161855,10161859,10647401,10647408,10647412,10647417,10650733,10650741,10650819,10650820,10507625,10410971,10410973,10410974,10410975,10410976,10410977,10410978,10410979,10410994,10410996,10411007,10411012) GROUP BY p.products_id  ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END  asc ,p.products_specials desc<br>
ERROR: Unknown column 'p.products_specials' in 'order clause'<br>