title: Not Counting Properly "signups"
body: <pre><code>select date_format(payout.date, '%m/%d/%Y') as Date,
      (select commission.PAYOUTID from commission
      where commission.status &lt;&gt; "reversed"
      and commission.payoutid = payout.payoutid
      group by commission.payoutid) 
      as PayoutID, 
  
      convert(payout.acctid,char) as Account,
      payout.total_amount as Commission,
  
     (select count(commission_tracker.CAMPAIGNID) as 'Signups' from 
     commission_tracker
     where commission_tracker.COMMISSIONTRACKERID = PayoutID) 
     as Signups,
  </code></pre>
  
  <ol>
  <li><p>this last nest above is where the issue is. It will not count
  properly.</p></li>
  <li><p>I cannot seem to get it to return the correct number of sign ups
  because of possibly formatting. </p></li>
  <li><p>any help would be appreciated</p>
  
  <pre><code>(select count(account.ACCTID) as 'Dupes' from account
     where account.type = 'customer_duplicate'
     and account.acctid = Signups) 
  as Dupes
  
  from payout
  where payout.payout_method = 'paypal'
  and payout.payout_status = 'processing'
  order by Commission desc
  </code></pre></li>
  </ol>