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(7201676,10858960,10858961,10858963,10858964,10858965,7202129,7202130,7202137,7202139,7202140,7202162,7202200,7202208,7065974,10857801,10857807,10857808,10857810,10855755,10855756,10855757,10855758,8625142,8625163,10866059,10866126,3923420,10853358,10853411,8554305,10866734,10866735,10866736,10864082,10864208,10864209,10864891,8552639,8552693,8552694,8552695,8552710,10862800,10862809,10862851,8632542,8632543,10863211,10850371,10850533,10850534,10850535,10850572,10850574,10615391,10861944,10861954,10861956,10861958,10861959,10861960,10616301,8583490,10616804,8851647,8851648,8851649,8851650,8851651,8851652,8851653,8851654,8851655,8851770,8851771,8851772,8851773,10612809,8852150,8852154,8852200,8852201,8852202,8852203,8852204,8852205,8852206,8852207,8852208,8852209,8852210,8852211,8852212,8852213,8852214,8852215,8852216,8852217,8852218,8852219,8852220,8852221,8852222,8852223,8852224,8852225,8852226,8852227,8852228,8852229,8852230,8852231,8852232,8852233,8852234,8852235,8852236,8852237,8852238,8852239,8852240,10613079,8852241,8852242,10613080,8852243,8852244,8852245,8852246,8852326,8852327,8852338,8852374,8852375,8852377,8852386,8852388,8852389,8852390,8852391,8852523,8852728,8852729,8852735,8849380,8849381,8849382,8849383,8849384,8849386,8849387,8849388,8849389,8849390,8849391,8849392,8849393,8849394,8849395,8849396,8849397,8849398,8849399,8849400,8849401,8849402,8849403,8849404,8849405,8849406,8849408,8849409,8849410,8849411,8849418,10117943,9169863,8849782,10118251,10118257,8850261,8850262,8850263,8850264,8850265,8850266,8850267,8850268,8850269,8850270,8850271,8850272,8850273,8850274,8850275,8850276,8850277,8850278,8850279,8850280,8850281,8850282,8850283,8850284,8850285,8850286,8850287,8850288,8850289,8850290,8850291,8850292,8850293,8850294,8850295,8850296,8850297,8850298,8850299,8850300,8850301,8850302,8850303,8850304,8850305,8850306,8850307,8850308,8850309,8850310,8850311,8850312,8850313,8850314,8850315,8850316,8850317,8850318,8850319,8850320,8850321,8850532,10419255,8848627,8848628,8848629,8848630,8848631,8848632,8848633,8848634,8848635,8848636,8848637,8848638,8848639,8848640,8848641,8848642,8848643,8848644,8848645,8848646,8848647,8848648,8848649,8848650,8848651,8848652,8848653,8848654,8848655,8848656,8848657,8848658,8848659,8848660,8848661,10416758,8848662,8848663,8848664,8848665,8848666,8848667,8848668,8848669,8848670,8848671,8848672,8848673,8848674,8848675,8848676,8848677,8848678,8848679,8848680,8848681,8848682,8848683,8848684,8848685,8848686,8848687,8848688,8848689,8848690,8848691,8848692,8848693,8848694,8848695,8848696,8848697,8848698,10116077,10116083,10116089,10884322,10888324,10611236,10610398,10610399,10407837,10407840,10407873,10407875,10412400,10482567,10482568,10482569,10482570,10482571,10482572) 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>