With your query i get:

Column 'products_id' in field list is ambiguous


And i have to ad:

products_to_categories in the FROM

like this:

FROM products, products_description, products_to_categories