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(10873970,10873971,10872082,10874290,10872357,10872364,10872366,10872367,8619054,8619062,8836997,7075193,7067293,8558860,6000174,6000183,10840281,10840282,10840283,10840284,10840285,10840286,7072783,10261893,7073805,4938123,4938166,10867918,7071102,7071103,8624434,10283104,8612500,8072385,8072428,10853498,8554579,8554580,8073477,9217627,9217637,9217638,9217639,9217640,9217652,10864872,10619365,8584028,10614985,8570247,10845714,10200819,10200820,10253223,8621544,10253838,9189299,9189319,8864637,9174161,9174162,9174163,9174164,9174165,9174166,9174167,9174168,9174169,9174170,7025089,8542671,7026558,9185343,9911797,10125870,10125871,10125872,7023700,7023826,3285948,3285949,10418187,9916929,7020511,9207837,9207987,8917731,8917737,10909263,10909264,10909265,10909266,10909267,10909268,10629158,10629159,10629164,10892510,10173871,10162163,10912335,10912336,10608487,10652767,10652790,10652791,10584176,10584177,10584178,10584179,10587273,10587297,10587298,10587299,10587300,10587301,10587302,10587303,10587304,10587305,10587306,10587307,10587308,10587309,10587310,10587311,10587312,10587313,10647477,10587542,10587543,10587544,10587545,10587546,10587547,10587548,10587549,10587550,10650819,10650820,10601411,10586020,10519279,10519280,10519281,10519282,10529433,10529434,10529435,10529436,10529437,10529438,10529439,10529440,10529441,10529442,10553732,10553733,10553734,10553735,10522737,10520922,10423503,10423505,10423506,10424593,10424880,10409633,10495167,10487497,10476612,10476613) 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>