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(10861363,3228944,3228945,3228953,10850020,8632383,8632384,8632499,8632521,10860426,7201307,3238534,10866427,10866428,7201399,7201635,10858948,7201959,7201975,10859286,10859288,10859795,10860033,10860075,7065920,10857283,8910080,10865571,10857890,8627447,10866137,10866141,10866143,10866145,10863436,10863437,7198698,7198702,7198704,10856137,8909072,8909073,8909074,10856515,10856553,11035974,8626261,10857076,10857132,3923399,3923467,10853411,10618178,10618179,10618180,10618181,10853737,10623491,10623492,10623508,7197231,7197232,7197235,7197246,7197258,7197270,7197275,7197279,10854322,7197281,10838794,10854361,10854362,10854363,10854870,10854874,10854879,10854880,10854903,10854920,10854974,10854999,10855005,10855120,10855121,10855122,10855123,10855124,10855125,10855126,8904993,8904998,8904999,8905354,10852611,8612185,3232886,10954201,10850371,3581878,10615571,10850884,8633275,10615818,10965514,10426338,8540594,8540625,8611289,10616576,10616641,10616642,10616643,10616644,10616645,10616684,10616866,10616911,8904987,8904990,10610984,10610985,10614048,10614050,6669818,10714111,10614314,10714137,10612670,10609770,10609824,8566712,10609883,10609884,10612884,10609885,10609886,10609898,10609899,10612904,10612905,10609905,10612907,10609911,10612912,10612914,10609934,10609935,10609936,10609937,10609938,10609939,10609940,10609941,10609942,10609943,10609946,10613079,10613080,10610098,10613193,10613322,10613440,10613442,10613453,10610836,6673559,6673560,6673577,6673578,6673579,6673580,6673581,6673582,6673583,6673584,6673585,6673586,6673587,6673588,6673589,6673590,6673591,6673592,6673593,6673594,6673595,6673596,6673597,6673598,6673599,6673600,6673601,6673602,6673603,6673604,6673605,6673606,6673609,6673610,6673612,6673615,6673617,6673618,6673619,6673620,6673621,6673622,6673623,6673624,6673625,6673626,6673628,6673629,6673631,6673632,6673633,6673635,6673736,6673740,6673741,6673742,6673773,6673811,9911815,9911825,9911826,10117944,9912020,6674172,9169985,9169986,6674337,6674340,9912648,8850507,8850508,8850509,8552174,10419258,6672602,10415323,6672609,6672610,6672663,6672666,6672676,10419407,10419408,6672702,9168508,6672721,6673072,9168924,9168926,6673163,6673165,6673166,6673167,6673168,6673169,6673170,6673172,6673173,6673175,6673178,6673179,6673180,6673182,6673183,6673184,6673185,6673186,6673188,6673189,6673190,6673191,6673193,6673194,6673195,6673197,6673198,6673199,6673200,6673201,6673202,6673203,6673204,6673206,6673208,6673210,6673211,6673212,6673213,6673214,6673215,6673219,6673220,6673221,6673222,6673223,6673224,6673225,6673227,6673228,6673230,6673231,6673232,6673234,6673235,6673236,6673237,6673239,6673240,6673241,6673243,6673244,6673246,6673249,6673250,6673251,6673252,6673253,10416971,6673255,10416972,6673256,6673257,6673258,6673259,6673260,6673261,6673262,6673263,6673264,6673265,6673266,6673268,6673269,6673270,6673274,6673275,6673276,6673280,6673283,6673284,6673285,6673286,6673287,6673291,6673292,6673294,6673295,6673296,6673298,6673300,6673302,6673303,6673305,6673306,6673307,6673309,6673312,6673313,6673314,6673315,6673316,9169257,9169287,8549948,10467613,10467615,10467626,9167837,9167852,10888933,10889013,10884474,10884523,10889797,10879870,10889947,10889948,10889983,10885018,10887662,10887663,10887664,10882901,10882917,10882939,10882942,10882951,10882957,10882960,10882988,10882989,10882990,10161820,10161821,10876634,10602149,10647354,10603833,10604086,10508267,10508395,10507663,10507664,10411252,10407462,10411551,10411580,10409753,10410097,10410142,10410146,10410151,10410152,10410163,10410172,10410185,10410196,10410209,10410215,10414217,10410218,10410323,10410324,10410325,10410326,10410327,10410328,10414426,10414464) 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>