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(10861830,10861831,11041339,8583488,10849390,10849391,10849392,10849393,10849462,10849463,10849464,10849465,10849466,10849467,10849468,10849469,10849476,10849477,10849478,10849479,10849480,10849481,10849482,10849483,10849488,10849489,10849490,10849491,10849492,10849493,10849494,10849495,8632280,8609567,10858188,10960068,10960069,10931829,8836314,8836315,8836316,7202447,5654540,5654541,11000014,10859923,10859924,10859981,3237394,8626691,8910106,8626727,7071265,7071266,10865574,10865575,8627335,10857995,8907881,8907971,8624577,8908006,7198381,10863552,8624927,8556384,8615499,8615500,10101492,8557317,8557319,8557320,8557322,10942100,8557590,10853141,10853145,10853146,10853147,10853148,7196220,3234120,7196979,8613583,7197052,7197077,3234358,3234359,3234360,8070909,8070910,7197792,10995307,10995308,10995309,10995310,8907801,8907804,10855048,8907822,10852116,10852120,10852121,10852122,10852123,10852124,10852126,10852127,10852128,10852363,10852364,10617322,10852508,10852509,10852573,10852574,10852575,10852576,10852577,10852578,10852583,10852584,10852585,10852586,10852587,10852591,10852592,10852593,10852594,10853098,8632462,8609675,8632647,10425392,10951665,10425554,10848006,10850653,10850654,10850739,10850740,10850743,10850744,10850745,10850751,10850752,10616219,10616220,8611003,10851972,8853225,8853226,8853227,8853313,8853315,8853316,8853317,8853318,8853319,8853320,8853321,8853322,8853323,8853324,8853325,8853326,8853327,8853329,8853332,8853333,8853334,8853335,8853336,8853337,8853339,8853342,8853343,8853344,8853345,8853346,8853347,8853348,8853351,8853352,8853353,8853354,8853355,8853357,8853359,8853360,8853361,8853363,8853364,8853369,8853375,8853376,8853377,8853378,8853381,8853382,8853383,8853384,8853385,8853386,8853387,8853388,8853389,8853390,8853391,8853392,8853393,8853394,8853395,8853396,8853397,8853399,10611382,10611390,8864250,10611391,10611393,10611394,10611396,10611400,10611407,10611409,10611411,10611412,10611413,10611414,10611422,10611426,10611427,10611428,10611434,10611435,10611436,10611437,10611442,10611444,10611445,10611449,10611450,10611455,10611463,10611473,10611476,10611477,10611479,10611480,10611486,10611491,10611499,10614501,10611507,10611514,10611517,10611525,10611528,10611532,10611536,10611537,10611542,10611543,10611546,10611551,10611554,10611560,10611567,10611571,10611572,10611574,10611581,10611584,10611585,10611588,10611594,10611596,10611597,10611598,10611600,10611603,10611604,10611605,10611608,10611611,10611617,10611618,10611619,10611620,10611621,10611623,10611624,10611635,10611636,10611637,10611638,10611646,10611647,10611648,10611655,10611665,10611676,10613097,9188439,10613137,8567170,8852578,6677317,8849327,9178490,9178492,9178848,9178851,8850815,8850976,10415675,10418807,10418808,8848820,8848821,8848822,8848823,10417085,10122529,10122530,10122531,10122532,8847533,8847534,8847535,8847536,10468328,8848093,8848094,8848095,10883568,10883571,10905157,10905158,10905159,7000845,10632310,10172413,10172414,10172434,10167934,10631412,10631413,10167992,10626590,10168205,10602174,10602175,10601398,10602690,10602693,10602695,10602696,10602697,10602698,10602699,10602732,10604085,10601787,10505583,10508656,10508663,10508664,10508665,10507861,10507862,10507863,10409350,10409351,10409352,10486109,10486110,10486111,10486112,10486113,10486114,10486115,10486156,10486157,10486158,8562603,8562604,10407922,10407923,10407992,10407993,10407996,10407998,10408000,10408002,10408004,10408005,10414319,10414320,10414374,10412581,10412731,10412759,10408765,10408768,10408769,10715073,10408770,10408772,10408773,10408774,10408775,10408776,10408974,10408976,10409028,10409029,10409031,10409033,10409035,10409036,10409038,10409040,10409042,10409043,10409044,10409045,10409046,10409047,10409048,10409049,10407052,10407054,10407056,10407058,10407059,10407062,10407064,10407065,10407067,10407068,10407070,10407071,10407073,10407074,10407075,10407076,10407077,10407078,10407079) 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>