Obsolete:Tool:Query service/7
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