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(10861496,4970741,3229038,3229039,3229040,3229041,10862813,10862814,10862815,10862816,10862817,10862818,10862819,10862820,8067938,8067939,8630437,8630438,8630439,8630440,8630441,10866561,7201605,7201607,10866932,10866933,10866934,10866935,10866936,10866937,10866938,10866939,10866940,10866941,10866942,10866943,7201901,10866944,10866945,10866946,10866947,10866948,10866949,10866950,10866951,10866952,10866953,10866954,10866955,10866956,10866957,10866958,10866959,10866960,10866961,10866962,10866963,10866964,10866965,10866966,8628997,8628998,8628999,8629000,8629001,8629002,10855738,7198706,7198741,7198978,10101531,8907806,8907856,8907909,8907923,10620487,10620488,10620491,10615718,10426435,10426437,10426438,10616576,10616641,10616642,10616643,10616644,10616645,10616866,10616913,10614048,10614050,10614282,10614555,10611802,10609239,10612286,10609770,10609824,8851995,10612907,10612912,10612914,10610098,10610271,10613349,10613453,10613562,7055498,9169708,9912944,10416375,10416376,10416377,10416378,10416379,10416380,10416381,10416382,10415397,10419470,10419813,10419814,10419815,10419816,10419817,10419818,10419819,10419820,10419821,10419822,10419823,10419824,10419825,10419826,10419827,10419828,10419829,10419830,10419831,10419832,10419833,10419834,10419835,10419836,10419837,10419838,10419839,10419840,10419841,9168920,10419842,10419843,10419844,10419845,10419846,10419847,10419848,10419849,10419850,10469247,10469248,9167297,9167298,9167775,9167776,9167777,9167778,9167779,9167780,10884479,10890725,10885857,10885858,10604430,10604529,10604531,10530689,10530690,10530691,10508261,10508575,10507590,10508617) 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>