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(10939605,10939606,10939608,10939613,10962670,10962671,10962672,10962673,10962674,8839144,7066003,10950935,4969818,4969819,4969820,4969821,10939213,10845522,10998509,7201124,7201125,7201126,7072083,8075298,8628305,8628308,10104020,8628646,8628647,8628649,8628659,8628737,8628738,8628741,10859569,8626523,8626527,10857229,8626816,8624502,8624506,8624525,8624526,10839726,8564380,8615598,8625436,8625531,8625532,7199530,7199536,10958288,10958289,11010437,8553809,10837619,7196308,7196324,10618363,8554689,8554713,8554726,8554728,8906853,3234314,8071148,3234991,8624336,10619897,8634608,10617148,10617149,10617150,10617151,10617152,8612005,10852759,3230362,8622791,3230387,8632629,8632797,10615533,9217148,9217149,9217158,3231408,8634009,10992397,8904785,9214164,6676048,10609848,10609850,9212424,9172499,9172500,9172508,9172509,10558450,10558451,10558592,10610501,10515267,10515268,10515269,10515270,10515271,9169752,10515750,10515751,10515752,10515753,10515754,10515755,10515756,10515757,10515758,10515759,10515760,10515761,10515762,10515763,10515764,8849783,10515787,10515788,10515789,10515790,10515791,10515792,10515869,10515870,10515871,10515872,10515873,10515874,10515875,10515876,10515877,10515878,10515879,10515880,10515881,10515882,10515883,10515884,10515885,10515886,10515887,10515888,10515889,10515890,10515891,10515892,10515893,10515894,10515903,10515904,10515905,10515906,10515959,9186148,10515964,10516030,10516031,10516032,10516033,10516034,10516035,10516036,10516037,10516038,10516039,10516040,10516041,10516042,10516043,10516044,10516045,10516046,10516047,10516048,10516049,10516050,10516051,10516052,10516053,10516054,10419391,10417639,9206689,10465736,9191246,6667740,6671975,10466589,10908619,10908620,10903677,10628791,10879866,10879867,10890024,10948009,10948010,10885338,10885339,7000883,10880510,10949888,10646340,10653404,10653405,10653406,10537351,10522238,10543038,10543039,10543044,10543045,10543046,10543047,10543048,10543049,10543050,10543051,10543052,10508616,10507968,10414007,10476154,10476155,10476156,10409139) 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>