Projet:Wiki Loves Women/Requêtes

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
WERE 
   rev_timestamp < 20150101000000
   AND cl_to = "High-importance_Wiki_Loves_Women_articles"
GROUP BY article.page_id
ORDER BY edits DESC
LIMIT 20;

Lien: 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;

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