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(10861439,10861440,8630913,8630914,8630919,8630993,8631003,8839038,8631630,8631678,10459918,10459922,10459927,10459928,10459960,10459964,10459969,10459970,10460000,10460004,10460009,10460010,10460040,10460044,10460049,10460050,10460080,10460081,10460089,10460090,10460120,10460124,10460129,10460130,10460160,10460164,10460169,10460170,10460200,10460204,10460209,10460210,10460240,10460244,10460249,10460250,10460280,10460284,10460289,10460290,10460320,10460324,10460328,10460330,10460360,10460364,10460369,10460370,8632538,8067943,8629741,8629742,8629838,8629938,8630406,8630420,8627581,8627582,8627583,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627625,8627626,8627627,8627628,8627629,8627630,8627631,8627632,8627633,8627634,8627707,8627708,8627709,8627710,8627711,8627712,8627713,7201384,7201385,8627793,8627795,8627796,8627797,8627798,8627799,8627800,8627801,8627802,8627821,10866538,10866541,10866546,10866547,10866565,10866566,10866569,10866570,10866571,10866572,10866573,10866574,10866575,10866576,10866577,10866578,8065957,8628627,8628634,5654555,7202684,8629095,8629096,8629099,8629164,8629166,8629173,8629174,8629177,8629178,8629188,8629220,8629222,8629227,8629228,8629229,8629230,8629231,8629250,8629303,8629523,8629525,8629559,3237393,3237394,3237395,8626900,8626901,7200527,7200528,7200529,8626932,8627109,8627120,8627121,8627530,8627574,8627575,8627576,8627577,8627578,8627579,8627580,8071687,8071695,8071705,8071707,8071752,8071760,8071770,8624682,8071772,8624683,8624688,8624690,8624691,8624692,8071817,8071822,8071835,8071837,8071882,8071890,8071900,8071902,8071947,8071955,8071965,8071967,8072012,8072020,8072030,8072032,8072077,8072085,8072095,8072097,8072142,8072150,8072160,8072162,7198681,7198685,8625106,8072207,8072215,8072224,8072227,7198743,7198750,7198770,8072272,8072280,8072290,8072292,8625879,8626201,8626248,8626253,7200121,8834368,11045725,3923672,3923673,4937292,4937300,4937311,4937313,4937361,4937369,4937379,4937381,4937426,4937434,4937444,4937446,4937491,4937499,4937509,4937511,4937556,4937561,4937574,4937576,4937621,4937629,4937639,4937641,4937686,4937694,4937704,4937706,4937751,4937759,4937769,4937771,4937816,4937824,4937834,4937836,4937881,4937889,4937899,4937901,4937946,4937954,4937963,4937966,4938011,4938019,4938029,4938031,8071554,8071562,8071573,8071575,8624524,8071622,8071630,8071640,8071642,8634615,8634616,8634617,8634677,8634678,8634680,8634681,8634682,8634684,8634769,8634770,10617323,10617324,10617378,10617384,10617403,10617430,10617431,10617434,10617438,10617456,8542254,8632627,10620208,10425553,10425577,10848006,10848007,8632908,8632909,8632910,10615341,8633272,8633273,8633274,8633275,8633276,8633277,8633278,10848408,10848409,10615896,10616005,8540530,8540542,8540544,8540565,8540568,8540569,8611003,8634542,8634543,8634545,10610995,10611408,6666259,8565891,8565947,9211554,9211556,9211557,9211561,9211567,9211568,10612938,10612939,10613369,10613736,9169951,9169952,9169953,6674309,6674310,6674327,4975237,10415375,10415376,10419468,8550037,8550038,8550266,8563358,8563359,8563360,8563361,8563362,8563363,8847493,8847496,8847500,8847541,8847542,8847584,8847613,10893986,10893987,10893988,10155731,10890085,10890148,10890154,10890155,10886057,10886058,10886059,10886060,10626241,10602179,10583441,10590278,10590279,10590280,10590309,10647703,10541445,10550384,10550385,10550386,10550445) 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>