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 '104'
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]