Obsolete:Tool:Query service/7

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

This page contains historical information. It may be outdated or unreliable.

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
Results	http://tools.wikimedia.de/~daniel/misc/shortpages-enwiki.txt
Approximate run time	not sure, perhaps an hour or so
Interval

Query

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