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(8630957,8631185,8631189,10861839,10862330,10862331,10862332,10862333,10862334,8632202,8632204,10863000,8629683,8630453,8630454,8630455,10858258,10858259,10858260,10858261,10858262,10858263,10858264,8627729,8627730,3238520,10866548,8595234,10866888,10866889,10866890,10866891,10866892,8911945,7202341,7202342,8628775,10859511,7202672,8626522,7200179,7200894,7200895,7200922,7200933,10855204,10855206,7198765,10855884,10855885,10856097,8625508,8625512,8625513,10856162,10856163,10856164,10856165,10856166,10856167,10856168,7199191,7199210,10864442,7199406,7199415,10864491,10864492,10864493,10864494,10101399,3923562,7197105,10838796,10838797,8904896,8904897,8904898,8904899,8904900,8905236,10617426,8905354,10617473,8905841,10425349,10425360,8632684,8632685,10847921,10425570,10615448,3581874,3581880,10615693,10615696,10615818,10426204,10616084,10616085,10616086,10426363,10616223,10616242,10616318,8611329,10614079,10611122,10611123,10614162,10614175,9214120,9214121,9214123,10614819,8851132,10608973,10608974,10608975,10608976,10608977,10608978,10608979,10608980,10608981,10608982,10608983,10608984,10608985,8851149,8851170,8851275,8851280,8851291,8851339,8851450,8566545,8566546,9220275,9220276,10610152,10610194,10610214,10610231,10610481,10610691,10610694,10610836,10610872,10117546,10117547,10117548,9911569,9911570,9911571,10117664,10117713,9169518,9169577,9169608,9169609,9169610,9911915,9911919,9912012,9912013,9912014,9912015,9912016,9912017,9912018,9912019,9912020,9912022,9912032,9912033,9912034,9912052,10118162,8849993,990591,990592,990594,990595,9912420,990616,990618,990623,990624,990625,990626,990627,990628,990629,990630,990638,990651,990653,990654,10118536,990892,990896,990897,990921,990922,990927,990928,990929,990950,990951,8850419,990983,8850422,9912805,9912806,991015,991016,991017,991018,991020,991021,991024,9912943,991141,991142,991143,991144,991145,991146,991147,991148,991149,991159,991160,991164,8850617,991184,8850650,9913118,9913125,9913126,9913196,8850920,8850941,9913360,8850978,9168437,6672671,6672677,6672681,9168506,9168507,6672718,10419469,9168549,9168550,9168551,9168552,9168631,9168632,9168633,9168634,9168635,9168636,9168637,10415682,10417753,10419768,10419769,10419770,10419771,10419772,10417801,10417802,10417803,10417804,10415996,10415997,10415998,10415999,10416000,10416001,10416002,10416003,10416004,10416005,10416006,9169119,10117327,9169134,6673430,6673431,6673432,10117439,6673465,6673466,6673467,9169294,10469320,10467325,10469483,10469484,10469485,10469491,10469492,10469493,10469494,8550115,9167320,9167339,9167378,9167379,9167380,9167381,9167382,9167383,8855261,10470155,9183786,9183789,9183790,9183791,9167889,9167932,9167933,9168019,10468609,10468610,10468611,10468612,10468613,10468614,9168052,9168053,9168054,9168092,9168094,9168222,9168223,9168224,9168225,9168226,10427645,10427663,10883677,10888705,10888737,10883740,10888746,10883823,10884019,10889263,10889617,10887518,10877579,10908035,10908036,10908037,10883256,10883270,10883277,10883280,10883281,10885640,10161692,10886953,10886990,10886991,10886992,10886993,10886994,10887006,10882074,10882075,10882120,10882121,10882122,10882123,10602577,10602626,10608722,10608723,10608724,10608725,10589875,10608726,10608727,10608728,10608729,10608730,10608731,10608732,10608758,10608759,10608760,10608761,10608762,10608763,10608764,10608767,10608808,10608809,10608810,10608881,10647427,10582559,10582560,10604411,10604412,10507607,10507658,10507659,10507660,10507661,10411266,10411267,10494377,10413966,10410391,10410393,10412800,10412801,10412802,10412803,10412804) 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>