On Wed, Mar 22, 2017 at 3:44 PM, Federico Leva (Nemo) <[email protected]> wrote:
> Andre Klapper, 22/03/2017 13:51: > >> Does anyone know of a way to look up the top editors for a certain >> namespace (like "Module") across all Wikimedia sites? >> > > The easiest way is usually to run the relevant SELECT queries with a small > bash script on Labs or with sql.php on tin (e.g. > https://phabricator.wikimedia.org/T128326#3100126 ). > I would discourage running long running scripts into production (tin is reserved for that)- we have special analytics slaves for that. However, probably those stats do not require access to private data. A query like: use <wiki you are interested in>; SELECT rev_user_text, count(*) as count FROM revision JOIN page ON rev_page = page_id and page_namespace=<desired numeric namespace> GROUP BY rev_user_text ORDER BY count(*) DESC LIMIT <number of top users>; (maybe revision_userindex instead of revision?) ...on labs would work (this is by heart, it may have mistakes) If it is a large wiki or there is a lot of edits, that may not finish- so you may have to do the analysis in small chunks and the aggregate results. Maybe someone has pre-crunched stats if you need it faster? -- Jaime Crespo <http://wikimedia.org>
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
