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(8561972,10870367,7076163,7076244,7076245,7076246,7076247,7076249,7076250,7076251,7076252,7076253,7076255,7076257,7076261,7076263,7076266,7076283,8630945,8630946,8631880,8631884,8631888,10871771,8609684,8620474,8627886,10843045,10973145,10960243,10960244,10960245,10960246,10960247,10960248,8595378,8628448,3899620,8629095,8629096,8629097,8629098,8629099,8629100,7202738,8629226,8626694,8626697,8626698,8626733,8626740,8626796,8626797,7200632,3927827,10943155,7200835,11049529,11049533,10985538,8614993,3925727,3925752,3925847,3926056,10941823,10941833,8909458,8909459,7070633,10856954,7070796,10101950,7070836,10918581,10918582,10967874,10967875,8613062,8906285,8554206,8554209,8554210,8554212,8554213,8554214,8554217,8554218,8554226,8554227,8554228,8554229,8554233,8554237,8554239,8554240,8554242,8554245,8554249,8554250,8554255,8554256,8554259,8554260,8554263,8554264,8554267,8554268,8554337,8906477,7158057,8907698,8634687,10992726,10992727,10992927,10992928,8634922,10992963,10993096,10993097,7156036,10993259,11032285,10993310,10993311,10993312,10993315,10993318,8553746,8579067,8632905,8570518,8633201,10991663,10991664,10991665,10991666,10991667,10991668,10991669,10991670,10991671,10991672,10991673,10991674,10991675,10991676,10991677,10991678,10616050,10616052,10991775,10991783,10991784,10991785,8634154,8541091,10992405,10992422,10992423,10992424,10992425,10992426,8552722,10992484,6677589,6677590,3654786,10122149,10122336,8854025,9190214,10119735,9188052,9212407,9212461,10613562,9189079,10610954,8849275,9185518,9185678,9185696,8849681,9186100,8849998,8849999,9186175,9186176,9186323,9186742,9913434,8848580,10117004,10117005,10117342,10117347,10117349,8854211,8854562,9198838,9174888,10469771,6667328,10468073,10468156,9175825,10124141,8847944,10628361,10628383,10894089,10904841,10904885,10170901,10172114,10172115,10172116,10172117,10172119,10172120,10172122,10172363,10906651,10907065,10907193,10608634,10568919,10575624,10591885,10521273,10521274,10521275,10521276,10521277,10521278,10521279,10521280,10531469,10529694,10531852,10529984,10529990,10532137,10532138,10532139,10522232,10522233,10522234,10536291,10536292,10536293,10536294,10536295,10522457,10522458,10536528,10536529,10522601,10522602,10532631,10532632,10530692,10530693,10530858,10530859,10530860,10530861,10530862,10530863,10530864,10532893,10532894,10532895,10532896,10530934,10530935,10530936,10532940,10532941,10532942,10526958,10532969,10532970,10423096,10425189,10425190,10425191,10425192,10425193,10425194,10425195,10425196,10425197,10425198,10425199,10425200,10425201,10425202,10425203,10425204,10425205,10425206,10425207,10425208,10425209,10425210,10425211) 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>