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,9215355,8583203,3229162,3229169,4971026,8621784,3230174,3230175,3230176,3230177,3230178,10961626,3227408,11013702,11013703,11013704,10938730,7067310,11040150,8630168,7075781,7075801,8617800,7201226,7201231,10858274,7201234,8617870,8617871,8594767,10103380,3898920,7064479,8595199,11012493,10867230,10932291,8572237,10867489,5654682,7202682,8596235,4968048,4968049,4968050,4968051,4968052,4968053,4968054,4968055,4968057,4968058,4968059,3927526,10997874,8064657,8064658,8064659,10858042,10858043,3238198,10944488,10100303,10100304,10840304,7199202,7070461,10841222,10841223,11023238,11023281,11023283,10997415,8909920,8909921,11006743,10618086,10854225,3234382,3234384,10994805,10994821,10994822,8555173,10919909,10839227,8907544,7158086,8541479,11005989,11005996,10954066,10954067,10954068,10954069,10954070,10954071,10954072,10954073,10954074,10954075,10954076,10954077,10954078,10954079,10954080,10837148,10837149,10954081,10954082,10837150,10837151,10954083,10954084,10837152,10837153,10837156,10954088,10954089,10837157,10837158,10954090,10837159,10837160,10954093,10837161,11006219,11006220,11006245,11032456,8579100,11016712,11016713,11016714,10915732,10915733,11016966,11016967,3230702,10915833,10915834,10951984,10951985,10850734,10850735,10850737,8570504,8633189,10952179,10930530,10930531,3231052,10620872,11004532,11004533,11004534,11043666,11043667,8904454,8904455,7154969,8611318,10917150,10917151,6677636,9189434,10565335,10565336,10565337,9915848,6665794,6665795,6665796,10565614,10565615,10565616,10565617,10565618,10565619,10565620,10565621,10565622,10565623,10565624,9174236,9174239,9174241,9171338,8861866,10609691,10609692,10609693,10609694,10609695,10612890,8566802,9180470,10120704,9915376,9169435,9177495,9177496,9177497,9177500,9161577,9161578,9161579,9161580,9161581,9161582,9161584,9161585,9161587,9161589,9201591,9202113,9210319,9210320,7024289,10512789,10512790,10512791,10512822,10512823,10512824,10512825,10512826,10512827,10512828,10512829,9171224,9913453,9200345,9910572,10427827,7022159,6680767,10428019,9200992,10420064,9201259,9916761,9916762,9916763,9916764,6678871,6678872,9206719,10467555,9917255,10463718,10463719,10463720,10463721,10463723,10463725,10463726,10463727,6679443,9199536,976375,9167871,10946459,10946460,10946461,10179806,10179807,10179808,10914043,8069177,10909866,10173562,10173563,10173564,10173565,10882652,10882653,10882654,10632189,10912858,10176867,10890953,10890954,10896061,10896062,10896063,10896064,10896066,10896067,10896068,10896069,10896070,10172259,10172260,10876653,10876654,10187740,10172869,10911860,10187967,10187968,10178031,10178135,10877166,10877167,10877168,10877169,10877170,10877171,10877172,10877173,10912354,10589558,10652772,10652773,10602743,10602744,10602745,10647337,10653338,10644397,10604068,10604069,10604070,10604072,10604076,10604077,10604078,10604291,10649000,10551932,10551973,10551974,10551975,10551977,10544460,10520944,10420274,10420276,10421932,10480894,10480895,10480896,10472917,10472918,10472919,10478952,10478953,10481002,8562931,8562932,10407987,10407988,10407990,10486883,10486884,10486885,10481965,10481966,10487215,10487216,10412622,10412623,10412624,10489624,10489625,10489626,10489627,10489628,10489629) 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>