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(10939571,10939572,10939573,10939574,3228558,8569438,8569439,8569642,8569643,10950394,9216147,9216148,3230034,3230035,3230036,3230037,3230038,3230039,3230040,3230041,3230042,3230043,3230044,3230045,3230046,3230047,3230048,3230049,3230050,3230051,3230052,3230053,3230054,3230055,3230056,3230057,3230058,3230059,3230060,3230061,3230062,3230063,3230064,3230065,3230066,3230067,3230068,7066765,7066766,7066767,10929303,10929327,3227614,3227615,3227616,10962409,10962410,10962411,10962412,10962413,10962414,10931516,10858826,10858827,10858828,10858829,10858830,10858831,10858832,7064587,7064588,10867336,10867337,10867338,10867339,7065354,7065355,8560538,8560539,8834875,8834876,8834877,8834878,8834879,8834880,10943182,10931205,11047649,10101051,10856260,10840971,3236644,8834279,3237317,10618240,10618241,10618242,10618243,10618244,10618245,3923735,3923736,3923737,3923738,3923739,3923740,3923741,3923742,3923743,3923744,3923745,3923746,3923747,8554592,8554593,8554624,8907030,8907031,8611881,8611882,8611883,8611884,8611885,10852391,10852392,10837569,3233324,8609812,8609813,10851224,10926742,10926743,10926744,10926745,10926746,10926747,10926748,9165713,9165714,9165715,6665809,6665810,6665811,6665812,6665813,6665814,6665815,6665959,6665960,6665961,6665962,6665963,8542516,8861887,8861888,9172015,9172016,9172017,9172018,9172019,9172020,9172021,9172022,9172023,9172024,9172025,9172026,9172027,9172028,8862684,3653544,7018013,7018014,7018015,7018016,7018017,7018018,7018019,7018020,7018021,7018022,7018023,7018024,7018025,7018026,7018027,7018028,7018029,8852820,8852821,8852822,8852823,8852824,10125634,10513926,10513927,10513928,10513929,10513930,10513931,10513932,10513933,10513934,10513935,10513936,10513937,10513938,10513939,10513940,10513941,10513942,10513943,10513944,10513945,10513946,10513947,10513948,10118994,10118995,10118996,10118997,10118998,10118999,8542396,10116745,10420141,10420142,10420143,10420144,6666536,6666537,6666538,6666539,6666540,6666541,6666542,8865153,8916418,6473414,8550319,8550320,8550321,8916887,6473649,6473650,6474127,6474165,6474166,6474167,10891237,10891238,10891239,10891240,10891241,10891242,10891243,10891244,10891245,10891246,10891247,10891248,10891249,10891250,10891251,10648013,10607157,8562219,10408223,8562165) 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>