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(7076293,10870628,8630998,10871050,8632472,8632474,8632476,8632480,8632481,8632483,8632487,8632489,8629754,8629755,8629756,10870111,10447781,10447796,10861216,10447806,8627715,10985860,8627836,8627839,8627840,8627841,8627844,8627845,8627846,8627850,8627851,8627857,8627860,8627861,10843035,7201897,10843427,8836250,8836251,7202329,10859638,10859640,10859641,10859642,10859643,10859644,10859645,10859646,10859647,10859648,10867699,10867710,10867712,8629103,7202770,7202771,8629258,3237395,3927786,3927788,10866030,10866031,10102922,10855538,7198685,7198748,7198760,8625473,10941695,10941697,10941698,10941755,10941770,8626112,8626118,8626119,8626124,10101736,8626319,7070793,8626467,8626468,8626469,10853230,3234127,7197705,10995359,10995360,10995379,10995380,11047472,8624496,8624503,8634615,8634616,8634617,8541578,11044807,11044808,11044809,11044810,11044811,11044812,11044813,10852642,10617434,10617435,10993373,10993600,8632595,10848006,10850650,8633219,10615711,10991487,10991516,10991581,10991582,10991583,8633550,8633566,10991720,10991745,10991899,10991900,10991901,10991902,10991948,8540781,10991983,10991984,10991998,10992005,10992235,10992236,10992237,10992240,10992241,8611468,10992377,10992379,10992383,8634456,8634457,8634466,8634467,8634468,8634469,8634470,8634471,8634478,8634479,8634480,8634481,8634484,8634490,8634491,8634492,8634493,8634494,8634495,8634497,8634500,8634504,8634505,10616888,8634511,8634514,8634515,8634519,8634520,8634525,8634526,8634529,8634530,8634533,8634534,8634537,8634538,8634539,8634540,10992579,8634541,8634542,8634543,8634544,8634545,8634546,10610995,10714271,9174083,8851890,8851891,8851892,9188364,9188365,9188366,9188379,9188394,10613369,6677249,6677262,6677263,6677277,10613736,10610775,10610777,8567674,8567675,8567676,8567677,8567703,8567763,8849319,8849320,8849321,8849322,8849323,8849329,8849330,8849332,8849378,9185718,9185742,9185796,9185829,9185830,9185831,9185832,9185854,9185863,9185864,9185892,9185908,9185938,9186012,8849898,9186127,9912438,9186354,9186358,9186359,9186360,9912773,9912966,8850596,8850597,9186778,9186779,9186801,8848719,8848725,8848726,8848728,8848730,8848741,8848744,8848746,8848747,8848756,8848758,8848760,8848761,8848762,8848767,8848782,8848829,8848843,8848845,8848848,8848866,8848877,8848889,8848909,8848911,8848920,10419190,8550664,10903561,10883624,10883627,10883629,10903654,10903655,10903656,10903657,10903658,10903659,10903676,10903708,10903709,10903710,10903711,10903830,10903835,10905188,10905189,10883416,10630146,10172074,10172089,10626242,10598588,10598589,10598602,10598603,10598634,10598635,10598636,10598637,10598638,10602696,10602697,10602700,10602722,10602723,10602724,10602725,10603684,10651421,10541443,10528110,10528111,10528112,10528113,10528114,10528139,10528143,10528151,10528160,10422279,10420424,10420435,10420438,10422597,10414071,10414073,10414074,10414075,10414076,10414077,10414078,10414079,10414080,10410702,10497396,10497397,10415184) 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>