SELECT p.`id_product` id_product
FROM `ps_product` p
INNER JOIN ps_category_product cp
ON p.id_product = cp.id_product
INNER JOIN ps_category c ON (c.id_category = cp.id_category AND
c.nleft >= 47
AND c.nright <= 48
AND p.quantity>0 AND c.active = 1)
WHERE 1 AND p.`active` = 1 AND p.id_product IN (SELECT pa.`id_product`
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute` AND pa.`quantity` > 0)WHERE pac.`id_attribute` = 44) GROUP BY id_product
Il y a
17
produits.
Découvrez notre gamme de Robes de plage femme de grande marque telle que Banana moon au meilleur prix !