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(4970741,7066014,7066015,8583496,7066240,7066241,10860286,8573259,10939397,10939398,8065828,10859261,10859262,10859263,10859264,11049795,11049796,10864138,10101506,3923511,8624381,7198177,8905436,8905437,8905438,8905439,8905440,8905441,8905442,8905443,8905444,8905445,8905446,8905447,8905448,8905449,8905450,8905451,8905452,8905453,8905454,8905455,8905456,10615583,8611342,10616552,10616553,10714130,10714138,10612350,10612351,10612352,10612353,10612354,10612355,10612356,10612357,10612358,10612359,10612360,10612361,10612362,10612363,10612364,10612365,10612366,10612367,10612368,10612369,10612370,10612371,10612372,10612373,10612374,10612375,10612376,10612377,10612378,10612379,8851812,8851813,8851814,8851815,8862520,8862521,8862522,8566627,10610132,9914948,7055491,989916,989919,989920,989921,989923,989931,989932,989933,989934,989935,989972,989973,989976,989977,989978,989980,989981,10117972,10117973,10117974,990414,990415,990416,990417,990418,990419,990420,990421,990422,990443,990444,990445,990446,990447,990448,990449,990450,990451,990452,990453,990454,990455,990456,990457,990461,990462,990463,990464,990465,990466,990467,990470,990471,990475,990478,990479,990480,990481,990482,990483,990484,990485,990491,990492,990494,990495,990497,990498,9912342,9912343,990536,990537,990538,990539,990540,990541,990542,990543,990544,990545,990546,990547,990548,990549,990550,990567,990806,990855,990856,990857,990858,990859,990863,990864,990865,990866,990867,990871,990872,990877,990885,990887,991078,991083,991084,991112,991113,991116,991117,991118,991119,991120,991121,991190,991191,991192,991193,991194,991195,991196,991197,991198,991199,991200,991201,991202,991203,991204,991205,991206,991207,991208,991209,991210,991211,991212,991213,991214,991215,991216,991217,991337,991338,991339,991340,991341,991342,991345,991346,991347,991348,991349,991350,991351,991352,991353,991354,991355,991356,991357,991358,991359,991360,991361,991362,991363,991364,991365,991379,991380,991381,991382,991383,991386,991387,991388,991389,991390,991391,991392,991393,991394,991395,991396,991397,991398,991399,991400,991401,991402,991403,991404,991405,991414,991415,991416,991417,991418,991419,991420,991421,9168513,9168514,9168515,9168516,9168517,9168518,9168519,9168520,9168521,9168522,9168523,6673348,6673349,6673350,6673351,6673352,6673353,6673354,6673355,6673356,6673357,6673358,6673359,6673360,6673361,6673362,6673363,6673364,6673365,6673366,10471030,8550035,10468530,10468531,10468532,10468533,10468534,10468535,10468536,10468537,10468538,10468539,10468540,10468541,10468542,10468543,10468544,10468545,10468546,10468547,10468548,10468549,10468550,10468551,9168157,9168158,9168159,10888646,10888647,10888648,10889478,10885075,10885157,10885158,10885159,10885160,10885161,10885162,10885163,10885164,7000832,10888323,10888324,10161828,10161985,10647343,10647344,10647492,10647493,10647494,10647495,10647496,10647497,10647498,10650506,10650513,10647680,10650683,10507758,10507759,10413717,10413718,10413719,10413720,10414509,8562189) 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>