Wikipedia:WikiProject Wiki Loves Women/queries

USE enwiki_p; SELECT article.page_title, COUNT(*) AS edits FROM revision INNER JOIN page article ON    article.page_id = rev_page AND article.page_namespace = 0 INNER JOIN page talk ON    talk.page_title = article.page_title AND talk.page_namespace = 1 INNER JOIN categorylinks ON    cl_from = talk.page_id WHERE rev_timestamp < 20150101000000 AND cl_to = "High-importance_Wiki_Loves_Women_articles" GROUP BY article.page_id ORDER BY edits DESC LIMIT 20;

Link: https://quarry.wmflabs.org/query/15615 What: high importance article from Wiki Loves Women project, created before 01 january 2015

--

USE enwiki_p; SELECT article.page_title, COUNT(*) AS edits FROM revision INNER JOIN page article ON    article.page_id = rev_page AND article.page_namespace = 0 INNER JOIN page talk ON    talk.page_title = article.page_title AND talk.page_namespace = 1 INNER JOIN categorylinks ON    cl_from = talk.page_id WHERE rev_parent_id = 0 AND rev_timestamp > 20160315000000 AND cl_to = "High-importance_Wiki_Loves_Women_articles" GROUP BY article.page_id ORDER BY edits DESC LIMIT 20;

Link:https://quarry.wmflabs.org/query/15844 What: articles of High Importance Wiki Loves Women, created after 15 of March 2016