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(4970681,8595035,8595036,10858944,10858951,10858952,10858953,10858954,10858955,10858956,10858957,10859249,10859251,10859253,10859254,10859534,10859535,5654585,10101450,10856782,8626142,8626143,10856785,10856786,10856792,10856797,10856805,10856807,10856808,10856812,10856822,10856824,10856825,10856826,10856829,10856831,10856832,10856833,10856834,10856835,10856836,10856837,10856838,10856839,10856843,3923459,3923460,3923461,3923462,3923463,3923464,3923465,3923630,10854135,10854138,10854144,10854145,10854146,10854156,10854157,10854158,10854159,7197118,10854160,7197119,10854161,8907496,7197822,8624256,7197866,8624360,8624361,8905340,8611286,8611287,8904934,8904936,10611226,10611227,10611228,10611232,10714122,10611778,10609053,10609059,10609062,10609618,10609619,10609620,10609629,10609636,10609637,10609638,10609639,10609640,8862506,8862507,10609651,10609658,10609664,8852058,10613485,7055471,7055472,7055473,7055474,7055475,7055476,7055477,7055478,7055479,7055480,7055481,7055482,7055483,7055484,7055485,7055486,9911692,9911693,9911694,9911695,9911696,9911697,9911698,9911699,9911700,9911703,9911711,9911712,9911713,9911714,9911715,9911716,9911717,9911718,9911719,9911720,9911723,10117758,10117759,10118094,9912116,9912117,9912332,9912333,9912334,8850084,8850085,8850558,8850559,8850560,8850561,8850562,8850563,8850564,8850565,8850566,8850567,8850568,8850569,9913123,6672582,6672586,10117467,10117468,10117469,8549929,10467529,10467530,10467540,10467541,10467542,10468174,976462,10468271,10468272,10468273,10468274,10468275,10468276,10468277,10468278,10468279,9167752,6672079,9168059,9168170,9168171,9168172,9168173,9168174,9168175,9168176,9168177,9168178,9168179,9168180,9168196,10888843,10884306,10884307,10884308,10884309,10884310,10884311,10884312,10884313,10884580,10889591,10885131,10887517,10882565,10882570,10882576,10882580,10882587,10882588,10882589,10882590,10882591,10882592,10882600,10161806,10161809,10161811,10647623,10413459,10411700,10411701,10411702,10411704,10411705,10413709,10411709,10413711,10411711,10413713,10411713,10411717,10411719,10411720,10411721,10411722,10411723,10411724,10411725,10411726,10411727,10411728,10411733,10411736,10411737,10411738,10411739,10411740,10411741,10411744,10411746,10411747,10411748,10411749,10411750,10411751,10411752,10411753,10411754,10409917,10409920,10409921,10409922,10409936,10409937,10409938,10409939,10409940,10409941,10409942,10409943,10409944) 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>