Fork of
Untitled query #9059
by Le Deluge
This query is marked as a draft
This query has been published
by Xaosflux.
SQL
x
use enwiki_p;
SELECT
page_namespace,
CONVERT(page_title USING utf8)
FROM page
WHERE page_len = 0
AND page_namespace IN (5, 7, 9, 11, 12, 13, 15, 101, 108, 119, 109, 447, 710, 711, 829, 2301, 2302, 2303)
AND (SELECT
COUNT(DISTINCT rev_user_text)
FROM revision
WHERE rev_page = page_id) = 1
ORDER BY page_namespace, page_title
LIMIT 2000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.