User:SQL/Zero-Length Drafts#The List

SELECT Concat("draft:", page_title, "" ) "Article", (SELECT Count(DISTINCT rev_user_text)

FROM

revision

WHERE

revision.rev_page = page.page_id) "Unique Editors"

FROM page

WHERE page_namespace = 118

AND page_len = 0;

Try it in quarry!