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