1060 - Duplicate column name 'products_id'

SELECT * FROM (SELECT * FROM products JOIN products_description ON products.products_id = products_description.products_id WHERE language_id = 1) p JOIN products_to_categories pc ON p.products_id = pc.products_id ORDER BY p.products_name

[TEP STOP]