string(523) "SELECT COUNT(p.`id_product`) AS nb
FROM `pspf_product` p
INNER JOIN pspf_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE product_shop.`active` = 1
AND product_shop.`date_add` > "2021-03-21"
AND product_shop.`visibility` IN ("both", "catalog")
AND EXISTS(SELECT 1 FROM `pspf_category_product` cp
JOIN `pspf_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1)
WHERE cp.`id_product` = p.`id_product`)"
Nouveaux produits - PRADEL FRANCE
