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