{"id":831,"date":"2013-05-07T11:34:30","date_gmt":"2013-05-07T15:34:30","guid":{"rendered":"http:\/\/blog.uvm.edu\/ctl-projects\/?p=509"},"modified":"2013-05-07T11:34:30","modified_gmt":"2013-05-07T15:34:30","slug":"emails-for-recent-event-attendees","status":"publish","type":"post","link":"https:\/\/blog.uvm.edu\/waw\/2013\/05\/07\/emails-for-recent-event-attendees\/","title":{"rendered":"Emails for recent event attendees"},"content":{"rendered":"

I was tasked to produce a list of unique email addresses of CTL event attendees for events held Spring 2013.<\/p>\n

Short answer:<\/p>\n

select distinct first_name,last_name,email \u00a0from users left join enrollments on enrollments.user_id=users.id left join events on enrollments.event_id=events.id left join event_types on event_types.event_id=events.id left join types on types.id=event_types.`type_id` left join event_sponsors on event_sponsors.event_id=events.id left join sponsors on sponsors.id=event_sponsors.`sponsor_id` \u00a0\u00a0\u00a0where events.start_day>’2012-12-31′ and is_facilitating=0 and (sponsors.sponsor IS NULL or sponsors.sponsor != “Writing in the Disciplines”) order by last_name<\/p>\n

Long answer:<\/p>\n

https:\/\/www.uvm.edu\/~waw\/php\/recent_event_attendees.php<\/a><\/p>\n

Notes:<\/p>\n

    \n
  1. No need to tag events: just need to filter start day where events.start_day>’2012-12-31′<\/li>\n
  2. Some small effort was made to filter by sponsor (CTL, WID, etc.); however, sponsor was not specified for many events<\/li>\n
  3. No effort was made to sponsor by event type (workshop, book group, etc.) as event type was not specified for many events<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    I was tasked to produce a list of unique email addresses of CTL event attendees for events held Spring 2013. Short answer: select distinct first_name,last_name,email \u00a0from users left join enrollments on enrollments.user_id=users.id left join events on enrollments.event_id=events.id left join event_types … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41826],"tags":[42758,542],"class_list":["post-831","post","type-post","status-publish","format-standard","hentry","category-wes","tag-boffins","tag-events"],"_links":{"self":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/831","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/comments?post=831"}],"version-history":[{"count":0,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/831\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/media?parent=831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/categories?post=831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/tags?post=831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}