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(10845717,11015133,7068481,7068482,7068483,7068484,10873979,9215355,8583203,10862346,8584186,3230174,3230175,3230176,3230177,3230178,7074990,11013702,11013703,11013704,10938729,10938730,7067310,10845171,8911011,8911014,8617800,8594767,3898920,7064477,7064478,7064479,10960176,7201896,7201897,11012493,10867230,8572237,5654682,7202682,8837001,7073796,7073798,4968048,4968049,4968050,4968051,4968052,4968053,4968054,4968055,4968056,4968057,4968058,4968059,8064657,8064658,8064659,10858042,10858043,10944488,10100303,10100304,10840304,3926071,7198942,8615749,7070461,10841222,10841223,11023238,11023281,11023282,11023283,10997415,10997416,10997417,8909890,8909920,11006743,10918737,8554629,8554815,10994805,10919909,10839227,8907544,8614594,10954066,10954067,10954068,10954069,10954070,10954071,10954072,10954073,10954074,10954075,10954076,10954077,10954078,10954079,10954080,10954081,10954082,10954083,10954084,10954085,10954086,10954087,10837156,10954088,10837157,10954089,10837158,10954090,10954091,10837159,10837160,10954092,10954093,10837161,11006219,11006220,11006245,11032456,11016712,11016713,11016714,8570069,10915732,10915733,11016966,11016967,10915833,10915834,10850734,10850735,10850736,10850737,8570504,10930530,10930531,3231052,10848459,10620872,10620873,9217647,8904454,8904455,8904456,10852025,9915848,6665794,6665795,6665796,6665797,6665798,9190183,9190185,9174236,9174237,9174238,9174239,9174240,9174241,9174242,8861866,9187972,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,10416018,10420064,9201259,9916761,9916762,8854428,8854429,8854458,6678871,6678872,9206719,10463718,10463719,10463720,10463721,10463722,10463723,10463724,10463725,10463726,10463727,6679443,9208091,10946459,10946460,10946461,10179679,10179805,10179806,10179807,10914043,8069177,10904892,10904904,10173562,10173563,10173564,10173565,10877556,10877557,10632189,10171588,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,10478952,10478953,10496065,10407987,10407988,10407989,10407990,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>