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(7065975,7065976,7066249,10849558,10849559,10849560,10849561,10849562,10862915,10862916,10862917,10862918,10862919,10862920,10862921,10862922,10862923,10862924,10862925,8632531,8065818,8065819,10859161,5654680,7201107,11048357,10857013,10857014,10857015,10857016,10857017,10857018,10857019,10857020,10857021,10857022,10857023,10857024,10857025,10857026,10857027,10857028,10857029,10857030,10857031,10853407,10853408,10838899,10838900,10838901,3235104,3235105,10616999,10927509,10617000,10617001,10617002,10617003,10617004,10617005,10617006,10617007,10617008,10617086,10617087,10617088,10617089,10617090,10617091,10617092,10617093,10617094,10617095,10617096,10617097,10617098,10617241,10617242,10617243,10617244,10617245,10617246,10617247,10617248,10617249,10617250,10617251,10617252,10617253,10617254,10617255,10617256,10617257,10617258,10617259,10617260,10617261,10617262,10617263,10617264,10617265,10617266,10617267,10617268,10617269,10617270,10617271,10617272,10617273,10617274,10617275,10617276,10617277,10617278,10617279,10617280,10617281,10617282,10617283,10617284,10617285,10617286,10617287,10617288,10617289,10617290,10617291,10617292,10617293,10617294,10852704,10852705,10617506,10853076,10615235,10615236,7155264,7155265,10611242,10611243,10611244,10611245,10611246,10611247,10611248,10714201,8852318,8852319,10610233,9169450,10117764,10117765,10117766,10117767,10117768,10117769,10117770,10117771,10117772,10117773,6673817,10118017,9169825,9912122,9912123,9912124,9912125,9912126,9912127,9912128,9912129,9912130,6674340,8850582,8850583,8850584,8850585,9912968,8850586,9912969,10416489,10416490,10416491,10416492,10416493,10416494,10416495,10469285,8549999,976586,9168194,10884355,10884356,10884357,10884358,10884359,10884360,10884361,10884362,10884363,10884364,10884365,10884366,10884367,10889903,10889904,10889905,10888282,10883431,10590996,10508322,10508323,10508324,10508325,10508326,10508327,10508328,10508452,10507790,10507791,10507792,10507793,10507794,10409312,10413651,10411868,10411869,10411870,10411871,10411872,10411873,10411874,10411875,10411876,10411877,10411878,10411879,10411880,10411881,10411882,10411883,10411884,10411885,10409071,10409099,10409100,10409101,10407142,10407143,10407145,10407146,10407147) 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>