CiviCRM Community Forums (archive)

Hi! I'm just wondering if somebody could help me figure out how to debug some count discrepancies I'm having.

In my email newsletter group, I have 115,000 subscribers. I see this count when I am in 'Contact group search'.

When I go to actually schedule a mailing, that number drops to 83,122. Where is this discrepancy happening? Also, when I try to export this group to a CSV I get the same 83,122 count.

I've checked a few things including running a simple SQL query:

SELECT DISTINCT(email.email), contact.first_name, contact.last_name
FROM civicrm_contact as contact
INNER JOIN civicrm_email as email ON email.contact_id = contact.id
INNER JOIN civicrm.civicrm_address as address ON address.contact_id = contact.id
INNER JOIN civicrm_group_contact as groups ON groups.contact_id = contact.id
WHERE groups.group_id = 2
AND contact.do_not_email = 0
AND contact.is_opt_out = 0

Just as a simple diagnostic, this comes back with just about that 110,000, which I assume is because of opt outs/unsubscribes?

But where can I get the other 20-30,000 emails that signed up for my list? Why can't I access them?

Thanks for helping me debug this!