- $this->selectAdd("
- (
- SELECT
- COUNT(DISTINCT(crm_person_id))
- FROM
- core_notify cn
- WHERE
- evtype = 'MAIL'
- AND
- person_table = 'crm_person'
- AND
- crm_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
- )
- +
- (
- SELECT
- COUNT(DISTINCT(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
- ");
-
- $this->selectAdd("
- (
- SELECT
- COUNT(DISTINCT(crm_person_id))
- FROM
- core_notify cn
- WHERE
- evtype = 'MAIL'
- AND
- person_table = 'crm_person'
- AND
- crm_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
- AND
- is_open = 1
- )
- +
- (
- SELECT
- COUNT(DISTINCT(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
- AND
- is_open = 1
- )
- AS opened_by_count
- ");
-
- $this->selectAdd("
- (
- SELECT
- MAX(sent)
- FROM
- core_notify cn
- WHERE
- evtype = 'MAIL'
- 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 last_sent
- ");