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(8630938,8630939,8630940,8630942,8630945,8630946,8630947,8630948,8630949,8630950,8630954,8630955,8630956,8630957,7066179,10847286,8609757,8067918,8629683,8629684,8629685,8629686,8573291,10860550,10860551,10860553,10860554,10860555,10860556,10860560,10860561,10860562,10860563,10860564,10860565,10860568,10860951,10860952,10939388,10939436,10858258,10858259,10858260,7201333,7201334,8595159,8595160,10859134,10859138,8065833,10859480,10859481,10859482,10859483,10859484,10859485,10859486,10859487,10859488,10859489,10859490,10859491,10859492,10859493,10859494,10859495,10859496,10859497,10859498,10859499,10859500,10859581,10859582,10859585,5654632,7202654,7202672,10859996,10859998,3227190,3237370,10865362,10865366,10865367,10865368,10865369,10865370,10865371,10865372,10865374,10865378,10865379,7200550,7200551,7200552,7200553,7200554,7200556,7200557,7200894,7200895,7200922,7200996,8624722,8624723,10863442,10863454,10855634,10855635,10855638,10855644,10855650,10855651,10855658,10855662,10855663,10855664,7198765,7198768,10855884,10855885,7198888,7198889,7199099,10856162,10856163,10856167,10856168,7199234,7199567,7199889,7199890,7199891,10865007,10865008,7200091,3923411,3923525,8906549,7197246,10854323,10854409,10854410,10854411,7197441,7197461,7197470,7197471,7197472,7197473,7197474,7197475,7197476,7197480,7197587,7197588,7197589,7197915,7198131,8905070,8905128,8905132,8905134,8905135,8905136,8905137,8905138,8905784,8905785,8905843,8905862,10425349,10425360,10615084,10615535,10615537,10615540,10615577,10615911,10615914,10616014,10616084,10616085,8611404,10616895,10614064,10611351,10614369,10614370,10614381,10614441,10614442,10614551,10614562,10612269,8851704,8851875,8566605,8566674,10609846,10609847,10609851,10609852,10609853,10609988,10610059,10613122,10610152,10610194,10610380,10610381,10610382,8852544,8852545,10610383,10610384,10610385,10610386,10610387,10610388,10610389,10610390,10610391,10610392,10610393,10610394,10610395,10610470,10610513,10613646,10613647,10613649,10613653,10613654,10613655,10613656,10613657,10613661,10613662,10613663,10613664,10613665,10613666,10613667,10613668,10613669,10613670,10613671,10613672,10613673,10613674,10610872,10117547,6673639,9161492,10117713,6673743,9911808,9911809,9911810,9169698,9911915,9911919,10117923,9911978,9911979,9911994,10117994,10118055,9912147,10118156,10118244,10118308,9912420,9912424,990618,10118495,10118516,8850184,8850185,8850189,8850190,8850191,8850192,8850193,8850194,8850195,8850196,9912591,9912592,9912593,9912594,9912595,9912596,10118596,10118597,10118599,9912634,9912635,9912669,9912805,9912806,9912812,9912813,9912814,9912817,9912818,9912955,9912956,991141,991159,9913072,9913196,10418295,10418296,10418297,10418298,6672618,10417494,9910900,10418676,9168958,10416977,10416978,10416992,9169223,9169230,10469257,10469259,10469260,10467604,10467605,10467822,10467839,10467881,9167379,976431,976520,976521,976522,976523,976539,9167767,9183789,9183790,976569,10468519,9168094,10888585,10883823,10888922,10888923,10888924,10888927,10888928,10888945,10889061,10884581,10889931,10889932,10889933,10889935,10887518,10887553,10887556,10882596,10887704,10882901,10882902,10882903,10887994,10908035,10883044,10883097,10883098,10883099,10883100,10883227,10883228,10883232,10883280,10883281,10885526,10161849,10885909,10885911,10885914,10885915,10885916,10885918,10885919,10885920,10885921,10885922,10885923,10886772,10886773,10886881,10882074,10887141,10887268,10602320,10602738,10647349,10647532,10647595,10604441,10508358,10508488,10411266,10411267,10411508,10413633,10413637,10413936,10413937,10413938,10413939,10413940,10413941,10413942,10413943,10413944,10413945,10413946,10413947,10413948,10413949,10413950,10411950,10413951,10413952,10413953,10413954,10413955,10413956,10413957,10414022,10414025,10414029,10410795,10410796,10410798,10412800,10412801,10412802,10410804,10410810,10410811,10410815,10410818,10410819,10410820,10410822) 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>