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(3898920,7201896,7201897,10873979,7068481,7068482,7068483,7068484,8572237,5654682,7202682,8837001,7074990,10858042,10858043,7067310,8911011,8911014,8617800,8594767,10840304,3926071,7198942,8615749,7064477,7064478,7064479,10196147,10841222,10841223,8909890,8909920,4968048,4968049,4968050,4968051,4968052,4968053,4968054,4968055,4968056,10261959,4968057,4968058,4968059,7073796,7073798,10839227,8907544,8614594,10100303,10100304,10837156,10837157,10837158,10837159,10837160,10837161,10944488,8554629,10245557,10245558,8554815,10245583,10867230,7070461,10232701,10850734,10850735,10850736,10850737,3231052,10848459,9217647,10255952,10255953,10255954,8904454,8904455,8904456,10256162,10852025,10269636,8584186,3230174,3230175,3230176,3230177,3230178,10254500,10189970,10189971,10189972,10189973,10189974,10189975,10189976,10189977,10189978,10189979,10189980,10189981,10189982,10189983,10189984,10189985,10189986,10189987,10189988,10189989,10189990,10189991,10189992,10189993,10189994,10189995,10189996,10189997,10845171,8570069,10845717,8570504,10930530,10930531,10620872,10620873,9215355,8583203,10862346,9915848,6665794,6665795,6665796,6665797,6665798,9190183,9190185,9174236,9174237,9174238,9174239,9174240,9174241,9174242,8861866,9187972,10938729,10938730,9177495,9177496,9177497,9177498,9177499,9177500,9177501,9177502,9177503,9161577,9161578,9161579,9161580,9161581,9161582,9161583,9161584,9161585,9161586,9161587,9161588,9161589,9201590,9201591,8849719,8849723,9202113,8850218,8850225,8850226,10512789,10512790,10512791,9171224,9200345,10427827,6680756,9200822,9200916,9200992,8064657,8064658,8064659,10420064,9201259,9916761,9916762,8854428,8854429,8854458,6678871,6678872,9206719,6679443,9208091,10655977,10655978,10655979,10179679,10918737,10179805,10179806,10179807,10914043,8069177,10904892,10904904,10919909,10877556,10173562,10877557,10173563,10173564,10173565,10632189,10171588,10915732,10915733,10915833,10915834,10896061,10896062,10896063,10896064,10896065,10896066,10896067,10896068,10896069,10896070,10172258,10172259,10172260,10177440,10177465,10876653,10876654,10178031,10877166,10877167,10877168,10877169,10877170,10877171,10877172,10877173,10877174,10912354,10652772,10652773,10652774,10652781,10602743,10602744,10602745,10653338,10644397,10572555,10572556,10572557,10587603,10587604,10587605,10587606,10587607,10650849,10604067,10604068,10604069,10604070,10604071,10604072,10604073,10604074,10604075,10604076,10604077,10604078,10651460,10651461,10651462,10649000,10551932,10551973,10551974,10551975,10551976,10551977,10551978,10551979,10551980,10551981,10534185,10520943,10520944,10416018,10478952,10478953,10496065,10407987,10407988,10407989,10407990,10463718,10463719,10463720,10463721,10463722,10463723,10463724,10463725,10463726,10463727,10487215,10487216,10412622,10412623,10412624) 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>