On Fri, Oct 9, 2015 at 1:26 PM, Neil P. Quinn nquinn@wikimedia.org wrote:
I'm trying to gather some stats on the use of Echo notifications across wikis, and I'd like to join the `echo_events` table with the `user` table for a given wiki.
I'm not sure what kind of information you need but there is a chance that they are captured via schema in which case you can get them from Echo schema in log database and then join that with enwiki.user. I'm also not sure what info you need from enwiki.user, you may be able to get more global info from centralauth.globaluser.
Leila
-- Neil P. Quinn https://meta.wikimedia.org/wiki/User:Neil_P._Quinn-WMF, product analyst Wikimedia Foundation
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics