Jump to content

Wikipedia:Database reports/Bizarrely subnested userpages

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by JPxG (talk | contribs) at 10:28, 13 January 2023 (try this one out). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

This report contains every userspace page with more than ten slashes in its title, per https://quarry.wmcloud.org/query/61080 (there are some, but very few, pages in other namespaces).

SELECT page_namespace AS "ns", page_title AS "title", LENGTH(page_title) AS "title length", page_len AS "size"
FROM page WHERE page_title LIKE "%/%/%/%/%/%/%/%/%/%/%"
AND page_namespace = "2"
ORDER BY page_len ASC;

This table is generated by querying the database replica and is periodically updated by a bot.
Edits made within the table area will be removed on the next update!