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(11001916,11002108,11002376,11002377,11002378,11002379,10940440,10940441,10940442,10940443,11002542,7068917,7068918,7068919,7068920,7068921,7068922,7068923,11028678,11028679,11028680,11028681,11002688,11002689,11028764,11028765,11028766,11028767,11028768,11028769,11028770,11028771,11028772,11028773,11028774,11028775,11028776,11028777,11002860,11002861,11002963,11003071,11003269,11003270,11003271,11003414,11003415,11003416,11003419,11003420,11003551,11014124,11014125,11014306,11014307,11014308,11014309,11014310,11014311,10960061,11026178,11026273,11026274,11026275,11026276,11026277,11026278,11026279,11026280,11026281,11026282,11026283,11026284,11026285,10974483,11023959,11023960,11023961,8626992,7200684,7200685,7200728,10857845,11034628,11034629,11034880,11022254,11022255,11022279,11022280,11022281,11022282,11022283,11022284,11022285,11022286,11035379,11022705,11022706,11022707,11022708,11022710,11035798,11035799,11035800,11035801,11035844,11035846,11035847,11023001,11023002,11023049,11023205,11023206,11023207,11023362,10622972,11032901,11032902,11032903,10838099,8613731,8613732,8613733,10994629,3924417,3924418,10994742,10994743,7157646,7157649,11033920,11007928,11007929,11034062,11034082,11034083,11034084,11034126,11021245,11021246,11021247,11021248,11021249,11021250,11034314,11034315,11034316,11034317,11034318,11034319,11034320,11034321,11034523,11005641,10616997,10427423,10617091,11005777,11044803,11031863,11031864,11032213,11032214,11003630,11003631,11003798,11003899,11003900,11003901,10848004,10848005,11004035,11004036,11004436,11030483,11030484,11030485,11030486,11030487,11004495,11030526,11030527,11030528,10978606,10978607,10978608,10978609,10978610,10978611,10978612,10978613,10978614,10978615,10978616,11031082,11031083,11031088,11005101,11005102,11005103,11005446,10953448,11031531,10614413,10614414,10614634,10611987,9211565,9211566,10613060,10613163,10610174,10610175,10610176,10610177,10610178,10610180,10610181,10610182,10613191,10613192,10613235,10613298,8592788,8592789,8592790,10118572,9178643,9178644,9178645,9178646,9178647,9178648,9178649,9178650,9178651,9178652,9178653,9178654,9178655,9178656,9178657,9178658,9178659,9178660,9178661,9178662,9178663,9178664,9178665,9174841,10908682,10893753,10159020,10159021,10159022,10590272,10590273,10590274,10590275,10590297,10645599,10645600,10604475,10579668,10579669,10523660,10505404,10505405,10488209,10488210) 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>