Fork of
largest talk pages
by JPxG
This query is marked as a draft
This query has been published
by JPxG.
SQL
AخA
SELECT page_title, page_len
#SELECT COUNT(*)
FROM page
WHERE page_namespace='5'
#0/1 main 2/3 user 4/5 wp 6/7 file 8/9 mw 10/11 template 12/13 help
# 14/15 cat 100/101 portal 118/119 draft 710/711 timedtext 828/829 module
# 2300/2301 gadget 2302/2303 g. definition -1 special -2 media
# AND page_title LIKE 'Articles_for_deletion/Log/%'
AND page_len > 75000
AND page_title LIKE 'Articles_for_deletion/%'
AND page_title NOT LIKE 'Articles_for_deletion/Archive_%'
ORDER BY page_len DESC LIMIT 1000;
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.