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(11015271,11015272,11015273,11015274,11015275,11015276,11015277,11015278,11015279,11015280,11015281,11015282,11015283,11015284,11015285,11015286,11015287,11015288,11015289,11015290,11015291,11015292,11015293,11015294,11015295,11015296,11015297,11015298,11015299,11015300,11015301,11015302,11015303,11015304,11015305,11015306,11015307,11015308,11015309,11015310,11015311,11015312,11015313,11015314,11015315,11015316,11015317,11015318,11015319,8631560,8631561,8631562,8631563,8631564,8631565,8631568,8631569,8631570,8631571,8631572,8631573,8631574,8631575,8631576,8631578,8631580,8631582,11028678,11028679,11028680,11028681,11028764,11028765,11028766,11028767,11028768,11028769,11028770,11028771,11028772,11028773,11028774,11028775,11028776,11028777,8067471,9216298,3230158,11013845,10961950,10961951,10961952,11014124,11014125,11014306,11014307,11014308,11014309,11014310,11014311,11014427,11014428,11014429,11014430,11014431,11014432,11014474,10988490,7201542,3898972,7064552,7065203,11026178,11026273,11026274,11026275,11026276,11026277,11026278,11026279,11026280,11026281,11026282,11026283,11026284,11026285,8572902,11023959,11023960,11023961,8626992,7200684,7200685,7200728,8627379,8064733,7198411,11022254,11022255,11022279,11022280,11022281,11022282,11022283,11022284,11022285,11022286,10100977,10957699,10957700,10957701,10957702,10957703,10957704,10957705,11022705,11022706,11022707,11022708,11022710,7070239,11023001,11023002,11023049,7199683,7199684,7199725,11023205,11023206,11023207,11023362,10622972,7196677,10981856,11021245,11021246,11021247,11021248,11021249,11021250,10616997,10617091,11005777,11031863,11031864,10622306,11032213,11032214,8542098,10614998,10425791,10850804,10850805,10850806,8576893,10851056,11030483,11030484,11030485,11030486,11030487,11030526,11030527,11030528,11031082,11031083,11031088,7155036,7155037,11031531,8634557,10121627,10614414,9915973,9915974,9915975,9915976,9915977,9915978,9915979,9915980,9915981,9915982,9915983,9915984,9915985,9915986,9915987,9915988,9915989,9915990,9915991,9915992,9915993,10611478,10611486,10614920,8851328,8851563,9180240,9180243,9180252,9180253,10613060,10610170,10610174,10610175,10610176,10610177,10610178,10610180,10610181,10610182,10613191,10613192,9180594,9180595,10613298,8567410,9164960,9164961,9164962,9164963,9164964,8853016,9173266,9173267,9173268,9173269,8592640,10117787,10117788,9170030,9186048,8850168,10118558,10118572,7056930,7056932,7056934,8850610,9913091,8850802,8850969,8850970,8850988,8851068,8851069,8851070,8851071,10116579,6680827,10428351,9201082,9201083,9201084,9201085,9201086,9201087,9201088,9201089,9201090,9201091,9201092,9201093,9201094,9201095,10419179,8849090,10465295,10465296,10465297,6671639,6671640,6671641,10464209,10464247,6667727,10468805,10879362,10879363,10947289,10915157,10915158,10915159,10915160,10915161,10915162,10915163,10915164,10915165,10915166,10915167,10915168,10915169,10915170,10915171,10915172,10915173,10915174,10915175,10915176,10183959,10159020,10159021,10159022,8593357,10886061,10886062,10886063,10162839,10162840,10897240,10882353,10602501,10645599,10645600,10604407,10604475,10604518,10604582,10523984,10523985,10524008,10508163,10508385,10508386,10508387,10508388,10508389,10508390,10508391,10505404,10505405,10508534,10408034,10408035,10408036,10408167,10480870) 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>