SELECT pd.products_name, m.manufacturers_name, cd.categories_name, p.products_model, p2c.categories_id FROM h2f_products_description pd INNER JOIN h2f_products_to_categories p2c ON p2c.products_id = pd.products_id INNER JOIN h2f_products p ON pd.products_id = p.products_id LEFT JOIN h2f_manufacturers m ON m.manufacturers_id = p.manufacturers_id INNER JOIN h2f_categories_description cd ON p2c.categories_id = cd.categories_id AND cd.language_id='4' WHERE pd.products_id='496' AND pd.language_id='4' LIMIT 1 [TEP STOP] |
