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(7076323,7076324,8839136,8839137,8622726,8561212,10859518,10104810,10943373,10943374,8624659,10928588,10928589,10928590,10928591,10928592,10928593,10928594,11046729,11046730,11046731,11046732,11046733,11046734,11046735,11046736,11046737,11046738,11046739,11046740,11046741,11046742,11046743,11046744,11046745,11046746,11046747,11046748,9213615,9213616,9213617,9213618,9213619,9213620,9213621,9213622,9213623,9213624,9213625,9213626,9213627,9213628,9213629,9213630,9213631,9213632,9213633,9213634,9213635,9213636,9213637,9213638,9213639,9213640,9213641,7059850,10126107,8918313,10601352,10599069,10599070,10599071,10599072,10599073,10599074,10599075,10599076,10599077,10599078,10599079,10599080,10599081,10599082,10599083,10599084,10599085,10599086,10599087,10599088,10599089,10599090,10599091,10599092,10599093,10599094,10599095,10599096,10599097,10599098,10599099,10599100,10599101,10599102,10599103,10599104,10599105,10599106,10599107,10599108,10599109,10599110,10599111,10599112,10599113,10599114,10599115,10599116,10599117,10599118,10599119,10599120,10599121,10599122,10599123,10599124,10599125,10599126,10599127,10599128,10599129,10599130,10599131,10599132,10599133,10599134,10599135,10599136,10599137,10599138,10599139,10599140,10599141,10599142,10599143,10599144,10599145,10599146,10599147,10599148,10599149,10599150,10599151,10599152,10599153,10599154,10599155,10599156,10599157,10599158,10599159,10599160,10599161,10599162,10599163,10599164,10599165,10599166,10599167,10599168,10599169,10599170,10653440,10653441,10653442,10653443,10653444,10588558,10588559,10588560,10425246,10425247,10425248,10425249,10425250,10425251,10425252,10425253,10425254,10413974) 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>