SELECT COUNT(`id_product`) AS nb FROM `linear_product` p LEFT JOIN `linear_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2) WHERE `active` = 1 AND `sel_new` >0 /*AND DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 30 DAY)) > 0*/ AND p.`id_product` IN ( SELECT cp.`id_product` FROM `linear_category_group` cg LEFT JOIN `linear_category_product` cp ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = 1 )