Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
NPP Recruitment - Editors by experience >8k edits
by
MPGuy2824
This query is marked as a draft
This query has been published
by
MPGuy2824
.
Toggle Highlighting
SQL
SELECT user_id, user_name, user_editcount, user_registration FROM `user` JOIN actor_user on actor_user=user_id WHERE user_editcount > 4000 AND user_registration < date_add(now(), interval -90 day) -- registered more than 3 months back AND EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'extendedconfirmed') AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group in ( 'sysop', 'patroller', 'bot' )) AND NOT EXISTS (SELECT 1 FROM logging_logindex WHERE user_name = log_title AND log_namespace = 2 AND log_type = 'block' AND log_action = 'block') -- no blocks and user_name not in (select distinct actor_name from revision join page on rev_page=page_id join actor on actor_id=rev_actor where page_title="Requests_for_permissions/New_page_reviewer" and page_namespace=4 -- "Wikipedia:" namespace and rev_timestamp >= date_add(now(), interval -183 day) ) -- leave out users who have edited Wikipedia:Requests_for_permissions/New_page_reviewer in the past 6 months AND (SELECT COUNT(*) FROM revision_userindex JOIN page ON page_id = rev_page WHERE rev_actor = actor_id AND rev_timestamp >= date_add(now(), interval -30 day) AND page_namespace = 0 -- Mainspace, from [[WP:Namespaces]] LIMIT 301) >= 300 -- 300 mainspace edits in the last 30 days
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
.
Checking query status...