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(10845268,10845274,10845276,10845280,10845281,9214462,8618688,8618692,8618693,8618717,8618731,3925443,3926736,3926738,3926739,3926756,3926758,3926761,3926762,3926763,3926764,3926765,3926767,3926769,3926770,3926774,3926775,3926776,3926777,3926778,3926779,3926780,3926781,3926782,3926783,3926793,3926794,3926795,11010085,3926796,11010086,11010087,11010088,11010091,11010092,11010093,11010094,11010095,11010096,11010099,11010100,11010106,11010107,11010108,11010109,11010110,11010111,11010112,11010113,11010123,11010124,11010169,11010170,9217010,9217030,3582139,3582140,8568475,8568476,8568477,8568478,8568489,8568490,8568491,8568492,8568493,8568494,8568495,8568496,8568497,8568498,8568499,8568500,8568501,8568502,8568503,8568504,8568505,8568506,9212462,10564458,10564459,10564460,10564461,10564462,9198369,6667495,6667514,6667521,6667525,6667529,6667532,10123767,10123768,10123769,10123770,10123771,10174597,10174600,10174611,10174686,10628723,10628724,10628725,10628735,10628736,10628738,10628739,10175678,10175679,10175680,10175681,10175683,10175684,10175694,10175695,10175714,10175715,10175716,10175717,10175725,10175726,10175727,10175742,10175743,10175751,10175752,10175753,10175777,10175778,10175779,10175782,10175787,10175788,10175789,10175790,10175791,10911582) 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>