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(10861765,8631496,8631506,8631624,8631625,8631662,8631719,8631721,8631725,8631728,8067396,8632528,10860243,10860245,8629718,8629731,8629732,8629733,8629734,8629735,8629736,8629765,10860453,8629811,10860478,10860518,8629957,9214418,8630437,8630438,8630439,8630440,8630441,8630483,8627795,8627796,8627797,8627801,8627802,10866548,10866610,10866612,8595078,8065807,8628627,8628655,8628656,8628657,8628658,8628659,8628660,8628670,8628671,8628720,8628731,8628732,8628736,8628737,8628738,8628739,8628741,8628742,8628743,8628744,8628745,8628746,8628747,8628748,8628749,8628750,8628795,8628796,8629244,8629364,8629365,8629366,8629369,8629370,8629371,8629372,8629373,8629374,8629376,8629377,8629467,8626816,8626817,10857503,7200506,10857555,10857556,10857559,8625060,10863911,10863973,8625531,8625879,8625970,8625971,8625972,8625973,8626260,10857140,10857141,10857142,10857143,10857145,8626514,8626515,10865158,10865159,7197941,8624376,8624380,10855091,8634658,8634659,8634660,8634661,11044791,11044795,11044805,11044806,8634966,8634967,8634968,8634969,8634970,8634971,8634972,8634973,8634974,8634975,8634976,8634977,8634978,8634979,8634980,8634981,8634982,8634983,8634984,8634985,8634986,8634987,8634988,8634989,8634990,8634991,8634992,8634993,8634994,8634995,8905711,10425582,10848006,3581897,3581898,3581899,3581900,3581901,3581903,8633344,10615780,8634568,8634570,10613506,10613513,10613514,10613545,10610709,10610874,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517222,10517223,10517224,7056039,9912193,9912571,10419469,10419493,10415614,10175153,10175160,10890006,10171166,10162864,10580128,10580129,10508256,10414738,10414757,10414758) 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>