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(10845791,9215234,9215235,9215236,7065994,11016242,11016243,11016244,11016245,8622416,10872398,11013903,11026958,7067609,6000213,7064071,8559186,11012353,11012354,11012355,11012356,8618982,8618983,10859481,10859482,10859483,10999973,7065339,10859776,7073761,11013455,10868100,3237368,3237369,7071360,11024320,8615689,8615690,11035813,10856417,11023062,11023063,11020152,11020153,11020154,3234728,10954024,10617520,8542241,8570218,8570219,7155064,10852001,10852060,8864588,9915308,7023555,8849790,8849835,10513866,10513867,10513868,10513869,10513870,10513871,8849884,10513872,10513900,10513901,10513902,6674623,8850455,8850456,8850457,8918247,10428384,4974082,4974083,4974084,4971317,8854698,8854699,10465754,9199681,8917342,8917343,10123967,10123968,10123969,9167973,9192295,9192296,10888680,10629291,10629292,10912568,10912609,10172409,10172410,10172411,10162488,10652818,10652825,10606968,10588713,10588714,10588715,10588716,10588717,10588718,10588719,10547833,10547834,10547835,10547836,10547837,10547838,10547839,10547840,10547841,10547842,10547843,10547844,10547845,10547846,10547847,10547848,10547849,10547850,10547851,10547852,10547853,10547854,10547855,10547856,10547857,10547858,10547859,10547860,10547861,10547862,10547863,10547864,10547865,10547866,10547867,10547868,10547869,10547870,10529970,10536782,10536783,10536784,10536785,10536786,10536787,10536788,10536789,10536790,10536791,10536792,10536793,10536794,10536795,10536796,10536797,10536798,10536799,10536800,10536801,10536802,10536803,10536804,10536805,10536806,10536807,10536808,10536809,10536810,10423534,10480977,10480978,10480979,10411456,10413937,10413938,10413939,10414201,10493273,10408675) 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>