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(8574521,8631034,10848695,10848696,10848697,10848698,8631056,10940224,11041321,10861927,10861935,10861940,10976442,10976443,10976444,10976445,10976446,10976447,10976448,10976449,8583488,9215723,9215724,9215725,8631760,8631782,8631785,8631789,10950773,10868457,8632227,8622473,10990548,10990549,10990550,10990551,10990552,10990553,10990554,10860332,10860373,10860374,10860383,10844850,10869390,8561413,7201276,10866650,10866651,10999134,8628267,8628268,8628269,10960308,8628332,8628373,8628377,8065791,8628622,8628795,7202515,7065873,8629521,8626619,8626906,10858188,7201153,8624657,8624659,10855400,10855403,7198361,10855405,10855408,7198390,7198391,10855440,10855444,10855449,10855451,10855452,10855457,10855461,8624945,8624952,8624953,8624966,8624967,8624979,8625001,8625002,8625003,8625004,8625035,8625036,8625046,8625047,7198724,8908547,7198772,7199006,8625458,8625459,8625460,8625461,8626178,8626182,10857145,7196213,7196435,7196440,10853773,10994229,10994230,7196951,7196952,10623733,10623734,10838523,10838549,3924302,10838977,7197708,7197711,7197800,7197801,7197810,8624385,10855122,8624502,8624564,8624575,8611921,10622408,11045212,11045213,11045214,10954257,10990623,8632597,10425389,10425390,10990791,10990793,10990794,10990795,10990796,10990797,10620208,10425552,10425553,10425555,10850618,10850620,10425911,8633207,10991258,10991282,10991283,10991284,10991285,10991286,10991291,10991292,10991297,10991298,10426011,10620778,10426384,10426385,10616302,10616303,10616311,10616323,10616324,8634280,10992320,8634461,10852120,10565158,9165415,8853317,8853318,8853332,8853343,8853387,9173725,9173726,9173727,10611406,10611412,10611457,10559622,9173837,10122207,10611969,9211878,9212025,10120364,7058377,10612935,7058801,9188684,7018490,10613504,9197097,9197098,9169329,7055527,9177371,8849331,7015169,7015170,7015171,7015172,7015173,7015174,9193598,8850029,8850030,9912534,9912551,9912966,10518669,10518670,10518671,10518672,9913359,7057450,10427754,9192475,10419727,10415731,10419897,8848848,8848849,9169044,10419109,9193224,10467449,9199044,10463662,10463750,10463756,10463768,10465774,10465775,10465778,10465779,10465796,10465798,10465800,10463804,10465857,10465886,10465912,10463914,10463917,10463918,10464041,10466313,10466314,10466315,10466338,10466357,10466358,10466359,10466370,10466391,10466400,10462447,10462454,10462455,10462484,10462536,10462615,6668098,9168216,8848120,10883563,10889231,10885350,10895762,10895763,10895764,10895765,10886265,10886266,10886267,10886268,10886269,10886270,10167969,10892172,10892173,10892174,10892175,10892176,10892177,10892178,10892179,10887196,10602170,10590298,10650733,10650741,10606801,10648970,10549983,10534309,10421578,10483455,10410325,10410579,10410581,10410583,10410585,10410615,10410624,10410627,10410628,10410633,10410635,10493301,10412759,10408768,10406962,10406963,10406964,10406965,10478848) 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>