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", "Wikipedia_sockpuppeteers","All_Wikipedia_bots", "Wikipedia_semi-protected_user_and_user_talk_pages","Wiki_Education_student_editors") 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 regexp "User_[a-zA-Z]{2,4}(-[12345N])?" and cl_to not regexp "WikiProject_.*_(members|participants)$" and page_title not like "%/%" and not exists (select 1 from categorylinks x join page y on x.cl_from=y.page_id where y.page_title = categorylinks.cl_to and x.cl_to like "%Wikipedian" or x.cl_to="Wikipedia_bots_by_status") limit 100;
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...