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(10849849,10865303,10923144,10923145,10923146,10923147,10923148,10923149,10923150,10923151,10923152,10923153,10923154,10923155,10923156,10923157,10923158,10923159,10923160,10923161,10923162,10923163,10923164,10923165,10923166,10923167,10923168,10923169,10923170,10923171,10923172,10923173,10923174,10923175,10923176,10923177,10923178,10923179,10923180,10923181,10923182,10923183,10923184,10923185,10923186,10923187,10923188,10923189,10923196,10923197,10923198,10923199,10923200,10923201,10923202,10923203,10923204,10923205,10923269,10923270,10923271,10923272,10923273,10923274,10923275,10923276,10923277,10923278,10923279,10923280,10923281,10923282,10923283,10923284,10923285,10923286,10923287,10923288,10923289,10923290,10923291,10923292,10923293,10923294,10923295,10923296,10923297,10923298,10923299,10923300,10923301,10923302,10923303,10923304,10923305,10923306,10923307,10923308,10923309,10923310,10923311,10923312,10923313,10923314,10923315,10923316,10923317,10923318,10923319,10923320,10923321,10923322,10923323,10923324,10923325,10923326,10923327,10923328,10923329,10923330,10923331,10923332,10923357,10923358,10923359,10923360,10923361,10923362,10923363,10923364,10923365,10923366,10923367,10923368,10923369,10923370,10923371,10923372,10923373,10923374,10923375,10923376,10923377,10923378,10923379,10923380,10923381,10923382,10923383,10923384,10923385,10615063,10612027,10558441,10610416,9170088,9170104,10418611,8550047,10890290,10887164,10887165,10590462,10590463,10590464,10590465,10590466,10590467,10590468,10590469,10590470,10590471,10590472,10590473,10590474,10590475,10590476,10590477,10590478,10521565,10521566,10407356,10407357) 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>