Unusual edit distribution

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

SQL

SELECT
	user.user_id,
	user.user_name,
    user.user_editcount
FROM user
WHERE user.user_editcount >= 500
AND user.user_id NOT IN (SELECT DISTINCT filtered_users.user_id
                         FROM (SELECT user.user_id FROM user WHERE user.user_editcount >= 500) AS filtered_users
                         JOIN actor ON filtered_users.user_id = actor.actor_user
                         JOIN revision_userindex ON revision_userindex.rev_actor = actor.actor_id
                         JOIN page ON revision_userindex.rev_page = page.page_id
                         WHERE page.page_namespace NOT IN (2,3))
LIMIT 1000000;

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...