Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Articles created primarily by Lugnuts
by
BilledMammal
This query is marked as a draft
This query has been published
by
BilledMammal
.
List of women's biographies written by Lugnuts, requested at Wikipedia talk:WikiProject Women in Red#Cricket players may be under threat
Toggle Highlighting
SQL
SELECT DISTINCT(page_title), rev_timestamp FROM revision_userindex JOIN page AS Article ON Article.page_id = rev_page AND Article.page_namespace = 0 JOIN page AS Talk ON Article.page_title = Talk.page_title AND Talk.page_namespace = 1 JOIN categorylinks AS ArticleCat ON cl_from = Article.page_id JOIN categorylinks AS TalkCat ON cl_from = Talk.page_id WHERE rev_parent_id = 0 AND page_is_redirect = 0 AND rev_actor = 482 AND page_namespace = 0 AND (ArticleCat.cl_to LIKE '%female%' OR ArticleCat.cl_to LIKE '%woman%' OR ArticleCat.cl_to LIKE '%women%') AND (TalkCat.cl_to LIKE '%iography%')
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...