Obsolete:Tool:Query service/7

From Wikitech
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
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