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

SQL

# Most edited Louisville area-related articles
SELECT COUNT(*) AS 'Edit Count', article.page_title AS 'Article', MAX(rev_len) AS 'Max Size (Bytes)', MIN(rev_len) AS 'Min Size (Bytes)', 
  SUBSTRING_INDEX(cl2.cl_to, "-", 1) AS 'Rating'
FROM page AS article
INNER JOIN page AS talk on article.page_title = talk.page_title 
INNER JOIN categorylinks AS cl1 ON cl1.cl_from = talk.page_id
INNER JOIN revision ON rev_page = article.page_id
LEFT JOIN categorylinks AS cl2 ON cl2.cl_from = talk.page_id
 AND cl2.cl_to REGEXP "^\\w+-Class_Louisville_articles$" -- substitute your project BASE category name for the rating
WHERE rev_timestamp > (NOW() - INTERVAL 30 DAY)
AND cl1.cl_to = 'WikiProject_Louisville_articles' -- substitute your project category of included articles, pages, etc.
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...
