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(10861399,8630763,8630764,10848643,10848644,10848649,10848650,10848651,10848652,10848653,10848654,10848656,10848657,10848658,10848659,10863178,7201197,7201351,7201352,7201353,7201354,7201359,10866565,10866566,10866567,10866568,10866569,10866570,10866575,10866576,10866577,10866578,10866579,10866580,8595277,7201910,10867036,8628572,8628573,8628577,8628592,8628593,8628609,7202259,7202264,7202265,7202266,7202285,7202286,7202287,7202353,7202354,7202355,7202358,7202359,10859590,8629140,10865242,10865244,10865275,10865282,10865293,10865294,10865307,10865320,10865330,10865343,10865359,10865361,10857701,10857726,10857727,10857728,10857729,10857730,10857731,10857759,10857760,10857761,10857762,8627222,8627224,8627225,8627226,8627227,8627228,8627229,8627230,8627234,8627235,8627236,8627239,8627240,8627241,8627245,8627246,8627247,8627248,8627249,8627250,8627254,8627255,8627256,8627257,8627263,8627264,8627265,8627266,8627267,8627268,8627269,8627274,8627275,8627276,8627277,8627278,8627279,8627280,8627281,8627282,8627284,8627285,8627286,8627287,8627291,8627292,8627294,8627296,8627297,8627298,8627300,8627301,8627302,8627303,8627304,8627305,8627306,8627307,8627308,8627309,8627311,10866124,10855420,10855421,10863421,10855429,10855430,10863454,10855881,10855882,10855883,10855981,10855983,10855984,10855985,10855987,10855988,10855989,10864196,10864197,10864199,10856233,3926351,10864748,3923550,10853599,10853621,10854084,10854085,10854086,10854887,10855079,10855080,10855081,10852613,10852614,10852615,10852616,10852617,10617375,10617376,10617445,10853071,10853072,10853144,8905952,10852186,9166135,10612069,10609910,8852713,8852832,8852898,8852899,9169437,9169511,10118040,9169947,10118329,10118560,9912953,9912954,9913033,8552226,10419254,10419527,10417532,10417533,10417535,10418549,10418551,10418580,10418589,10418590,10418600,10418601,10418631,10418632,10418643,10418673,10418675,7014548,7014549,10419922,10416956,10416992,10117379,10471172,8550110,8550111,8550160,8550227,8550228,8550263,8855353,10628321,10888937,10884102,10889640,10889946,10889965,10890137,10890140,10890143,10890160,10885469,10888253,10877124,10603709,10604195,10508302,10508303,10508406,10508535,10409308,10409309,10488276,10488277,10488278,10409883,10409884,10409885,10496731,10496732,10496733,10496734,10496735,10496736,10412292,10412320,10412321,10412322,10412323,10412324,10412325,10412355,10412356,10412357,10410595,10410596,10410604,10410605,10414904,10406904,10406905,10406911,10406912,10406913,10406914,10406915,10406916,10406918,10406919,10406920,10406921,10406922,10472590,10409053,10409054,10409055,10411111,10411113,10411115,10411122,10411124,10411130,10411135) 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>