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(10447941,7066180,8631838,8631839,10862974,10862975,8632400,8632401,8632402,8632403,8632404,8632405,8632406,8632407,8632408,8632409,8632411,8632412,8632413,8632414,8632415,8632416,8632417,8632418,8632419,8632420,8632421,8632422,8632423,8575958,8632504,8632505,8632506,8632526,8632531,8632532,8632533,8632534,8632535,8632536,8632537,8632538,8632539,8632541,8632575,7067015,8573298,8630269,8630442,8630443,8630444,8630445,8630446,8630447,8630448,8630449,8630450,8630451,8630452,8630453,8630454,8630455,8630456,8630457,8630458,8630459,8630460,8630461,8630462,8630463,8630464,8630465,8630466,8630467,8630468,7072068,7072069,10103242,10103245,10103246,7064257,7201706,7201707,7201708,7201709,7201710,7201711,7201712,7201713,7201714,7201715,7201716,7201717,7201718,7201719,7201720,7201721,10999160,7201722,7201723,7201724,7201725,7201726,7064526,8628490,8628491,8628492,8628493,10999733,10843977,10843978,10844125,10844129,10844130,10844131,10844135,10844228,8910206,8910207,8626966,8626967,10998390,10839995,10840006,3926244,8625607,8625608,8625609,8625610,8625611,8625612,8625613,8625614,8625615,8625616,8625617,8625618,8625619,8625620,3926397,3926398,3926399,3926400,3926401,3926402,8615980,8615986,8615991,8615992,8615993,7199414,3926661,8616214,3926813,3926816,3926817,3926822,8557682,3923484,8554976,8624258,8624259,8624260,10953991,8541831,8612264,10837356,10837357,10614977,10614978,10614979,8634424,7059754,9197683,9197684,9197685,9197686,9197708,8864421,8864422,10612037,10609283,10609400,8851705,8862763,8852289,8852290,8852291,8852292,8852293,8852294,8852295,8852296,8852297,8852298,8852344,8852345,8852346,8852347,8852348,8852349,8852350,8852351,8852352,8852356,8852357,8852358,8852359,8852360,8852361,8852362,8852363,8852364,8852365,8852366,8852367,8852368,8852369,8852370,8852371,8863098,9173250,9169509,9169512,9169516,9911971,8849917,8850037,10118533,10118591,10118592,9168371,10416538,10416539,10428170,10123004,10123132,10123139,10123142,8917383,8917384,8917385,10893962,10893963,10893971,10175937,10907784,10907785,10627295,10627296,10627297,10627298,10627299,10627300,10627301,10627302,10627303,10627304,10627305,10627306,10627307,10627308,10627309,10627310,10627311,10627312,10627313,10627314,10627315,10627316,10173888) 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>