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(8631091,8631092,8631093,8631094,8631095,8631096,8631630,8631995,8632241,8632246,8632248,8632252,8632270,8632382,8632461,8632462,8632480,8632575,8629716,8629717,8629742,8629832,8629834,8629836,8629838,8629841,8629843,8629849,8629850,8629851,8629852,8629853,8629854,8629856,8629863,8629865,8629868,8629870,8629873,8629881,8629913,8629915,8629917,8629920,8629921,8629923,8629925,8629930,8629932,8629934,8629936,8629938,8629939,8629942,8629945,8629947,8629950,8629953,8629957,8630449,8630451,8630452,8627584,8627585,8627586,8627587,8627588,8627589,8627590,8627591,8627592,8627593,8627594,8627595,8627596,8627597,8627598,8627599,8627600,8627601,8627602,8627603,8627604,8627605,8627606,8627607,8627608,8627609,8627610,8627611,8627612,8627613,8627614,8627615,8627616,8627625,8627626,8627627,8627628,8627630,8627631,8627632,8627633,8627983,8627984,8627985,8627986,8627987,8627988,8627989,8627990,8628169,8628170,8628394,8628404,8628490,8628491,8628492,8628493,8628634,8628724,8628725,8628726,8628727,8628823,8628826,8628832,8628835,8628843,8628844,8629092,8626834,8627237,8627238,8627242,8627243,8627251,8627252,8627253,8627283,8627288,8627289,8627293,8627310,8627312,8627313,8627314,8627315,8627316,8627317,8627318,8627319,8627320,8627321,8627322,8627425,8627426,8627427,8627428,8627429,8627430,8627431,8627432,8627433,8627434,8627435,8627436,8627437,8627438,8627439,8627440,8627441,8627442,8627443,8627444,8625105,8625628,8625629,8625630,8625631,8625632,8625633,8625634,8625635,8625636,8625637,8625638,8625639,8625640,8625641,8625642,8625656,8625657,8625658,8625659,8625660,8625661,8625662,8625663,8625664,8625665,8625666,8625667,8625668,8625669,8625670,8625671,8625672,8625673,8625674,8625675,8625676,8625694,8626291,8626292,8626293,8626294,8626295,8626296,8626297,8626298,8626299,8626300,8626301,8626302,3923593,8624496,8624502,8624503,8624504,8624505,8624507,8624508,8624512,8624522,8624524,8624525,8634615,8634616,8634617,8635008,8635009,8635015,8635018,8635020,8632597,8632598,8632599,8632647,8632847,8632848,8632849,8632850,8633202,8633203,8633204,8633205,8633206,8633207,8633208,8633209,8633210,8633211,8633212,8633213,8633214,8633215,8633216,8633217,8633218,8633279,8633422,8633425,8633429,8633430,8633432,8633433,8633434) 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>