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(8595109,8595110,8595111,8595112,8595113,8595114,8595115,8595116,8595117,7201902,7202280,7202438,7202681,7202682,7066174,8910671,8910676,8910677,10101468,8905738,8905763,8905968,3923522,8860412,8860413,8860414,8860415,8633376,10426387,10426388,8070779,8634376,8634377,8634378,8634379,10863217,10863218,10863219,10863220,10863221,10863222,10863223,10863224,10863225,10863226,10863227,10863228,10863229,10863230,10863231,10863232,10863233,10863234,10863235,10863236,10863237,10863250,10863271,10860654,10860655,10860657,10615289,10615290,10615291,10615292,10615293,10615294,10431642,10431686,10612084,10612085,10612086,10612259,10612883,7058980,10939404,10939425,10117526,10117527,9169461,10117673,10117674,10117675,10117676,10117677,10117678,10117774,10118051,10118347,10118348,10118349,9912411,9912628,9913166,8542437,9168390,9168391,10427896,10416761,10416762,10416763,10416764,10416765,10416766,10416767,10416768,10416769,10416770,6673062,10416771,10428235,10416772,10416780,10416782,10416798,6673175,6673176,6673177,6673178,6673179,6673180,6673181,6673182,6673183,6673184,6673185,6673186,6673187,6673188,6673189,6673190,6673191,6673192,6673193,6673194,6673195,6673196,6673197,6673198,6673199,6673200,6673201,6673202,6673203,6673204,6673205,6673206,6673207,6673208,6673209,6673210,6673211,6673212,6673213,6673214,6673215,6673216,6673217,6673218,6673219,6673220,6673221,6673222,6673223,6673224,6673225,6673226,6673227,6673228,6673229,6673230,6673231,6673232,6673233,6673234,6673235,6673236,6673237,6673238,6673239,6673240,6673241,6673242,6673243,6673244,6673245,6673246,6673247,6673248,6673249,6673250,6673251,6673252,6673253,6673254,6673255,6673256,6673257,6673258,6673259,6673260,6673261,6673262,6673263,6673264,6673265,6673266,6673267,6673268,6673269,6673270,6673271,6673272,6673273,6673274,6673275,6673276,6673277,6673278,6673279,6673280,6673281,6673282,6673283,6673284,6673285,6673286,6673287,6673288,6673289,6673290,6673291,6673292,6673293,6673294,6673295,6673296,6673297,6673298,6673299,6673300,6673301,6673302,6673303,6673304,6673305,6673306,6673307,6673308,6673309,6673310,6673311,6673312,6673313,6673314,6673315,10469283,10469286,8550159,8550160,8550161,8550206,976473,976479,976480,976481,976482,976483,9168091,9168183,9168184,10427634,10884001,10884629,10170710,10884787,10884788,10884789,10884790,10884791,10884792,10884793,10885311,10627113,10627114,10627115,10183909,10183942,10888335,10888336,10888337,10888338,10888339,10888340,10885969,10887192,10887193,10887194,10887195,10887196,10887197,10605560,10605561,10605567,10647479,10601924,10508346,10507708,10507709,10507710,10507711,10507712,10507713,10507714,10507715,10507716,10507717,10414896,10414900,10414901,10414947) 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>