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(10858812,5654600,7202669,7202670,8910469,8910470,8910471,10102857,7200988,10101205,10101282,8557335,10856749,10856750,10856775,10856776,10856777,10856778,10856781,10856961,10196392,3927262,3927263,3927264,3927265,3927266,3927267,10857171,3237338,8626971,8626990,3234863,10854976,10855273,10855277,3232891,3232892,3923241,3923414,10867284,7197569,9217085,9217095,10863806,9217216,10850869,10623310,10623399,8540528,10433600,8904421,8552913,10616967,10616968,10616969,10617009,10617010,9216058,10617035,10617101,10617103,10617110,10617111,10617112,3229965,3229966,10862875,10862876,10622199,8575806,10189384,10617448,10617509,8632630,10850519,10850520,10850521,10615065,10615138,10615246,10615317,10615371,10615372,10615373,10615374,10615375,10615376,10615378,10620487,10620488,10620491,10615499,10615881,10615883,10615884,10615885,10615886,10615887,3228910,3228955,3228987,3229183,3229184,10862131,10862148,10862149,10862150,10431581,9205387,9205390,10614094,10714175,10714261,10614486,9166043,10612039,10612050,10612088,10612179,10612267,8851647,8851648,8851770,8851924,8566612,8852150,9188452,9188453,8852338,8852375,8852386,10613365,10613366,8852728,8852838,8852855,8852881,8852882,10613768,10613769,10613773,10613785,10613786,9169442,9911669,9169482,10117691,10117750,8849380,8849381,8849382,10117758,10117759,8849406,10118246,8850040,8850184,9913278,9913279,9910575,10416441,10416442,9910817,10420111,6670759,976373,9167788,9168264,10628326,10879921,10887944,10627712,10627718,10888402,10883444,10161930,10161960,10162279,10881572,10876749,10626440,10882299,10631863,10611013,10611014,10611065,10611068,10611069,10611070,10611071,10611072,10611138,10611139,10611176,10611694,10611764,10611766,10611774,10611880,10611882,10611883,10611891,10611892,10611955,10609122,10609285,10609339,10609340,10609562,10603778,10603779,10603780,10609816,10603834,10603835,10603836,10603837,10609838,10603838,10603839,10603840,10603841,10603842,10603878,10609989,10609998,10604027,10610031,10610098,10610173,10610174,10610189,10610190,10610191,10604394,10604395,10604428,10604429,10604439,10604440,10604468,10610490,10604628,10604643,10604664,10604704,10550370,10550371,10498229,10505543,10505547,8562215,10413362,10411666,10411694,10411695,10411696,10411697,10411700,10411986,10410457,10410461,10714784,8563554) 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>