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(8631298,8631299,8631300,8631301,8631302,8631303,8631310,8631311,8631312,8631313,8631314,8631315,8631322,8631323,8631324,8631325,8631326,8631327,10862214,10849514,10862930,10862931,10863081,10863082,10863083,10861074,8627699,8627700,8627702,8627703,10858577,10858620,7201605,7201606,8595080,10858822,10858823,10858824,7201840,8629208,8629209,8629210,8629211,8629212,8629213,8629214,8629215,8629216,8629217,8629218,8629219,10860135,10860170,10865378,10865379,8627469,8627470,8627471,8627472,8627473,8627474,8627475,8627476,8627478,8627479,8627480,8627491,8627492,8627493,8627494,8627495,8627496,8627497,8627498,8627501,8627502,8627503,8627507,8627508,8627509,8627510,8627511,8627512,8627515,8627516,8627517,8627518,10855579,10855580,10855581,10855582,10855583,10855584,10855585,10855586,10855587,10855588,10855589,10855590,10855591,10863810,10863811,10863812,10863813,10863843,7200072,3923443,10853489,10853490,10853491,10838941,8624408,8624472,8624565,8624566,8624567,8624568,8624569,8624570,3232859,8632591,8632592,10851158,10851159,10851160,10851161,10851162,10851163,10851164,10851165,8634161,10614050,10122054,10612294,8862499,10612889,10610958,10610959,9169448,10417294,10417295,10416498,10416634,10416635,10416636,10415909,9168098,10888517,10888518,10888519,10888597,10888598,10888599,10888600,10883713,10882681,10882980,10882981,10508493,10507725,10507726,10507894,10413371,10413372,10408185,10408186,10408187,10408188,10408189,10408190,10408191,10408192,10408193,10414521,10414555,10410743,10410744,10410745,10410746,10410747,10410748,10410749,10410750,10410751,10410752,10410753,10410754,10410755,10407101,10413114,10413159) 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>