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(8630913,8630914,8630916,8630919,8631133,10871052,8631480,8631481,8631482,8631496,8631506,9215621,8631626,8631677,8631678,8631679,8575733,8575734,8575735,8629746,8629747,8629748,8629754,8629755,8629756,10844866,8629890,8629930,8629958,8630294,8630435,8627574,8627575,8627576,8627577,8627578,8627579,8627580,8627581,8627582,8627583,8627596,8627625,8627626,8627627,8627628,8627630,8627631,8627632,8627633,7201335,8628118,8628119,7201728,7201729,8628135,8628136,8628137,8628138,8628258,8628259,7201905,7201906,7201977,8628633,8628634,8628729,8628882,8628885,8628888,8628904,8629166,8629188,8629235,8629236,8629413,8629415,8626884,10958987,10958988,10958989,7200636,7200637,7200640,7200641,10985137,7200807,7200817,7200847,7200861,7200869,8627314,8627315,8627316,8627317,8627318,8627319,8627320,8627321,8627322,8624589,10839700,8624749,8624750,8624751,8624752,8624753,8624786,8624787,8624788,8624789,8624790,8624791,7198697,7198711,7198714,7198716,7198719,8625192,10101492,10101564,10101565,10101566,8626228,8626255,8626256,10853107,11045714,11045715,11045716,7196890,7196891,7196892,3234123,3924356,10838967,8624345,8624346,10619864,10619865,8624380,10619895,10619896,8634688,8634689,8634690,8634691,8634692,8634693,11044800,11044801,10617329,10617448,3232902,3232903,10954313,8632605,8632606,10615222,8632764,3230564,3230566,8632830,8632831,8632832,8632833,8632834,8632835,8632836,8632837,8632838,8632839,8632840,8632841,8632842,8632843,8632844,8632891,8632892,8632893,8633103,8633105,8633202,8633203,8633204,8633205,8633206,8633207,8633208,8633209,8633210,8633211,8633212,8633213,8633214,8633215,8633216,8633217,8633218,8633235,8633236,8633237,8633238,8633239,8633240,8633241,10848385,10848386,8633292,8633309,8633312,10848519,10616005,8633542,8540543,8540566,8540567,8540589,8540591,8634139,8634147,8634148,8634149,8634177,8634448,6666259,9211688,8851658,8566586,8566588,8566635,8566639,8566643,8566651,8566652,8566653,8566655,8566665,8566744,9212309,9212310,9212311,10609988,10610030,9169475,10515327,10517614,10517615,10517616,10517617,10517618,9169959,8565537,8565538,9913294,4973244,8855351,10893983,10884653,10626963,10632166,10627319,10161923,10161924,10161926,10161927,10161928,10626144,10583441,10590278,10566666,10566667,10566668,10537758,10537759,10522256,10522257,10522260,10550993,10508322,10508323,10508324,10508325,10508326,10422599,10508593,10508594,10508595,10508596,10508597,10508598,10506820,10506821,10506822,10506824,10507920,10507921,10487109,10487110,10487111,10487112) 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>