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