SELECT p.products_id, d.products_name, d.products_description, p.products_image, p.products_price, c.categories_id, p.products_model, m.manufacturers_name
FROM products p
LEFT JOIN products_description d ON p.products_id = d.products_id
LEFT JOIN products_to_categories c ON c.products_id = p.products_id
LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id
WHERE d.language_id = 1