SELECT count (DISTINCT p.id) FROM output_masterproducts p LEFT JOIN output_masterproducts_categories pc ON p.id=pc.master_id WHERE p.master_companyid=5830 and p.status>0 and p.live>0 and (pc.category_id=312) LIMIT 2