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(10859433,10859446,10859448,5654652,9794574,7066018,10860027,8067928,8910653,8910654,7201337,7201404,7198687,8625286,8625308,8625309,8625310,8625349,8625365,10856310,7199385,7199438,7199439,7199440,7199441,7199445,10101493,8910254,8910255,3922823,8905535,10866149,3923441,3923567,3923612,10866984,10866985,10284591,10284592,10284593,8860416,8860417,3231151,8611345,8611346,10865382,10862971,10862975,10862979,10863382,10863384,10863385,10863386,10863387,10863388,10863389,10863390,10863391,10863392,10863393,10863398,10863404,10863405,10863407,10863409,10863419,10863420,10863421,10863422,10863424,10863425,10863426,10863427,10863428,10863436,10863438,10615320,10615324,8630433,10861403,10861511,3229120,3229121,3229122,10616804,10614095,10614489,10614490,10614491,10614492,10612381,8566633,10612886,10612891,10612892,10612893,10612894,10612896,10612897,10612898,10612901,10612902,10612903,10612904,10612905,8852540,8852564,9169464,9169467,6673737,9169568,10118129,10118357,9912666,9912667,9912668,9912766,9912792,10118910,9913270,10419261,10416534,10416539,10416544,9168699,10418681,9168841,10419852,10419853,10419854,10419855,10419856,10419857,10419859,10419860,10419861,10419862,10419863,10419865,10419868,10419869,10419870,10419871,10419872,10416919,10416920,10416921,10416922,10416923,10416925,10416926,10416927,10416928,10416929,10416930,10416931,10416933,10416936,10416938,10416939,10416940,10416941,10416942,10416943,10416945,10416946,10416947,10416949,10416950,10416951,10416952,10416953,10416954,10416955,10416956,10416957,10416959,10416960,10416961,10416962,10416963,10416964,10416965,10416966,10416968,10416969,10416971,10416973,10117456,10117462,9169268,8916775,8916776,10469936,10469937,10469938,10469939,10469941,10469942,10469943,10469944,10469945,10115992,10115993,10470631,10468766,10468767,10468780,10884002,10879911,10885312,10885313,10885406,10885407,10882572,10887951,10888053,10888160,10888163,10888173,10888175,10888179,10888185,10888190,10888191,10888192,10888193,10888196,10888200,10888205,10888209,10888212,10888213,10888216,10888217,10888220,10888221,10888231,10888232,10888233,10888235,10888236,10888237,10888238,10888242,10888243,10888245,10888246,10888247,10888349,10888350,10888354,10886905,10886906,10877176,10882452,10887454,10887455,10887456,10601962,10608060,10602590,10602594,10647578,10609491,10609631,10609632,10609633,10601596,10610674,10601945,10601956,10601960,10601961,10415344,10415403,10409465,10409466,10409467,10413897,10413898,10413899,10413900,10413903,10413904,10413905,10413910,10413911,10413913) 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>