event_id > 0
AND
sent IS NOT NULL
- ) AS sent_to_count
+ )
+ +
+ (
+ SELECT
+ COUNT(DISTINCT(crm_person_id))
+ FROM
+ core_notify cn
+ WHERE
+ evtype = 'MAIL'
+ AND
+ person_table = 'Person'
+ AND
+ person_id != 0
+ AND
+ ontable = 'crm_mailing_list_queue'
+ AND
+ onid IN
+ (
+ SELECT
+ id
+ FROM
+ crm_mailing_list_queue cmlq
+ WHERE message_id = crm_mailing_list_message.id
+ )
+ AND
+ event_id > 0
+ AND
+ sent IS NOT NULL
+ )
+ AS sent_to_count
");
if (!empty($_REQUEST['_hide_system_emails'])) {