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(3228955,10862001,7066098,10849456,10849457,10849458,10849459,7066227,7066228,10849624,10862781,10862800,8067906,3227577,10930096,10930098,7201259,8595263,10859265,10859667,10859672,10859676,10859677,10857464,8834756,8626975,7200793,8910657,7200985,7200993,7200995,10864823,8834123,10865015,10853505,7196576,7196577,10838893,7197795,7197796,7197806,7197807,3234982,10616967,10616968,10616969,10617009,10617110,10617182,10617189,10617190,10617191,10617192,10852618,10993459,10614966,10425356,10425358,10615130,10850521,10850535,10850608,10850609,10850610,10850611,10615374,10615375,10615376,10615378,10615409,10620750,10851049,10616092,10426472,3231591,10616201,10616211,10616216,10616217,10616218,10616219,10616223,10616224,10616227,8904326,8904489,10611065,10614067,10614068,10611069,10611070,10611071,10611072,10611073,10611074,10611077,10611078,10611138,10611139,8853389,6669820,10611443,10611766,10611880,10611882,10611883,10611884,10611885,10611886,10611887,10611888,10611889,10611890,6666255,10612179,10609349,10612381,8851648,8851651,8851652,8851772,8851978,10613009,10613010,10610046,8852327,8852338,8852386,8852575,8852577,8852578,8852581,8852591,8852728,10613785,10613786,10117531,9177366,8849324,8849382,8849383,8849384,8849385,8849408,8849410,8849411,8849425,8849428,10117805,9169723,9169870,6674201,6674202,6674203,10118302,10118314,8850042,8850043,8850044,8850045,10118606,10118640,8850645,8850682,8850683,8850684,8850688,8850689,8850690,8850754,8850755,8850756,8850760,8850762,8850765,8850768,8850818,8850831,9910575,9910577,10416345,10415782,8848708,8848711,6673148,6673190,9168985,6673254,6673288,9169185,10418147,10471129,8549810,10463360,976363,10464205,9167669,10462469,8848064,8848065,8848066,9168264,10883564,10883585,10628312,10889265,10889316,10899499,10889875,10879924,10626986,7000858,10883381,10625239,10625240,10625241,10881538,10876815,10882312,10602120,10602135,10602167,10602351,10602352,10602686,10602693,10647294,10647661,10647662,10603620,10603621,10603778,10603779,10603780,10603850,10603851,10603852,10603853,10607010,10607011,10604414,10604415,10604536,10604555,10604704,10407840,10407941,10414097,10414101,10414106,10414107,10408165,10407184,10407185) 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>