Untitled query #3009

SQL

USE ptwiki_p;
SELECT page_namespace, page_title, edits
FROM (
  SELECT 
      rev_page AS page_id, 
      COUNT(*) as edits
  FROM revision
  WHERE rev_timestamp BETWEEN "20140301" AND "20150301"
  GROUP BY rev_page
  ORDER BY edits DESC
  LIMIT 50
) AS page_edits
INNER JOIN page USING(page_id)
ORDER BY edits DESC, page_title ASC;

USE enwiki_p;
SELECT page_namespace, page_title, edits
FROM (
  SELECT 
      rev_page AS page_id, 
      COUNT(*) as edits
  FROM revision
  WHERE rev_timestamp BETWEEN "20140301" AND "20150301"
  GROUP BY rev_page
  ORDER BY edits DESC
  LIMIT 50
) AS page_edits
INNER JOIN page USING(page_id)
ORDER BY edits DESC, page_title ASC;
SQL

Checking query status...
