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(8574386,8574387,7068773,8583538,8067183,8067184,8575560,8575561,10977330,10977331,10977494,10977495,10977496,10977497,10447671,10843451,10843452,7070885,7070909,7070915,7070966,10102377,7071363,7071364,7071649,10102882,7068907,3925490,3925491,8615098,8615099,8615100,8909102,8909103,8557190,8557191,8557192,10993669,10993670,10993671,10993672,10993682,10993683,10993684,10993685,10993686,10993687,10993688,10993689,10993690,10993691,10993692,10993693,10993803,10993862,10993863,10993864,10993865,8613480,8613481,8613482,8613622,3924421,8907751,8907834,8907835,8569796,10977739,10977740,10977741,10977943,10977944,10978569,10978638,10621124,10621126,10978666,10978667,10978714,10426679,10426724,10426725,8853327,3654799,3654804,9189852,9189908,9189909,9189910,9189911,10122352,7057672,9188599,9177806,9177807,9177808,9177809,9177810,9177975,9178120,9178121,9178122,7056423,7056424,7056425,9178282,9178326,9178327,9178395,9178396,9178623,9178624,9178738,9178762,9186911,9186912,9186913,9186927,9186931,9186932,9186933,9186988,9186989,8850845,9187056,9187070,9187071,9187072,9187073,4973601,4973602,10469528,4971994,4972009,10462585,10462586,976080,9192221,9192223,10905316,10896636,10896674,10896714,10896715,10896716,10896790,10896791,10896792,10896793,10896794,10896795,10896796,10896927,10897023,10643502,10643503,10649577,10649589,10651431,10651432,10533139,10533140,10533141,10533142,10533143,10533144,10533215,10533216,10533217,10533218,10533219,10533220,10533221,10533222,10533223,10533224,10539325,10539326,10533382,10533420,10533421,10539451,10533502,10523566,10523567,10523568,10523569,10523570,10523571,10523572,10523573,10523689,10523690,10485975,10485976,10485999,10486023,10479188,10479293,10479294,10479374,10479537) 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>