1066 - Not unique table/alias: 'm'

SELECT DISTINCT m.manufacturers_id, m.manufacturers_name FROM products AS p LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id) LEFT JOIN manufacturers m ON m.manufacturers_id = p.manufacturers_id LEFT OUTER JOIN specials AS s ON (p.products_id = s.products_id) AND s.status = '1' INNER JOIN manufacturers AS m ON m.manufacturers_id = p.manufacturers_id WHERE p.products_status = '1' AND pd.language_id = '2' AND ( ( pd.products_keywords LIKE ('%pfostenträger%') OR pd.products_description LIKE ('%pfostenträger%') OR pd.products_short_description LIKE ('%pfostenträger%') OR pd.products_name LIKE ('%pfostenträger%') OR p.products_model LIKE ('%pfostenträger%') ) ) ORDER BY m.manufacturers_name ASC

[XT SQL Error]