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(10862880,8629929,8629930,10860780,10860814,8630174,10861074,10861112,10861122,10861131,10861137,10861139,10861147,10861148,7201206,7201207,7201208,7201209,7201210,7201211,7201212,7201311,7201312,7201367,10866478,10866479,10866480,10866481,10866482,10866483,10866484,10866485,10866486,10866487,7201625,10858835,10858837,8628229,8628230,7201905,7201906,7201975,7201977,10859176,10859182,8628626,8628627,10859287,10859292,8628720,7202683,7202684,7202685,7202686,7202687,7202688,7202689,7202690,7202691,7202692,7202693,7202694,7202695,7202696,7202697,7202698,10859794,7202762,8629333,10860141,10857225,8626828,7200501,10865732,7200920,10866175,10855531,10855551,10855554,10855556,10855577,10855578,10855895,10855902,10855905,10855907,10855910,10855912,10855914,10855915,10855918,10855921,10855924,10855926,10855928,10855930,10855933,10855936,10855939,10855941,10855942,10855944,10855946,10855948,10855950,10855953,10855955,10855957,10856002,10856006,10856007,10856008,10856014,10856017,7199393,7199412,10856553,7199546,7199547,7199548,7199549,8626365,3923414,10854328,10854329,10854330,10854331,10854332,10854333,10854334,10854364,8624403,8624404,8624405,8624406,8624407,8624408,10617124,8905768,10850462,10615334,8633127,8633184,8633265,8633282,10616092,8634171,8634175,8634176,8634177,8634178,8634182,8634183,8634184,8634185,8634186,8634187,8634188,8634191,8634192,8634193,8634194,8634195,8634196,8634197,10616913,10611048,10611167,10611179,10614485,10614488,10614489,10614492,10612069,10612248,10609313,10612328,10612757,10612914,10610486,10613882,7055548,6673689,10117729,6673766,6674152,9913190,9913238,10419437,10419438,10419439,10416446,10117438,10888926,10888929,10884368,10884369,10889851,10890096,10905113,10887996,10886240,10886303,10604067,10604405,10507718,10507719,10507720,10413376,10413378,10411580,10413660,10413662,10410065,10410066,10410067,10410068,10410069,10410070,10410071,10414526,10410694,10410696,10410715,10410718,10410720,10410741,10410742,10411037,10411040,10411041,10411043,10411045,10411046,10411050,10411051,10411053,10411058,10411059,10411061,10411063,10411068,10411069,10411071,10411073,10411076,10411077,10411081,10411082,10411085,10411088,10411091,10411092,10411095,10411098,10411102,10411103,10411107,10411108,10411110,10415118,10415127,10415129,10415135,10415141,10415143,10411146,10415150,10411150,10415151,10411154,10411159,10411166,10411171,10411173) 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>