Consulta Mysql

[jurena]

Creo que lo que buscas se parece más a esto.

Código MySQL:

SELECT t1.products_id, 
t1.products_image,
t1.products_name
 FROM (SELECT p.products_id, p.products_image, pd.products_name
FROM products p 
 INNER JOIN products_description pd ON p.products_id = pd.products_id
 INNER JOIN products_to_categories p2c ON p.products_id = p2c.products_id
 INNER JOIN categories_description cd ON p2d.categories_id = cd.categories_id
WHERE p2c.categories_id = '1'
  AND p.products_status = '1'
  AND cd.language_id = '2'
  AND pd.language_id = '2')t1
 GROUP BY t1.products_id