Column 'id_product' in field list is ambiguous
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` = 1)
WHERE `active` = 1
AND pl.`id_lang` = 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
)