Fork of
High-traffic, unarchived talk pages
by Cryptic
This query is marked as a draft
This query has been published
by Cryptic.
SQL
AخA
SELECT CONCAT('Talk:', REPLACE(page_title, '_', ' ')) AS pagename, page_len
FROM page AS talk
LEFT JOIN templatelinks ON tl_from = page_id
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
AND page_namespace = 1
AND page_len >= 50000
AND EXISTS (SELECT 1 FROM page AS article WHERE article.page_namespace=0 AND article.page_title=talk.page_title)
ORDER BY page_len DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.