High-traffic, unarchived talk pages

All talk pages with at least ten edits in recentchanges (ie the last 30 days) that don't transclude [[User:Cluebot III/ArchiveThis]] or [[User:MiszaBot/config]].

For [[WP:RAQ#High traffic talk pages]] circa 25 October 2023.

SQL

WITH freqs(f_page, f_title, f_editcount) AS
(
  SELECT rc_cur_id, page_title, COUNT(*)
  FROM recentchanges
  JOIN page ON page_id = rc_cur_id
  WHERE rc_namespace = 1
  GROUP BY rc_title
  HAVING COUNT(*) >= 10
)
SELECT CONCAT('https://en.wikipedia.org/w/index.php?redirect=no&title=Talk:', f_title) AS link, f_editcount
FROM freqs
LEFT JOIN templatelinks ON tl_from = f_page
LEFT JOIN linktarget ON lt_id = tl_target_id AND lt_namespace = 2 AND lt_title IN ('ClueBot_III/ArchiveThis', 'MiszaBot/config')
WHERE tl_from IS NULL
ORDER BY f_editcount DESC;

SQL

Checking query status...