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(8574198,7076042,10870630,4970738,3229017,3229018,10862070,10862071,9215620,9215626,9215627,10868261,9215628,10868262,9215629,9215630,9215631,9215632,9215638,9215660,9215667,9215681,9215687,9215695,8583523,9215716,9215752,10950726,10950747,10950748,9215782,9215791,9215802,9215809,9215816,9215825,8631978,8632287,8632288,8632289,8632290,8629740,8629744,8629751,8629986,8629991,10860729,10860730,10860731,8630118,10860789,10860953,10860966,10870113,10870114,10447777,10447783,10447784,10447785,8627657,8627680,8627681,8627682,8627683,8627684,8627685,8627686,8627688,8627689,8627690,8627691,8627692,8627693,10842998,10973002,10866615,8628043,8628072,8628073,8628084,8595092,8595093,8595175,10866938,10866939,8628321,8836210,10843581,10999973,10859629,5654778,8629179,8629180,8629182,8629183,8629184,8629186,8629187,8629244,8629310,8629311,8629312,8629451,3237394,8626675,8910445,8970239,10995710,10995712,10995713,10995714,10995715,10995717,10995720,8624863,10944725,10944728,10944729,10944730,10944732,10944735,10944736,8908470,7198723,7198743,7198767,10996281,10996307,10996417,10996418,10996419,10996420,10941688,10941689,8625959,8625960,8625961,7070729,10857121,7196507,7196511,7196515,7196531,11046633,11046634,11046635,10838834,3234547,3235067,10995361,10995368,10995369,10995381,8624504,8624522,10995579,10995580,8541473,10852258,10852259,8541653,8541654,7156032,8905663,10993372,10993373,10993374,8905778,8905779,8905780,10951612,10951674,10615222,8633207,8633218,8633344,10930728,10991459,10991469,10991470,10991498,10991932,8541096,8634273,10992320,8634545,10613969,10613989,9189358,8567863,8567865,10614263,10614502,10562851,10611830,10611995,10611996,10611997,10612003,10612004,10612059,9914154,9914168,8851889,9196253,9188287,9188367,9188368,9188464,10613421,10613434,10613524,10613527,10613698,10613699,6677330,10613816,10613817,10613818,10613819,10613820,10613821,10613822,10613845,8567686,8567687,10613858,8567705,8567765,8567768,8567774,10613954,10117516,10117517,9169472,6673727,9185578,9185579,9185809,8849752,9186051,9186054,8850095,10516136,10516138,10516139,6674592,9186783,8552207,4973253,4973254,4973255,10419496,10415794,10415795,10419821,10419822,9169058,9169074,9169075,9169232,10469337,10469374,10463588,10463594,10463595,10463596,3963599,3963600,10903646,10903834,10893983,10893984,10893985,10893986,10893987,10893988,10904089,10904090,10885362,10627145,7001102,10908260,10630048,10630069,10630071,10630072,10630073,10630074,10630075,10630076,10630077,10630079,10630080,10630081,10630082,10630083,10630084,10630085,10630086,10630087,10630090,10630091,10630092,10630093,10630094,10630095,10630096,10630097,10630098,10630099,10905822,10166962,10166963,10886062,10162091,10886092,10886093,10886094,10886095,10886096,10886097,10886136,10886163,10886209,10886210,10886227,10886398,10886401,10886402,10886403,10172421,10886458,10886517,10626129,10886657,10886658,10626239,10886754,10886755,10886756,10886757,10886804,10886817,10886863,10167969,10168028,10168050,10887190,10602179,10598866,10647558,10579479,10582562,10582564,10591924,10591925,10591926,10591927,10545356,10545357,10545358,10545371,10545372,10545373,10547872,10548024,10548307,10547080,10547081,10547082,10547083,10420858,10420859,10420860,10422001,10507938,10484506,10484507,10484508,10484509,10484513,10484519,10484520,10411955,10414062,10414686,10414962,10414963,10414964,10414965) 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>