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(8838621,10861428,10861429,3228953,10871153,9215704,9215705,9215706,9215707,9215708,9215709,10849481,10849482,10849488,9215858,9215874,9215875,8631926,8631975,8631978,8632061,8632063,8632089,8632197,10862865,8632285,8632286,8632441,8632442,8632443,8632444,8632455,8632456,8632457,8629475,8629580,8629702,8629877,8630149,8630152,8630153,8620482,8630447,8630448,8630449,8630450,8630451,8630452,8630453,8630454,8630455,10866362,8911225,10866535,7201844,10866937,10866944,10866945,10866946,10866947,10866963,10866966,10843447,8628493,10104033,7202381,8628818,8628819,8628820,8628821,8628822,8628823,8628824,8628825,8628826,8628827,8628828,8628829,8628830,8628831,8628832,8628833,8628834,8628835,5654554,10932821,10932823,7202735,8596166,8629252,11036640,7200911,7200913,8624496,8624505,8624520,8624541,3925520,10996193,10996194,10996220,10996262,10996285,10996291,10996292,10996295,10996299,8908753,8625428,10856099,8625628,8625629,8625630,3926474,8625932,8625933,8625934,8625935,3236837,8626124,8565230,8626181,8626183,8626292,8626296,8626297,8626299,8612892,10623507,7196891,8554783,8554785,10838816,7197706,7197713,7197716,3234905,7197813,7197819,10619874,10619895,10619896,10852128,8634572,8634776,8634777,8634779,8634781,8634783,8634786,8634787,8634790,8634791,8634792,8905221,10617339,8905262,10852593,10622533,8632622,8632637,8632638,8632639,10615229,8632774,8632802,10850752,10850801,8633206,8633218,10952324,10952325,8540610,10922259,10922260,8634296,8634297,8634298,8634299,7059722,7059723,6669828,10611376,10611431,10611459,10611486,10611615,10714444,10119687,9171915,9211927,7058687,10613736,10117664,10515422,10117806,10117807,10125856,9912021,6674327,9913318,9913354,10415367,10419370,4973308,6672893,9168799,6673021,10419819,10419820,10419828,10419829,10419830,10419831,10419847,10419850,9911274,7055447,9169289,9169290,9916954,9916958,8549957,6473427,6473428,8550994,6474302,10883570,10883571,10903840,10884078,10890085,10890131,10176229,10627319,10184016,10627580,10184405,10184406,10184409,10630053,10630189,10887190,10626711,10950148,10580263,10580264,10598802,10603617,10522839,10422686,10422687,10508105,10411283,10490317,10490334,10490335,10490336,10490337,10490338,10490339,10490340,10490341,10490342,10490343,10490344,10490345,10408005,10408033,10473693,10408776,10487515,10409048,10407071) 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>