Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Nettrom
.
https://en.wikipedia.org/wiki/Wikipedia:Talk_page_guidelines#When_to_archive_pages suggests talk pages should be archived when they exceed 75KB in size. We currently do not post suggestions to users with pages > 1MB. What if we were to lower that?
Toggle Highlighting
SQL
USE enwiki_p; SELECT count(*) FROM page JOIN templatelinks ON page_id=tl_from WHERE tl_title IN ('SuggestBot/userbox', 'SuggestBot/config') -- SuggestBot's templates AND tl_namespace = 2 -- Both templates are in user-space AND page_namespace IN (2, 3) -- Links from either User or User talk. AND page_title NOT LIKE 'SuggestBot%' -- Nothing in SuggestBot's own user space AND page_len > 250000 -- Above limit
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
.
Checking query status...