SELECT COUNT(p.`id_product`) AS nb
                    FROM `gf_product` p
                     INNER JOIN gf_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.`visibility` IN ("both", "catalog")
                     AND EXISTS(SELECT 1 FROM `gf_category_product` cp
            JOIN `gf_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1)
            WHERE cp.`id_product` = p.`id_product`)
                    ORDER BY product_shop.id_product DESC
                    LIMIT 16