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(3228550,3229282,8631585,10862781,3227580,10866513,8628005,8628006,8628027,10866699,10867514,10859997,8626727,7200631,7200632,10856190,10856391,10856400,10856418,10856485,10856486,10864823,10864934,3237341,3237347,3237348,10623312,3234501,3234502,3234663,3234984,10852313,10852314,10852332,10852333,10852334,10852335,10852336,10850271,10850273,10850275,10850277,10850278,10850279,10850280,10850281,10850282,10850283,10850284,10850286,10850287,10850288,10850289,10850290,10850291,10850292,10850293,10850294,10850295,10850296,10850298,10850300,10850301,10850302,10850303,10850304,10850305,10615077,10615289,10850932,10852028,10610998,10611122,10614190,10611802,10612424,7017441,7017442,7017443,7017444,7017445,7017446,7017477,7017478,7017479,7017480,7017481,7017482,10612842,10612864,8852056,10610467,8852832,9169435,7015388,7015389,10118100,10418226,10418227,10418228,10416345,7014182,7014183,10419459,10418147,10470644,7013879,7013880,7013881,7013882,7013883,7013884,7013921,7013922,7013923,7013924,7013925,7013926,10884100,10420290,10508248,10508300,10508307,10508308,10508309,10508310,10508311,10508312,10505552,10507783,10507787,10507925,10508042,10411284,10411434,10411443,10411457,10411523,10411524,10407635,10407636,10407638,10407640,10407642,10407643,10407644,10407645,10407646,10407647,10407648,10407649,10407650,10407652,10407653,10407654,10407655,10407656,10407657,10407658,10407659,10407660,10407661,10407662,10407663,10407665,10407667,10407668,10407669,10407670,10407671,10407672,10407673,10407674,10408130,10414395,10408863,10408864,10408865,10408866,10408867) 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>