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(10861843,3229037,10861945,10950384,11041502,11041503,11041504,11041505,11041506,11041507,11041508,11041509,11041510,10950529,10849455,10862594,10862615,10862680,10849846,7201211,7201605,7201606,7201607,7201636,7201638,8595106,8595107,7201902,10867291,10867292,10867293,10867294,7202415,7202417,10104352,10859568,7202611,7202614,7202615,7202617,7202618,7202622,7202627,7202628,7202638,7202666,7202703,7202704,10865396,10865399,8626813,8626814,8626815,10857461,10857462,3927610,7200503,10102490,7200711,7200712,7200713,7200714,7200715,7200716,7200717,7200718,7200719,10863302,10863305,10863309,10863314,10863316,10863324,10863327,10863345,10863348,10863351,10863353,10863357,10863359,10863361,7198460,7198809,7198812,7199014,7199017,7199399,7199534,7199535,7199536,7199537,7199538,7199539,3923485,10618291,7197019,7197020,7197021,7197233,7197842,7197843,10854967,8624440,10616970,10616996,10617002,10617035,10617054,10617058,10617092,10852258,10852259,10852260,10852261,10852262,10852263,10852264,10852265,10852266,10852267,10852268,10852269,10852270,10852271,10852272,10617242,10617243,10617318,10852521,10852532,10617426,10852611,10853092,10853097,8632618,8632620,8632621,8632626,8632628,8632630,8632631,10615246,10615312,10615315,10615347,10850679,10850884,10952512,10991767,10991768,10991769,10991770,10991771,10991772,10991773,10991774,10616476,10616479,10616503,10616509,10616513,10616641,10616642,10616643,10616645,10616647,10616730,10616731,10616732,10616888,10610965,10611146,10611148,10611149,10611176,10614210,10614289,10614297,10611803,10611806,9182279,10612043,10612044,10612106,10612107,10612172,10612173,10609284,9211672,9211673,10612384,10609724,10609838,10612973,10610098,10613294,10613322,10613356,10613357,10613366,10613367,10613380,10613440,10613442,10613479,10610480,10610481,10610566,10610789,10118399,8850040,10416238,10416258,9168374,10416297,10415685,10418696,10418699,10415743,10416830,10416833,10416837,10416842,10416844,10416848,10416851,10416854,10416857,10416878,10416880,10416883,10416886,10416888,10416892,10416895,10416897,10416900,10420117,10420118,10420119,10420120,10420121,10471116,10471217,10471218,10471219,10471228,10471229,10471230,10471231,10471232,10471233,10471234,10471235,10471236,10471237,10471238,10471239,10471240,10471241,10471242,10471243,10471244,8550036,10466245,10466251,10470726,10470732,10883516,10883517,10628320,10884718,10884722,10889774,10883463,10161959,10162224,10162256,10162257,10162258,10162259,10162260,10162261,10162262,10162263,10162264,10626130,10187840,10882299,10586200,10586201,10586202,10586203,10586204,10586205,10586206,10586207,10586208,10586209,10586210,10586211,10586212,10586213,10586214,10586215,10586218,10583489,10583490,10583491,10583498,10583499,10583500,10583501,10583541,10583542,10583543,10583544,10583545,10583546,10583547,10583603,10583604,10583611,10583612,10583613,10583614,10583615,10583616,10583617,10583618,10583619,10583620,10583621,10583622,10583623,10583624,10583626,10583627,10583628,10583629,10583630,10583631,10647344,10590405,10590406,10647705,10647706,10647707,10604033,10604034,10508246,10507895,10407735,10414006,10410190,10408984,10408996) 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>