High-traffic, unarchived talk pages

This query is marked as a draft This query has been published by Cryptic.

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;

AخA
 
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_editcountFROM freqsLEFT JOIN templatelinks ON tl_from = f_pageLEFT 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 NULLORDER BY f_editcount DESC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...