SELECT COUNT( DISTINCT p.`id_product` ) AS nb FROM `ps_area` c INNER JOIN `ps_area_product` pc ON (pc.`id_area` = c.`id_area` AND c.`id_area` IN (85)) INNER JOIN `ps_product` p ON (p.`id_product` = pc.`id_product`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) WHERE 1 AND p.`active` = 1