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(10962653,8574513,8574524,8632051,8632053,10862847,8632236,8632321,8632322,8632325,8632326,10850034,8630207,10861074,7201215,8627634,8627953,8627954,8627955,8627956,8627957,8627958,8627960,8627961,8627962,8627963,8627964,8627966,8627967,8627968,8627969,8627970,8627971,8627973,8627974,8627975,8627976,8627977,8627978,8627979,8627980,8627981,8628341,10843542,10843784,7202408,7202410,7202413,8629271,8629319,8629320,8629321,8629322,10958986,8627237,8627283,8627310,8627313,11011437,8627576,8627577,8627578,10839725,10839930,7198679,7198687,7198704,7198709,7198710,7198711,7198712,7198713,7198714,7198715,7198716,7198717,7198718,7198723,7198728,7198729,7198742,7198743,7198746,7198747,7198750,7198751,7198752,7198764,7198765,8625728,8625773,7199411,10840997,8626029,11036175,8626190,7196220,7196380,7196381,7196382,7196383,7196404,7196451,7196452,10618282,10618283,10618285,10618360,10618361,10618362,10618363,10618364,3923796,8554418,7196955,7196956,7196962,7196963,7196967,7196968,7196981,7197001,10838923,7197654,10855091,8624503,8624507,8612006,8612007,8612008,8612016,8612017,8612018,8612019,10852515,10852584,10852594,8612652,9216606,10951603,10425487,9216855,8632995,8632999,8633001,8633002,10425941,8633238,10426009,10426014,10426019,10615820,10426253,10426254,8540544,8540633,10565211,10565225,10565254,10565255,10565256,8567957,8567968,8567977,8567980,8567987,10559334,8853377,8853384,8853390,8853391,8853392,7057465,10612069,8851295,8851296,8851445,9914068,8852331,8567170,9915062,9173121,8567708,10117529,7055923,8848166,8848167,8848170,10416411,8848887,8848890,8568840,8568855,8568860,8568918,8568919,8568920,10463046,10463050,10463051,10463052,10463057,10463058,10463059,8549882,10463434,10463812,10463813,10463817,10463820,10465836,9191261,9191262,10465841,8847271,8847276,8847319,10466304,10466317,10466323,8847578,10466332,10466333,10466334,8847583,8847584,8847586,10466341,10466353,10466364,10466365,10466366,10466372,10466373,10466383,10462530,10462531,10628533,10628942,10899672,10899673,10890107,10627584,10168031,10168058,10949889,10882134,10882150,10907248,10907251,10907252,10907273,10907274,10907275,10631894,10631896,10631900,10631901,10631902,10631903,10631904,10631905,10631906,10631907,10631908,10631910,10631911,10631912,10631917,10608790,10608793,10608798,10608800,10608804,10608831,10608836,10608857,10604181,10545367,10545392,10525568,10527021,10547031,10407469,10408980,10409042,10409049) 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>