title: 2 COUNT queries multiplying results
body: <p>I am trying to execute two COUNT statements across 3 joins. The first Count shows the correct number but the second one seems to multiply the counts together for some reason? I checked the link which was marked as duplicate but that example doesn't have any JOINS in it.</p>
  
  <pre><code>SELECT
      COUNT(DISTINCT `outlet_id`) AS `outlets`,
      `prod_name`,
      COUNT(`purchased`) AS `vouchersleft`
  FROM
      `prod_outlets` AS `po`
  INNER JOIN `bb_products` AS `bbp` ON po.`product_id` = bbp.`prod_id`
  INNER JOIN `vouchers` AS `v` ON v.`product_id` = bbp.`prod_id`
  GROUP BY
      bbp.`prod_id`;
  </code></pre>
  
  <p>What it should display is 3 branches and 5 vouchers. But it is outputting 3 branches and 15 vouchers. So, the second COUNT is multiplying by the first i.e.: 3 x 5 = 15</p>