Skip to content

Instantly share code, notes, and snippets.

@rjaeckel

rjaeckel/oc-userstat.sql

Created November 21, 2014 10:15
Show Gist options
  • Save rjaeckel/1aef3bfc036d6636ab02 to your computer and use it in GitHub Desktop.
Save rjaeckel/1aef3bfc036d6636ab02 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
oc-userstat.sql
SELECT Distinct a.configvalue, from_unixtime( b.configvalue ) FROM oc_preferences a
inner join oc_preferences b on b.userid=a.userid and b.configkey="lastLogin"
where a.configkey="email";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment