100 most edited Louisville area-related articles over past 30 days

The SQL uses your project's category of included articles/pages, esp. useful for cases where the project template doesn't directly indicate the project involved.

SQL

# Most edited Louisville area-related articles
SELECT COUNT(*) AS 'Edit Count', article.page_title AS 'Article'
FROM page AS article
INNER JOIN page AS talk on article.page_title = talk.page_title 
INNER JOIN categorylinks ON cl_from = talk.page_id
INNER JOIN revision ON rev_page = article.page_id
WHERE rev_timestamp > (NOW() - INTERVAL 30 DAY)
AND cl_to = 'WikiProject_Louisville_articles'
AND article.page_namespace = 0
AND talk.page_namespace = 1
GROUP BY article.page_title
ORDER BY COUNT(*) DESC
LIMIT 100;

SQL

Checking query status...