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(8594724,8594725,8594726,7201603,7200987,10617118,10850225,10850226,10850227,10850228,10850229,10850230,10850231,10850232,10850233,10850234,10850235,10850236,10850237,10850238,10850239,10850240,10850241,10850242,10850243,10850244,10850245,10850246,10850247,10850248,10850249,10850250,10850251,10850252,10850253,10850254,10850255,10850256,10850257,10850258,10850259,10850260,10850261,10850262,10850263,10850264,10850265,10850266,10850267,10850268,10850269,10850270,10850271,10850272,10850273,10850274,10850275,10850276,10850277,10850278,10850279,10850280,10850281,10850282,10850283,10850284,10850285,10850286,10850287,10850288,10850289,10850290,10850291,10850292,10850293,10850294,10850295,10850296,10850297,10850298,10850299,10850300,10850301,10850302,10850303,10850304,10850305,10850306,10850307,10850308,10850309,10850310,10850311,10850312,10850313,10850314,10850315,10850316,10850317,10850318,10850319,10850320,10850321,10850322,10850323,10850324,10850325,10850326,10850327,10850328,10850329,10850330,10850331,10850332,10850333,10850334,10850335,10850336,10850337,10850338,10850339,10850340,10850341,10850342,10850343,10850344,10850345,10850346,10850347,10850348,10850349,10850350,10850351,10850352,10850353,10850354,10850355,10850356,10850357,10850358,10850359,10850360,10850361,10850362,10850363,10850364,10850365,10614448,8849365,9169765,9912779,9910791,9910792,9161147,6670687,10115982,10115983,10115984,10115985,10115986,10115987,10115988,10115989,10115990,10115991,10115992,10115993,10876480,10876481,10407586,10407587,10407588,10407589,10407590,10407591,10407592,10407593,10407594,10407595,10407596,10407597,10407598,10407599,10407600,10407601,10407602,10407603,10407604,10407605,10407606,10407607,10407608,10407609,10407610,10407611,10407612,10407613,10407614,10407615,10407616,10407617,10407618,10407619,10407620,10407621,10407622,10407623,10407624,10407625,10407626,10407627,10407628,10407629,10407630,10407631,10407632,10407633,10407634,10407635,10407636,10407637,10407638,10407639,10407640,10407641,10407642,10407643,10407644,10407645,10407646,10407647,10407648,10407649,10407650,10407651,10407652,10407653,10407654,10407655,10407656,10407657,10407658,10407659,10407660,10407661,10407662,10407663,10407664,10407665,10407666,10407667,10407668,10407669,10407670,10407671,10407672,10407673,10407674,10407675,10407676,10407677,10407678,10407679,10407680,10407681,10407682,10407683,10407684,10407685,10407686,10407687,10407688,10407689,10407690,10407691,10407692,10407693,10407694,10407695,10407696,10407697,10407698,10407699,10407700,10407701,10407702,10407703,10407704,10407705,10407706,10407707,10407708,10407709,10407710,10407711,10407712,10407713,10407714,10407715,10407716,10407717,10407718,10407719,10407720,10407721,10407722,10407723,10407724,10407725,10407726,10407727,10407728,10407729,10407730,10407731,10407732,10407733) 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>