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(8630918,8631097,11041361,11041362,11041363,10862071,10862073,8631566,10849483,10849489,8631857,8631858,8632271,8632278,8632319,8632320,8632321,8632322,8632324,8632327,8632328,8632333,8632334,8632435,8632436,8632441,8632442,8632443,8632444,8632449,8632450,8632451,8632455,8632456,8632457,8632458,8632459,8632460,8632461,8632464,8632575,8629702,8629877,8630447,8630448,8630449,8630450,8630451,8630452,8630453,7201222,8627636,8627637,8627638,8627639,8627641,8627642,8627643,8627644,8627645,8627646,8627647,8627648,8627649,8627650,8627652,8627653,8627654,8627655,8627656,7201319,8627953,8627954,8627955,8627956,8627957,8627958,8627960,8627961,8627962,8627963,8627964,8627966,8627967,8627968,8627969,8627970,8627971,8627973,8627974,8627975,8627976,8627978,8627979,8627980,8627981,8628303,8628394,8628404,8628493,7202140,8628627,7202313,7202314,7202315,7202316,7202317,7202318,7202319,8628724,8628725,7202346,7202381,8628818,8628819,8628820,8628821,8628822,8628823,8628824,8628825,7202425,8628826,8628827,8628828,8628829,8628830,7202430,8628831,8628832,8628833,8628834,8628835,8628838,8628839,8628842,8628843,8629252,8629261,3227184,10857231,10857234,10857235,7200637,10857890,8627382,7198682,8625140,8625507,8625628,8625629,8625630,8625634,8625635,8625636,8625637,8625638,8625639,8625640,8625641,8625642,8625656,8625657,8625658,8625659,8625660,8625661,8625662,8625663,8625664,8625665,8625666,8625667,8625668,8625669,8625670,8625671,8625672,8625673,8625674,8625675,8625676,8625690,8625691,8625696,8625697,8625698,8625699,8625700,8625701,8625738,8625739,8625740,8625741,8625742,8625743,8625763,8625764,8625765,8625766,8625767,8625768,8625769,8625773,8626189,8626292,8626296,8626297,8626299,3923593,10838816,10838919,10838923,7197706,7197713,7197716,7197720,7197805,8624496,8624505,10619895,10619896,8624520,8624523,8634623,8634633,8634675,8634676,8634776,8634777,8634779,8634781,8634783,8634786,8634787,8634790,8634791,8634792,8634892,10852578,10852584,8632637,8632638,8632639,10615075,8632703,8632704,8632798,8632837,8632844,8632910,8632954,8632955,8632956,8632968,8632969,8632970,8632978,8632979,8632980,8632981,8632982,8632983,8632985,8632986,8632990,8632992,8632996,8632997,8632998,8632999,8633000,8633001,8633003,8633004,8633007,8633008,8633011,10850654,8633012,8633066,8633068,10848177,8633073,8633074,8633079,8633080,8633083,8633084,8633087,8633088,8633089,8633090,10925981,8633093,8633094,10850739,10850744,8633206,8633208,8633213,8633217,8633218,8633285,8633548,8634236,8634283,10852121,10852122,8634572,10565155,10611376,10611428,10611649,10611659,10613017,10613057,10613058,10613066,10613192,10613215,9204758,9204759,10613736,10515422,10124570,9176405,6672867,6672869,6672881,6672882,6672883,6672885,6672886,6672887,6672888,6672893,10415795,10415797,8568918,8568919,8568920,8568921,8568922,9206745,9206746,9207297,8563359,8563360,10155731,10630189,10631241,10631242,10631245,10581960,10579462,10579878,10579879,10507876,10508105,10407923,10407992,10408002,10412023,10412026,10497395,10408769,10408770,10409036,10409040,10409042,10407073,10407074,10407075) 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>