User:SQL/Zero-Length Drafts

About edit

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!

The List edit

Article Unique Editors
draft:2015_Donegal_Senior_Football_Championship 16
draft:2016_Donegal_Senior_Football_Championship 20
draft:2017_Donegal_Senior_Football_Championship 33
draft:2018–19_Northern_Counties_East_League 1
draft:Abdulaleem_Hanoun 1
draft:About_Addiction 2
draft:Ali_Srour 3
draft:Allan_Banford 1
draft:Amir_Yoosef_Sfn 4
draft:Art_X_Lagos 1
draft:Astrobiology_Network_of_Pakistan_(ABNP) 1
draft:Bekir_Brunčević 8
draft:CHILDREN_OF_THE_NIGHT 2
draft:Call_of_Minecraftia:_Ender_Eye_Warfare 1
draft:Call_of_Minecraftia:_Ender_Eye_Warfare_2 1
draft:Charlotte_Fall_Fanning 2
draft:Colin_Singer 1
draft:Cork_City_Railways 1
draft:Cryptology 2
draft:David_Shannon_(Canada) 3
draft:Dolbeault-Grothendieck_lemma 3
draft:Donnie_O'_Turner 1
draft:Elton_Engstrom 6
draft:Eric_Slick 4
draft:Geet_Gambhir 5
draft:Gucci_boy_Chico 1
draft:Inanimate_Insanity 2
draft:Institute_of_creative_excellence 14
draft:Jack_Daus 1
draft:June_Duncan_Owen 4
draft:K_L_Adinarayana 1
draft:Kailash_Claughton-Smith 2
draft:Kushagra 2
draft:List_of_Rivers_and_Canals_by_Alphabetical_order 4
draft:List_of_hospitals_in_Australia 2
draft:Liste_der_Erinnerungsbänder_in_Augsburg 1
draft:Machiel_Eggink 2
draft:Manchiki_Maro_Peru 6
draft:Marie-Anne_catterall 2
draft:Max_Kibardin 9
draft:NaveenChowdary 2
draft:Nelson_Broms 2
draft:NewYork_Worlds 4
draft:Nikolas_Baier 3
draft:Protosun 4
draft:Pusat_Latihan_Tenaga_Pengajar 2
draft:Rashad_Nabiyev 5
draft:Road_signs_in_Cambodia 1
draft:Rouge_Fashionbook 1
draft:Sarveshshashi 3
draft:SelfEARTH 2
draft:Sheetal_Agashe 3
draft:Spotinst 3
draft:TEKT 1
draft:Terry_McGovern 2
draft:Valery_Milev 3
draft:Vietnam_national_under-21_football_team 9
draft:Véritables_Préludes_flasques_(pour_un_chien) 2
draft:Zeeshan_Shafiq 2
draft:Zeljko_Filip_Engelman_(2) 5
draft:Андрија_из_Константинопоља 1