Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Pppery
.
Toggle Highlighting
SQL
select cl_to,concat("User:",page_title) from categorylinks join page on page_id=cl_from where page_namespace=2 and cl_to not in ("Noindexed_pages","Redirects_from_moves","Wikipedia_alternative_accounts", "Users_tagged_as_sockpuppets_with_no_second_parameter","Pages_with_disallowed_DISPLAYTITLE_modifications", "Userboxes_with_insufficient_color_contrast","Wikipedia_sockpuppeteers","All_Wikipedia_bots", "Wikipedia_semi-protected_user_and_user_talk_pages","Wiki_Education_student_editors") and cl_to not like "Userspace_drafts_from%" and cl_to not like "Wikipedia_sockpuppets%" and cl_to not like "Suspected_Wikipedia_sockpuppets%" and cl_to not like "%Wikipedian%" and cl_to not like "%AfC_submissions%" and cl_to not regexp "User_[a-zA-Z]{2,4}(-[12345N])?" and cl_to not regexp "WikiProject_.*_(members|participants)$" and not exists (select 1 from categorylinks where cl_from=page_title and cl_to in ("Wikipedians_by_Wikipedia_user_access_level","Wikipedians_by_Wikipedia_activity limit 10000;
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...