You are browsing a read-only backup copy of Wikitech. The live site can be found at

Obsolete:Tool:Query service/7

From Wikitech-static
< Obsolete:Tool:Query service
Revision as of 19:10, 4 September 2021 by imported>Quiddity (fixes)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Short pages enwiki

Description List of short pages with a single author (excluding user pages and redirects)
Assignee Duesentrieb
JIRA bug DBQ-7
Source Query service/short pages enwiki#Query
Approximate run time not sure, perhaps an hour or so


SELECT CONCAT(ns_name, ':', page_title, ' - ', page_len)
FROM page
JOIN toolserver.namespace ON page_namespace = ns_id AND dbname = 'enwiki_p'
LEFT JOIN templatelinks ON tl_from = page_id
WHERE page_len < 50
AND page_is_redirect = 0
AND page_namespace NOT IN (2, 3)
AND tl_from IS NULL
AND (SELECT COUNT(DISTINCT rev_user_text) FROM revision WHERE rev_page = page_id) = 1
ORDER BY page_len ASC

This page was moved from toolserver:en:Query service/7. It's edit history can be viewed at Nova Resource:Tools/Tools/Query service/7/edithistory