User:DWalden (WMF)/(Un)delete associated talk page/big page sql

Lists the top 10 pages with the most revisions/edits:

SELECT rev_page, page_title, page_namespace, COUNT(*) AS count
FROM revision
INNER JOIN page ON rev_page=page_id
GROUP BY rev_page
ORDER BY count DESC
LIMIT 10;