3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'heinemann_shop.m.manufacturers_name' which is not in SELECT list; this is incompatible with DISTINCT

SELECT DISTINCT m.manufacturers_id,manufacturers_shortname FROM( products p, products_description pd, products_to_categories p2c, categories c) inner JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) where c.categories_status='1' and c.categories_id LIKE '236' and p.products_id = p2c.products_id and p.products_id=pd.products_id and p2c.categories_id = c.categories_id and p.products_status = '1' and pd.language_id = '2' Order by manufacturers_name ASC

[XT SQL Error]