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(8838457,10870342,3228559,3228566,8621166,11041711,7066113,7066228,10951186,8067702,8067716,10847586,4969259,8573242,11039932,11039934,11039943,11039944,10939168,11001319,10870061,8620642,10931473,7072490,10931941,10858958,10843432,10843433,8559815,10999676,10932455,7065357,10859708,10859713,8836923,10859725,10859734,10859747,10859748,10933036,10933045,10933066,11036651,11036687,11036820,11010855,8910258,10984935,8834756,8627062,8627063,10943085,11037179,8910839,10985505,10956870,7198433,10956873,10956904,7069303,10863838,10996360,10957407,8072759,11009722,11009730,8072805,8072821,8072837,8072857,8072877,8072893,8072913,8072928,8072946,8072962,8072978,7199517,7199518,8565058,11048362,8557454,8557455,8557456,11010284,10942412,8557773,3923502,11045805,11045806,8613011,8906933,3234811,10995117,7197751,10925201,10925203,10925209,10925210,10925217,10925221,10925225,10925241,10925246,10925251,10925261,10925262,10925264,10925265,10925266,10925273,4938463,10925277,10925278,10925279,10925282,10925283,10925289,10925298,10855051,10925302,10925309,4938505,10925321,10925324,10925327,10925328,4938517,10925332,10925333,10925334,10925336,10925340,4938529,4938541,10925354,10925358,10925362,4938553,4938565,4938577,7198102,4938589,4938601,4938613,4938625,10922478,10922479,10922480,10622145,10622198,8905405,8905406,10967304,8578922,8578923,8578924,8578925,8578926,8578944,8578945,10837525,10837526,8578956,8578957,8578958,8578963,8578966,8578968,8578970,8578971,8578976,8578977,10615282,10615283,8570385,9217077,8610730,10616092,3231695,11044105,7154994,8577893,8611691,6677522,9165389,10122335,10560007,10614906,8864795,10611980,8851671,9220057,9220211,9188731,8853076,8853077,8853078,10117625,7055652,9169723,4974830,990572,9162255,990809,2809543,9913277,10417288,9168417,10427913,9184539,10116745,6680894,4973580,6681168,10125219,6673499,3962799,3962800,9174519,10465132,9206649,9206655,9206657,9206661,9916977,10469516,10465721,10465722,6473467,9183362,10468122,8551009,8551021,9168032,9168033,8551244,10468844,10468845,10184574,10184585,10184586,10184618,10878820,10170104,10170107,10889265,10175360,10175366,10884769,10899782,10879853,10879854,10160953,10879977,10161020,10900192,10877856,10908267,10174300,10176526,10186903,10186965,10172200,10172897,10886922,10950167,10950168,10646931,10646932,10605931,10606785,10606786,10606787,10607443,10540073,10413465,10473196,10479526,10496568,10496569,10496577,10496583,10477598,10473677,10473678,10473679,10473680,10414042,10414136,10414137,10414144,10414160,10414170,10414182,10410264,10474266,10474267,10474268,10474269,10474270,10474271,10474272,10474305,10474306,10474316,10474325,10474326,10474327,10474328,10474329,10474331,10474332,10474333,10474334,10474335,10474336,10474337,10474338,10474339,10474340,10474341,10474342,10474343,10474344,10474345,10474346,10474347,10474420,10474421,10474422,10474423,10474424,10474425,10474426,10474427,10474428,10474429,10474486,10474487,10474488,10474489,10474490,10474491,10474492,10474519,10474520,10474521,10474522,10474523,10474546,10474547,10474548,10474549,10474550,10474551,10474567,10485568,10474616,10474617,10472664) 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>