Timeline for How do I find the mails belonging to a particular mailing by looking at the SQL tables?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 8, 2015 at 13:28 | comment | added | Xavier | yeap, but they all use indexes, so no big deal | |
| Jun 8, 2015 at 9:58 | comment | added | Mohit Agarwal | Using just the civicrm_mailing_recipients table, I get to know which email_ids belong to a particular mailing. But civicrm_mailing_event_delivered table does not contain the email ids, rather it stores information about event_queue_id. This means I would have to do join of 3 tables - civicrm_mailing_event_delivered, civicrm_mailing_recipients and civicrm_mailing_event_queue in order to find which all timestamps (of delivered mail) belong to a particular mailing. Am I right? | |
| Jun 8, 2015 at 2:28 | comment | added | petednz - fuzion♦ | just the row id for that table | |
| Jun 7, 2015 at 20:22 | comment | added | Mohit Agarwal | What does id refer to in that table? | |
| Jun 7, 2015 at 19:38 | history | answered | petednz - fuzion♦ | CC BY-SA 3.0 |