User:SQL/Short Drafts

SELECT Concat("Draft:", page_title, "") "Article",

(SELECT Count(DISTINCT rev_user_text)

FROM revision

WHERE revision.rev_page = page.page_id) AS "Unique Editors",

page_len AS PageLength

FROM page

WHERE page_namespace = 118

AND page_len > 0

AND page_len < 450

AND page_is_redirect != 1

AND page_id NOT IN (SELECT el_from

FROM externallinks

WHERE page_id = el_from)

ORDER BY pagelength ASC;

Try it in quarry!