Skip to content

Instantly share code, notes, and snippets.

@gthayer

gthayer/Stream SQL query

Created October 6, 2016 15:22
Show Gist options
  • Save gthayer/9071b3226e4a5faa89df973c8c43e7f0 to your computer and use it in GitHub Desktop.
Save gthayer/9071b3226e4a5faa89df973c8c43e7f0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Stream SQL query
SELECT *
FROM `wp_stream`
LEFT JOIN `wp_usermeta`
ON wp_stream.user_id=wp_usermeta.user_id
WHERE wp_stream.action LIKE "login"
AND wp_usermeta.meta_key LIKE '%wp_capabilities%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment