scowiki users having over 625 edits, sorted by edit count

Fork of rowiki users having over 625 edits + all bots, sorted by edit count by MJL

This query is marked as a draft This query has been published by MJL.

This takes into account bots that don't have official bot status, but are nonetheless members of Categorie:Roboți Wikipedia. It also tells whether an account is an admin or a bot.

SQL

USE scowiki_p;
SELECT ss_total_edits FROM site_stats;
SELECT SUM(user_editcount) FROM user AS u
WHERE user_editcount >= 625;
SELECT *
FROM (
		SELECT user.user_id AS id, user.user_name AS name, user.user_editcount AS edits
  		FROM user
)
ORDER BY editcount DESC, userid;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...