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(8631254,8631593,7066004,7066005,7066006,8631779,8631809,8631832,8631833,8631834,8631835,8631836,8631898,3230230,8629825,8629826,8629827,8629828,8629829,8629830,8630285,8630288,8630296,8630297,8630298,8630299,8630300,8628171,8628172,8628173,10858825,3899093,8595250,8628624,8628625,10859287,8629383,8629384,3227181,8629412,3227182,8629494,8629495,8629496,8629497,8629498,8629499,8629500,8629563,8629564,8626679,8626680,8626681,8626772,8626805,8626806,8626807,8626808,8626809,8626810,10855223,8624677,8624695,8624794,8624795,8624796,8624797,8624798,8624799,8624923,8624924,7198685,7198686,8625210,8625211,8625212,8625213,8625214,8625217,7198841,8625243,8625244,8625245,8625246,8625247,7198851,8625376,8625377,8625378,8625379,8625380,10856089,10856090,10856091,10856092,10856093,10856094,10856095,10856096,10856097,10856098,10856351,10101499,8626204,3923497,8624425,7198075,7198076,7198077,7198078,7198079,7198080,7198081,7198082,7198083,7198084,7198085,7198086,7198087,7198088,7198089,7198090,7198091,7198092,7198093,7198094,7198095,7198096,7198097,7198098,7198099,7198100,10855221,10855222,10852608,8905387,8905388,8905389,8905390,8905391,8905392,10615037,8632681,3581869,3581870,3581871,8633244,8633246,8633247,8633248,8633249,8540638,8633987,8634179,8634180,8634181,8634189,8634190,8634236,8634237,8634292,8634293,10612127,10612128,10612129,10612130,10612131,8851707,10612886,10612888,9160337,9160341,9160342,9160343,9160347,9160348,9168397,9168398,10468445,10468446,10908629,10884820,10884821,10884822,10884823,10884824,10884825,10884826,10884827,10884828,10884829,10884830,10884831,10884832,10884833,10884834,10884835,10884836,10874992,10875004,10875005,10875006,10875007,10875008,10875009,10875010,10875011,10875012,10875014,10875015,10875016,10875017,10875018,10875019,10875020,10875021,10875022,10875023,10875024,10875025,10875026,10875027,10875028,10875029,10875032,10875033,10875034,10875035,10875036,10875037,10875038,10875039,10875040,10875041,10875042,10875043,10875044,10875045,10875046,10875047,10875048,10161966,10876593,10876600,10877124,10604028,10545356,10545357,10545358,10545371,10545372,10545373,10546486,10546487,10546488,10546491,10546492,10546493,10546494,10546495,10546504,10546505,10546506,10546507,10546542,10546543,10546544,10546545,10546546,10546547,10546548,10546634,10546635,10546637,10508273,10508352,10508353,10508354,10508355,10508356,10508357,10508360,10508361,10508362,10508363,10508364,10508365,10508366,10508367,10508368,10508369,10508370,10508371,10507725,10507726,10507861,10507862,10507863,10507864,10507865,10507866,10507867,10507868,10507869,10507870,10507871,10507872,10507873,10507874,10507875,10507876,10507877,10507878,10507879,10507880,10507881,10507882,10507883,10507884,10507885,10507886,10507904,10507905,10507906,10411221,10411222,10411223,10411224,10411225,10413373,10411398,10410408) 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>