SELECT pd.products_name, m.manufacturers_name, cd.categories_name, p.products_model, p2c.categories_id
FROM products_description pd
INNER JOIN products_to_categories p2c ON p2c.products_id = pd.products_id
INNER JOIN products p ON pd.products_id = p.products_id
LEFT JOIN manufacturers m ON m.manufacturers_id = p.manufacturers_id
INNER JOIN categories_description cd ON p2c.categories_id = cd.categories_id AND cd.language_id='1'
WHERE pd.products_id='17826' AND pd.language_id='1' LIMIT 1