At MPOW we use a blog to help us communicate with our users. We’ve affectionately called our blog “The ORB” following a successful naming competition that we held earlier in the year.
An integral part of the blog is the Subscribe2 plugin. I think I can safely say that without this plugin our blog would not have gotten past the planning stage. This is primarily because we migrated away from an email list to the blog platform and needed a way to continue this mailing list functionality.
This morning I needed to find out which categories a specific user had subscribed to in order to recieve email updates. The SQL I used is as follows.
SELECT wpt.name
FROM wp_terms wpt
WHERE term_id IN (
SELECT wpum.meta_value
FROM wp_users wpu, wp_usermeta wpum
WHERE wpu.user_login = 'USER'
AND wpu.id = wpum.user_id
AND wpum.meta_key LIKE 's2_cat%' )
ORDER BY wpt.name
Replace USER with the code above with the user name of the user you are investigating
