Consulta Mysql

[davchi]

Hola a todos:
Tengo un problema con una consulta

Es de oscommerce y es la siguiente

SELECT DISTINCT p.products_id, p.products_image, pd.products_name
FROM products p
LEFT JOIN products_description pd ON p.products_id = pd.products_id,
products_to_categories p2c,
categories_description cd
WHERE p2c.categories_id = '1'
AND p.products_status = '1'
AND cd.language_id = '2'
AND pd.language_id = '2'

El problema es q no me respeta los productos de la categoria "p2c.categories_id = '1'"

me muestra todos los productos de todas las categorias

Mas o menos en las tablas tengo

TABLA -> products
products_id
products_image
products_status
---------------------------------------------
TABLA -> products_description
products_id
language_id
---------------------------------------------
TABLA -> products_to_categories
products_id
categories_id
---------------------------------------------
TABLA -> categories_description
categories_id
language_id

Si alguien me puede echar una mano se lo agradeceria

Muchas gracias

[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
 

[davchi]

Jurena, ESPECTACULAR
funciono de maravilla
mil racias