SELECT COUNT(DISTINCT products.pId) AS bar FROM products LEFT JOIN multisections ON products.pId=multisections.pId WHERE pDisplay<>0 AND (products.pSection IN (42) OR multisections.pSection IN (42))