Women's biographies written by Lugnuts

Fork of Women's biographies written 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. Limited to those very likely to violate [[WP:NOTDATABASE]]

SQL

SELECT DISTINCT(Article.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 ArticleCat.cl_from = Article.page_id
JOIN categorylinks AS TalkCat ON TalkCat.cl_from = Talk.page_id
WHERE rev_parent_id = 0
  AND Article.page_is_redirect = 0
  AND rev_actor = 482
  AND (ArticleCat.cl_to LIKE '%female%'
       OR ArticleCat.cl_to LIKE '%woman%'
       OR ArticleCat.cl_to LIKE '%women%')
  AND (TalkCat.cl_to LIKE '%iography%'
  AND Article.page_len < 2500)

SQL

Checking query status...