User:Topbanana/Eponymous edits
Appearance
Below are listed the articles that have been most edited by a user with the same name as the article. Such patterns of editing are unusual, and may warrant the addition of a conflict of interest template {{Template:COI}} or Autobiography template {{Template:Autobiography}}. Updated by TB (talk) 12:51, 13 February 2013 (UTC)
- Banff_Springs has been edited by User:Banff_Springs 2 times (of 2 = 100.000%)
- Hohenloh has been edited by User:Hohenloh 3 times (of 3 = 100.000%)
- The_X_Child-Factor_UK has been edited by User:The_X_Child-Factor_UK 61 times (of 61 = 100.000%)
- Anthony_Branker has been edited by User:Anthony_Branker 86 times (of 92 = 93.500%)
- Ringbang has been edited by User:Ringbang 11 times (of 12 = 91.700%)
- Sahakian has been edited by User:Sahakian 47 times (of 53 = 88.700%)
- Olaide_Olaogun has been edited by User:Olaide_Olaogun 88 times (of 102 = 86.300%)
- Catt_Gravitt has been edited by User:Catt_Gravitt 208 times (of 242 = 86.000%)
- Ibbu_Village,_Namibia has been edited by User:Ibbu_Village,_Namibia 29 times (of 34 = 85.300%)
- Canton_Viaduct has been edited by User:Canton_Viaduct 3286 times (of 3920 = 83.800%)
- Wicked_Funny_Comedy_Tour has been edited by User:Wicked_Funny_Comedy_Tour 20 times (of 24 = 83.300%) (has COI template)
- Anthony_Mazzella has been edited by User:Anthony_Mazzella 13 times (of 16 = 81.300%)
- Graham_Reilly has been edited by User:Graham_Reilly 91 times (of 117 = 77.800%)
- Parcom has been edited by User:Parcom 31 times (of 40 = 77.500%)
- Anggabaya has been edited by User:Anggabaya 33 times (of 43 = 76.700%)
- The_Speaker's_House has been edited by User:The_Speaker's_House 254 times (of 335 = 75.800%) (has COI template)
- Thermomass has been edited by User:Thermomass 43 times (of 57 = 75.400%)
- Narmada_Ahuja has been edited by User:Narmada_Ahuja 12 times (of 16 = 75.000%)
- Rukhaiyar has been edited by User:Rukhaiyar 15 times (of 20 = 75.000%)
- Waldir has been edited by User:Waldir 3 times (of 4 = 75.000%)
- Boriswood has been edited by User:Boriswood 47 times (of 63 = 74.600%)
- College_of_Micronesia-FSM has been edited by User:College_of_Micronesia-FSM 103 times (of 139 = 74.100%)
- Retignano has been edited by User:Retignano 16 times (of 22 = 72.700%)
- Steven_Ybarra has been edited by User:Steven_Ybarra 76 times (of 105 = 72.400%) (has COI template) (has autobiography template)
- Goldenwest_Credit_Union has been edited by User:Goldenwest_Credit_Union 10 times (of 14 = 71.400%)
- Angelo_B_Landers has been edited by User:Angelo_B_Landers 31 times (of 44 = 70.500%)
- Community_Greens has been edited by User:Community_Greens 19 times (of 27 = 70.400%)
- Turn2us has been edited by User:Turn2us 33 times (of 47 = 70.200%) (has COI template)
- Nartopa has been edited by User:Nartopa 270 times (of 386 = 69.900%)
- Tenmei has been edited by User:Tenmei 78 times (of 112 = 69.600%)
- Kalri_Jagir has been edited by User:Kalri_Jagir 66 times (of 95 = 69.500%)
- Martino_Traversa has been edited by User:Martino_Traversa 17 times (of 25 = 68.000%)
- Hajvalia has been edited by User:Hajvalia 17 times (of 25 = 68.000%)
- Kenges_Rakishev has been edited by User:Kenges_Rakishev 50 times (of 74 = 67.600%)
- Serocee has been edited by User:Serocee 23 times (of 34 = 67.600%)
- Jemez_State_Monument has been edited by User:Jemez_State_Monument 72 times (of 108 = 66.700%)
- Arcot_Narrainsawmy_Mudaliar has been edited by User:Arcot_Narrainsawmy_Mudaliar 78 times (of 117 = 66.700%)
- Vilkupe has been edited by User:Vilkupe 8 times (of 12 = 66.700%)
- Zurella has been edited by User:Zurella 6 times (of 9 = 66.700%)
- Thadou has been edited by User:Thadou 52 times (of 80 = 65.000%)
- Anna_Suvorova has been edited by User:Anna_Suvorova 46 times (of 71 = 64.800%) (has autobiography template)
- Tony_Longworth has been edited by User:Tony_Longworth 21 times (of 33 = 63.600%)
- Projectline has been edited by User:Projectline 19 times (of 30 = 63.300%) (has COI template)
- Marina_Faust has been edited by User:Marina_Faust 67 times (of 106 = 63.200%)
- Invisible-Exports has been edited by User:Invisible-Exports 17 times (of 27 = 63.000%)
- Akazai has been edited by User:Akazai 179 times (of 285 = 62.800%)
- JaMiss has been edited by User:JaMiss 15 times (of 24 = 62.500%)
- Decltype has been edited by User:Decltype 38 times (of 61 = 62.300%)
- Paudel has been edited by User:Paudel 298 times (of 480 = 62.100%)
- Eli_Todd has been edited by User:Eli_Todd 92 times (of 149 = 61.700%)
- Jyoshna has been edited by User:Jyoshna 24 times (of 39 = 61.500%)
- Pantene_Beautiful_Lengths has been edited by User:Pantene_Beautiful_Lengths 40 times (of 65 = 61.500%) (has COI template)
- Night_Tracks has been edited by User:Night_Tracks 98 times (of 162 = 60.500%)
- Mihalko has been edited by User:Mihalko 29 times (of 48 = 60.400%)
- Saman_Kelegama has been edited by User:Saman_Kelegama 32 times (of 53 = 60.400%)
- Mário_Franco has been edited by User:Mário_Franco 38 times (of 63 = 60.300%) (has autobiography template)
- Kusunose has been edited by User:Kusunose 3 times (of 5 = 60.000%)
- Bennelongia has been edited by User:Bennelongia 3 times (of 5 = 60.000%)
- Malangali has been edited by User:Malangali 3 times (of 5 = 60.000%)
- Pcmicro has been edited by User:Pcmicro 12 times (of 20 = 60.000%)
- Tatiana_Belokonenko has been edited by User:Tatiana_Belokonenko 17 times (of 29 = 58.600%)
- Embassy_of_Israel,_Kathmandu has been edited by User:Embassy_of_Israel,_Kathmandu 68 times (of 117 = 58.100%)
- The_Blue_Card has been edited by User:The_Blue_Card 37 times (of 64 = 57.800%)
- Bandurist has been edited by User:Bandurist 41 times (of 71 = 57.700%)
- Artacoana has been edited by User:Artacoana 15 times (of 26 = 57.700%)
- Kanesue has been edited by User:Kanesue 42 times (of 73 = 57.500%) (has COI template)
- Archiguille has been edited by User:Archiguille 93 times (of 162 = 57.400%)
- Teisho has been edited by User:Teisho 8 times (of 14 = 57.100%)
- Leeson_House has been edited by User:Leeson_House 44 times (of 77 = 57.100%)
- Eugene_Ankomah has been edited by User:Eugene_Ankomah 367 times (of 657 = 55.900%) (has COI template)
- Hemant_Joshi has been edited by User:Hemant_Joshi 31 times (of 56 = 55.400%) (has autobiography template)
- Jonas_Poole has been edited by User:Jonas_Poole 41 times (of 74 = 55.400%)
- Kittybrewster has been edited by User:Kittybrewster 37 times (of 67 = 55.200%)
- Wild_Light has been edited by User:Wild_Light 34 times (of 62 = 54.800%)
- Burnside_library has been edited by User:Burnside_library 35 times (of 64 = 54.700%)
- Aux_Manir has been edited by User:Aux_Manir 36 times (of 67 = 53.700%)
- Harry_Shoemaker has been edited by User:Harry_Shoemaker 37 times (of 69 = 53.600%) (has COI template)
- Paul_Hoover has been edited by User:Paul_Hoover 39 times (of 73 = 53.400%) (has autobiography template)
- Ebelthite has been edited by User:Ebelthite 40 times (of 75 = 53.300%)
- Monroe_County_Public_Library has been edited by User:Monroe_County_Public_Library 18 times (of 34 = 52.900%) (has COI template)
- Kutar has been edited by User:Kutar 72 times (of 137 = 52.600%)
- Bernard_Hibbitts has been edited by User:Bernard_Hibbitts 24 times (of 46 = 52.200%) (has autobiography template)
- Tihawali has been edited by User:Tihawali 12 times (of 23 = 52.200%)
- Douglas_R._White has been edited by User:Douglas_R._White 76 times (of 147 = 51.700%)
- Karol_Siroky has been edited by User:Karol_Siroky 43 times (of 84 = 51.200%) (has autobiography template)
- Peter_Kosminsky has been edited by User:Peter_Kosminsky 138 times (of 271 = 50.900%)
- Talskiddy has been edited by User:Talskiddy 30 times (of 59 = 50.800%)
- Haman_Alimardani has been edited by User:Haman_Alimardani 37 times (of 74 = 50.000%) (has COI template)
- Sindh_Archives has been edited by User:Sindh_Archives 8 times (of 16 = 50.000%)
- Broletto has been edited by User:Broletto 5 times (of 10 = 50.000%)
- Kmicic has been edited by User:Kmicic 1 times (of 2 = 50.000%)
- Mehlawat has been edited by User:Mehlawat 3 times (of 6 = 50.000%)
- Uruit has been edited by User:Uruit 6 times (of 12 = 50.000%)
- Frontenac_House has been edited by User:Frontenac_House 14 times (of 28 = 50.000%) (has COI template)
- Rajoka has been edited by User:Rajoka 3 times (of 6 = 50.000%)
- Naserke has been edited by User:Naserke 19 times (of 38 = 50.000%)
- James_Britt has been edited by User:James_Britt 2 times (of 4 = 50.000%)
- Urapar has been edited by User:Urapar 87 times (of 175 = 49.700%)
- Chunchucmil has been edited by User:Chunchucmil 225 times (of 455 = 49.500%)
- Dadehar has been edited by User:Dadehar 27 times (of 55 = 49.100%)
- Terrasidius has been edited by User:Terrasidius 19 times (of 39 = 48.700%)
- Kukini has been edited by User:Kukini 33 times (of 68 = 48.500%)
- Ben_Manilla has been edited by User:Ben_Manilla 32 times (of 66 = 48.500%) (has autobiography template)
- Heliocybe has been edited by User:Heliocybe 15 times (of 31 = 48.400%)
- OrthoCor has been edited by User:OrthoCor 24 times (of 51 = 47.100%)
- Rowlan has been edited by User:Rowlan 33 times (of 70 = 47.100%)
- Fakhar_Zaman has been edited by User:Fakhar_Zaman 30 times (of 64 = 46.900%) (has autobiography template)
- Apuldram has been edited by User:Apuldram 46 times (of 98 = 46.900%)
- Pecopteris has been edited by User:Pecopteris 28 times (of 60 = 46.700%)
- Extraordinary_Machine has been edited by User:Extraordinary_Machine 333 times (of 716 = 46.500%)
- Cristian_Milea has been edited by User:Cristian_Milea 39 times (of 84 = 46.400%)
- Shrikrishan_Sharma has been edited by User:Shrikrishan_Sharma 26 times (of 56 = 46.400%)
- Borok has been edited by User:Borok 6 times (of 13 = 46.200%)
- Lleifior has been edited by User:Lleifior 6 times (of 13 = 46.200%)
- Michael_Atherton has been edited by User:Michael_Atherton 17 times (of 37 = 45.900%)
- Oman_Botanic_Garden has been edited by User:Oman_Botanic_Garden 11 times (of 24 = 45.800%)
- Reinhard_Hartmann has been edited by User:Reinhard_Hartmann 26 times (of 57 = 45.600%) (has autobiography template)
- Mamiboys has been edited by User:Mamiboys 67 times (of 147 = 45.600%)
- Mark_de_Solla_Price has been edited by User:Mark_de_Solla_Price 22 times (of 49 = 44.900%) (has autobiography template)
- Subhasish_Dey has been edited by User:Subhasish_Dey 53 times (of 118 = 44.900%) (has COI template)
- Mathsci has been edited by User:Mathsci 4 times (of 9 = 44.400%)
- Vatsun has been edited by User:Vatsun 8 times (of 18 = 44.400%)
- Harnad has been edited by User:Harnad 4 times (of 9 = 44.400%)
- Wave_Music has been edited by User:Wave_Music 8 times (of 18 = 44.400%)
- Jeremy_Broun has been edited by User:Jeremy_Broun 41 times (of 95 = 43.200%)
- Dingfelder has been edited by User:Dingfelder 19 times (of 44 = 43.200%)
- Alan_Pascoe has been edited by User:Alan_Pascoe 54 times (of 125 = 43.200%)
- Miss_China_United_Kingdom_Pageant has been edited by User:Miss_China_United_Kingdom_Pageant 27 times (of 64 = 42.200%)
- Abol_Hussein_Tanhai has been edited by User:Abol_Hussein_Tanhai 8 times (of 19 = 42.100%)
- Torchomatic has been edited by User:Torchomatic 8 times (of 19 = 42.100%)
- RMISERY has been edited by User:RMISERY 80 times (of 191 = 41.900%)
- Charles_G._Irion has been edited by User:Charles_G._Irion 38 times (of 91 = 41.800%) (has COI template) (has autobiography template)
- Rufous-crowned_Sparrow has been edited by User:Rufous-crowned_Sparrow 154 times (of 368 = 41.800%)
- Saskatchewan_Festival_of_Words has been edited by User:Saskatchewan_Festival_of_Words 10 times (of 24 = 41.700%) (has COI template)
- Nicholas_Doumanis has been edited by User:Nicholas_Doumanis 10 times (of 24 = 41.700%)
- Dooniver has been edited by User:Dooniver 54 times (of 130 = 41.500%)
- Marsha_Skrypuch has been edited by User:Marsha_Skrypuch 42 times (of 102 = 41.200%) (has COI template)
- Bamakhrama has been edited by User:Bamakhrama 9 times (of 22 = 40.900%)
- Michael_Fourman has been edited by User:Michael_Fourman 36 times (of 88 = 40.900%) (has autobiography template)
- Enda_Caldwell has been edited by User:Enda_Caldwell 79 times (of 193 = 40.900%) (has autobiography template)
- Orjen has been edited by User:Orjen 96 times (of 235 = 40.900%)
- Kalirai has been edited by User:Kalirai 87 times (of 214 = 40.700%)
- Tabakalera has been edited by User:Tabakalera 21 times (of 52 = 40.400%)
- Significant_symbols has been edited by User:Significant_symbols 31 times (of 77 = 40.300%)
Regenerating this report
[edit]-- Eponymous articles
DROP TABLE coi;
CREATE TABLE u_tb.coi
AS SELECT /* SLOW_OK*/ p1.page_id, p1.page_title, 0 as 'edits', 0 as 'selfedits', 0.000 as 'ratio', false as 'coitemplate', false as 'abtemplate'
FROM enwiki_p.page p1
INNER JOIN enwiki_p.page p2 ON p1.page_namespace = 0 AND p2.page_namespace = 2 and p1.page_title = p2.page_title
WHERE NOT p1.page_is_redirect;
UPDATE u_tb.coi
SET selfedits = (
SELECT /* SLOW_OK */ count(*)
FROM enwiki_p.revision
WHERE rev_page = page_id
AND rev_user_text = replace( page_title, '_', ' ') );
DELETE FROM u_tb.coi WHERE selfedits = 0;
UPDATE u_tb.coi
SET edits = (
SELECT /* SLOW_OK */ count(*)
FROM enwiki_p.revision
WHERE rev_page = page_id );
UPDATE u_tb.coi
SET ratio = selfedits / edits;
-- Identify pages that transclude Template:COI
UPDATE coi
SET coitemplate=true
WHERE EXISTS (
SELECT 1
FROM enwiki_p.templatelinks
WHERE tl_from = page_id
AND tl_namespace = 10
AND tl_title = 'COI' );
UPDATE coi
SET abtemplate=true
WHERE EXISTS (
SELECT 1
FROM enwiki_p.templatelinks
WHERE tl_from = page_id
AND tl_namespace = 10
AND tl_title = 'Autobiography' );
-- And report
SELECT concat( '#[[', page_title, ']] has been edited by [[User:', page_title, ']] ', selfedits, ' times (of ', edits, ' = ', ratio*100, '%)',
if( coitemplate, ' (has COI template)', '' ), if( abtemplate, ' (has autobiography template)', '' ) )
FROM coi
WHERE ratio > 0.4
ORDER BY ratio DESC;