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(3228633,3228634,3228635,8569518,10944076,10944077,10944078,10944079,8575003,11041649,11041650,4969606,4969607,4969608,4969609,4969610,4969611,4969612,4969613,4969614,10939199,10939200,10447540,8065208,8065209,8065210,8065211,8065212,8065213,8065214,8065215,8065216,8065217,8065218,8065219,8065220,8065221,8594914,3899012,8628310,6665692,7065465,7065466,7065467,7065468,8573029,8573030,8573031,8834624,8834625,8834626,8910259,10959236,10959237,10959238,10959239,10959240,10959241,8970209,8564316,8564317,8564318,8564319,8564320,8564321,8564322,8072496,8072508,8072523,10101144,10101145,10101146,10101147,11048321,11049749,11049750,11049751,10837735,11045710,11045711,4938234,4938246,4938261,10839356,10852710,10852711,10852712,10852713,10852714,10852715,10852716,10852717,3922908,8553794,8553795,3923250,10460868,8610928,8610929,8610930,7155105,8904831,10614588,9166229,9166230,9166231,9166232,9166233,9166234,9166235,9166236,10612006,8862156,8862157,8862158,8862159,8862160,8862161,8862162,3653049,3653050,3653051,3653052,3653053,3653054,3653055,3653056,3653057,3653058,3653059,8566391,8566392,8566393,8551925,8551926,8551927,8551928,8551929,8551930,10116829,10116830,10116831,10116832,9911277,9911278,9911279,7055301,8549822,8549823,3963160,3963161,3963162,3963163,3963164,3963165,6671926,6671927,6671928,6671929,6671930,6671931,6671932,6671933,6671934,6671935,6671936,6671937,6671938,10466507,10466508,10466509,10466510,10466511,10466512,10466513,10466514,10466515,10466516,10466517,10466518,10908825,10159971,10159972,10159973,10159974,10159975,10159976,10159977,10159978,10159979,10159980,10159981,10159982,10159983,10159984,10159985,10159986,10159987,10159988,10159989,10159990,10159991,10159992,10159993,10159994,10159995,10159996,10159997,10159998,10159999,10160000,10160001,10947877,10947878,10947879,10947880,10947881,10947882,10947883,10947884,10947885,10947886,10880343,10880344,10880345,10880346,10880347,10880348,10880349,10880350,10880351,10880352,10880353,10880354,10880355,10880356,10880357,10880358,10880359,10880360,10880361,10880362,10880363,10880364,10880365,10880366,10880367,10880368,10880369,10880370,10880371,10880372,8593395,8593396,10646257,10646258,10646259,10646260,10646261,10646262,10646263,10646264,10646265,10646266,10646267,10646268,10646269,10646270,10607680,10607681,10607682,10607683,10607684,10607685,10607686,10607687,10607688,10607689,10607690,10607691,10607692,10545398,10545399,10545400,10714740,10409104,10409105,10409106,10409107,10409108,8562171) 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>