User:Topbanana/Eponymous edits

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)



  1. Banff_Springs has been edited by User:Banff_Springs 2 times (of 2 = 100.000%)
  2. Hohenloh has been edited by User:Hohenloh 3 times (of 3 = 100.000%)
  3. The_X_Child-Factor_UK has been edited by User:The_X_Child-Factor_UK 61 times (of 61 = 100.000%)
  4. Anthony_Branker has been edited by User:Anthony_Branker 86 times (of 92 = 93.500%)
  5. Ringbang has been edited by User:Ringbang 11 times (of 12 = 91.700%)
  6. Sahakian has been edited by User:Sahakian 47 times (of 53 = 88.700%)
  7. Olaide_Olaogun has been edited by User:Olaide_Olaogun 88 times (of 102 = 86.300%)
  8. Catt_Gravitt has been edited by User:Catt_Gravitt 208 times (of 242 = 86.000%)
  9. Ibbu_Village,_Namibia has been edited by User:Ibbu_Village,_Namibia 29 times (of 34 = 85.300%)
  10. Canton_Viaduct has been edited by User:Canton_Viaduct 3286 times (of 3920 = 83.800%)
  11. Wicked_Funny_Comedy_Tour has been edited by User:Wicked_Funny_Comedy_Tour 20 times (of 24 = 83.300%) (has COI template)
  12. Anthony_Mazzella has been edited by User:Anthony_Mazzella 13 times (of 16 = 81.300%)
  13. Graham_Reilly has been edited by User:Graham_Reilly 91 times (of 117 = 77.800%)
  14. Parcom has been edited by User:Parcom 31 times (of 40 = 77.500%)
  15. Anggabaya has been edited by User:Anggabaya 33 times (of 43 = 76.700%)
  16. The_Speaker's_House has been edited by User:The_Speaker's_House 254 times (of 335 = 75.800%) (has COI template)
  17. Thermomass has been edited by User:Thermomass 43 times (of 57 = 75.400%)
  18. Narmada_Ahuja has been edited by User:Narmada_Ahuja 12 times (of 16 = 75.000%)
  19. Rukhaiyar has been edited by User:Rukhaiyar 15 times (of 20 = 75.000%)
  20. Waldir has been edited by User:Waldir 3 times (of 4 = 75.000%)
  21. Boriswood has been edited by User:Boriswood 47 times (of 63 = 74.600%)
  22. College_of_Micronesia-FSM has been edited by User:College_of_Micronesia-FSM 103 times (of 139 = 74.100%)
  23. Retignano has been edited by User:Retignano 16 times (of 22 = 72.700%)
  24. Steven_Ybarra has been edited by User:Steven_Ybarra 76 times (of 105 = 72.400%) (has COI template) (has autobiography template)
  25. Goldenwest_Credit_Union has been edited by User:Goldenwest_Credit_Union 10 times (of 14 = 71.400%)
  26. Angelo_B_Landers has been edited by User:Angelo_B_Landers 31 times (of 44 = 70.500%)
  27. Community_Greens has been edited by User:Community_Greens 19 times (of 27 = 70.400%)
  28. Turn2us has been edited by User:Turn2us 33 times (of 47 = 70.200%) (has COI template)
  29. Nartopa has been edited by User:Nartopa 270 times (of 386 = 69.900%)
  30. Tenmei has been edited by User:Tenmei 78 times (of 112 = 69.600%)
  31. Kalri_Jagir has been edited by User:Kalri_Jagir 66 times (of 95 = 69.500%)
  32. Martino_Traversa has been edited by User:Martino_Traversa 17 times (of 25 = 68.000%)
  33. Hajvalia has been edited by User:Hajvalia 17 times (of 25 = 68.000%)
  34. Kenges_Rakishev has been edited by User:Kenges_Rakishev 50 times (of 74 = 67.600%)
  35. Serocee has been edited by User:Serocee 23 times (of 34 = 67.600%)
  36. Jemez_State_Monument has been edited by User:Jemez_State_Monument 72 times (of 108 = 66.700%)
  37. Arcot_Narrainsawmy_Mudaliar has been edited by User:Arcot_Narrainsawmy_Mudaliar 78 times (of 117 = 66.700%)
  38. Vilkupe has been edited by User:Vilkupe 8 times (of 12 = 66.700%)
  39. Zurella has been edited by User:Zurella 6 times (of 9 = 66.700%)
  40. Thadou has been edited by User:Thadou 52 times (of 80 = 65.000%)
  41. Anna_Suvorova has been edited by User:Anna_Suvorova 46 times (of 71 = 64.800%) (has autobiography template)
  42. Tony_Longworth has been edited by User:Tony_Longworth 21 times (of 33 = 63.600%)
  43. Projectline has been edited by User:Projectline 19 times (of 30 = 63.300%) (has COI template)
  44. Marina_Faust has been edited by User:Marina_Faust 67 times (of 106 = 63.200%)
  45. Invisible-Exports has been edited by User:Invisible-Exports 17 times (of 27 = 63.000%)
  46. Akazai has been edited by User:Akazai 179 times (of 285 = 62.800%)
  47. JaMiss has been edited by User:JaMiss 15 times (of 24 = 62.500%)
  48. Decltype has been edited by User:Decltype 38 times (of 61 = 62.300%)
  49. Paudel has been edited by User:Paudel 298 times (of 480 = 62.100%)
  50. Eli_Todd has been edited by User:Eli_Todd 92 times (of 149 = 61.700%)
  51. Jyoshna has been edited by User:Jyoshna 24 times (of 39 = 61.500%)
  52. Pantene_Beautiful_Lengths has been edited by User:Pantene_Beautiful_Lengths 40 times (of 65 = 61.500%) (has COI template)
  53. Night_Tracks has been edited by User:Night_Tracks 98 times (of 162 = 60.500%)
  54. Mihalko has been edited by User:Mihalko 29 times (of 48 = 60.400%)
  55. Saman_Kelegama has been edited by User:Saman_Kelegama 32 times (of 53 = 60.400%)
  56. Mário_Franco has been edited by User:Mário_Franco 38 times (of 63 = 60.300%) (has autobiography template)
  57. Kusunose has been edited by User:Kusunose 3 times (of 5 = 60.000%)
  58. Bennelongia has been edited by User:Bennelongia 3 times (of 5 = 60.000%)
  59. Malangali has been edited by User:Malangali 3 times (of 5 = 60.000%)
  60. Pcmicro has been edited by User:Pcmicro 12 times (of 20 = 60.000%)
  61. Tatiana_Belokonenko has been edited by User:Tatiana_Belokonenko 17 times (of 29 = 58.600%)
  62. Embassy_of_Israel,_Kathmandu has been edited by User:Embassy_of_Israel,_Kathmandu 68 times (of 117 = 58.100%)
  63. The_Blue_Card has been edited by User:The_Blue_Card 37 times (of 64 = 57.800%)
  64. Bandurist has been edited by User:Bandurist 41 times (of 71 = 57.700%)
  65. Artacoana has been edited by User:Artacoana 15 times (of 26 = 57.700%)
  66. Kanesue has been edited by User:Kanesue 42 times (of 73 = 57.500%) (has COI template)
  67. Archiguille has been edited by User:Archiguille 93 times (of 162 = 57.400%)
  68. Teisho has been edited by User:Teisho 8 times (of 14 = 57.100%)
  69. Leeson_House has been edited by User:Leeson_House 44 times (of 77 = 57.100%)
  70. Eugene_Ankomah has been edited by User:Eugene_Ankomah 367 times (of 657 = 55.900%) (has COI template)
  71. Hemant_Joshi has been edited by User:Hemant_Joshi 31 times (of 56 = 55.400%) (has autobiography template)
  72. Jonas_Poole has been edited by User:Jonas_Poole 41 times (of 74 = 55.400%)
  73. Kittybrewster has been edited by User:Kittybrewster 37 times (of 67 = 55.200%)
  74. Wild_Light has been edited by User:Wild_Light 34 times (of 62 = 54.800%)
  75. Burnside_library has been edited by User:Burnside_library 35 times (of 64 = 54.700%)
  76. Aux_Manir has been edited by User:Aux_Manir 36 times (of 67 = 53.700%)
  77. Harry_Shoemaker has been edited by User:Harry_Shoemaker 37 times (of 69 = 53.600%) (has COI template)
  78. Paul_Hoover has been edited by User:Paul_Hoover 39 times (of 73 = 53.400%) (has autobiography template)
  79. Ebelthite has been edited by User:Ebelthite 40 times (of 75 = 53.300%)
  80. Monroe_County_Public_Library has been edited by User:Monroe_County_Public_Library 18 times (of 34 = 52.900%) (has COI template)
  81. Kutar has been edited by User:Kutar 72 times (of 137 = 52.600%)
  82. Bernard_Hibbitts has been edited by User:Bernard_Hibbitts 24 times (of 46 = 52.200%) (has autobiography template)
  83. Tihawali has been edited by User:Tihawali 12 times (of 23 = 52.200%)
  84. Douglas_R._White has been edited by User:Douglas_R._White 76 times (of 147 = 51.700%)
  85. Karol_Siroky has been edited by User:Karol_Siroky 43 times (of 84 = 51.200%) (has autobiography template)
  86. Peter_Kosminsky has been edited by User:Peter_Kosminsky 138 times (of 271 = 50.900%)
  87. Talskiddy has been edited by User:Talskiddy 30 times (of 59 = 50.800%)
  88. Haman_Alimardani has been edited by User:Haman_Alimardani 37 times (of 74 = 50.000%) (has COI template)
  89. Sindh_Archives has been edited by User:Sindh_Archives 8 times (of 16 = 50.000%)
  90. Broletto has been edited by User:Broletto 5 times (of 10 = 50.000%)
  91. Kmicic has been edited by User:Kmicic 1 times (of 2 = 50.000%)
  92. Mehlawat has been edited by User:Mehlawat 3 times (of 6 = 50.000%)
  93. Uruit has been edited by User:Uruit 6 times (of 12 = 50.000%)
  94. Frontenac_House has been edited by User:Frontenac_House 14 times (of 28 = 50.000%) (has COI template)
  95. Rajoka has been edited by User:Rajoka 3 times (of 6 = 50.000%)
  96. Naserke has been edited by User:Naserke 19 times (of 38 = 50.000%)
  97. James_Britt has been edited by User:James_Britt 2 times (of 4 = 50.000%)
  98. Urapar has been edited by User:Urapar 87 times (of 175 = 49.700%)
  99. Chunchucmil has been edited by User:Chunchucmil 225 times (of 455 = 49.500%)
  100. Dadehar has been edited by User:Dadehar 27 times (of 55 = 49.100%)
  101. Terrasidius has been edited by User:Terrasidius 19 times (of 39 = 48.700%)
  102. Kukini has been edited by User:Kukini 33 times (of 68 = 48.500%)
  103. Ben_Manilla has been edited by User:Ben_Manilla 32 times (of 66 = 48.500%) (has autobiography template)
  104. Heliocybe has been edited by User:Heliocybe 15 times (of 31 = 48.400%)
  105. OrthoCor has been edited by User:OrthoCor 24 times (of 51 = 47.100%)
  106. Rowlan has been edited by User:Rowlan 33 times (of 70 = 47.100%)
  107. Fakhar_Zaman has been edited by User:Fakhar_Zaman 30 times (of 64 = 46.900%) (has autobiography template)
  108. Apuldram has been edited by User:Apuldram 46 times (of 98 = 46.900%)
  109. Pecopteris has been edited by User:Pecopteris 28 times (of 60 = 46.700%)
  110. Extraordinary_Machine has been edited by User:Extraordinary_Machine 333 times (of 716 = 46.500%)
  111. Cristian_Milea has been edited by User:Cristian_Milea 39 times (of 84 = 46.400%)
  112. Shrikrishan_Sharma has been edited by User:Shrikrishan_Sharma 26 times (of 56 = 46.400%)
  113. Borok has been edited by User:Borok 6 times (of 13 = 46.200%)
  114. Lleifior has been edited by User:Lleifior 6 times (of 13 = 46.200%)
  115. Michael_Atherton has been edited by User:Michael_Atherton 17 times (of 37 = 45.900%)
  116. Oman_Botanic_Garden has been edited by User:Oman_Botanic_Garden 11 times (of 24 = 45.800%)
  117. Reinhard_Hartmann has been edited by User:Reinhard_Hartmann 26 times (of 57 = 45.600%) (has autobiography template)
  118. Mamiboys has been edited by User:Mamiboys 67 times (of 147 = 45.600%)
  119. Mark_de_Solla_Price has been edited by User:Mark_de_Solla_Price 22 times (of 49 = 44.900%) (has autobiography template)
  120. Subhasish_Dey has been edited by User:Subhasish_Dey 53 times (of 118 = 44.900%) (has COI template)
  121. Mathsci has been edited by User:Mathsci 4 times (of 9 = 44.400%)
  122. Vatsun has been edited by User:Vatsun 8 times (of 18 = 44.400%)
  123. Harnad has been edited by User:Harnad 4 times (of 9 = 44.400%)
  124. Wave_Music has been edited by User:Wave_Music 8 times (of 18 = 44.400%)
  125. Jeremy_Broun has been edited by User:Jeremy_Broun 41 times (of 95 = 43.200%)
  126. Dingfelder has been edited by User:Dingfelder 19 times (of 44 = 43.200%)
  127. Alan_Pascoe has been edited by User:Alan_Pascoe 54 times (of 125 = 43.200%)
  128. Miss_China_United_Kingdom_Pageant has been edited by User:Miss_China_United_Kingdom_Pageant 27 times (of 64 = 42.200%)
  129. Abol_Hussein_Tanhai has been edited by User:Abol_Hussein_Tanhai 8 times (of 19 = 42.100%)
  130. Torchomatic has been edited by User:Torchomatic 8 times (of 19 = 42.100%)
  131. RMISERY has been edited by User:RMISERY 80 times (of 191 = 41.900%)
  132. Charles_G._Irion has been edited by User:Charles_G._Irion 38 times (of 91 = 41.800%) (has COI template) (has autobiography template)
  133. Rufous-crowned_Sparrow has been edited by User:Rufous-crowned_Sparrow 154 times (of 368 = 41.800%)
  134. Saskatchewan_Festival_of_Words has been edited by User:Saskatchewan_Festival_of_Words 10 times (of 24 = 41.700%) (has COI template)
  135. Nicholas_Doumanis has been edited by User:Nicholas_Doumanis 10 times (of 24 = 41.700%)
  136. Dooniver has been edited by User:Dooniver 54 times (of 130 = 41.500%)
  137. Marsha_Skrypuch has been edited by User:Marsha_Skrypuch 42 times (of 102 = 41.200%) (has COI template)
  138. Bamakhrama has been edited by User:Bamakhrama 9 times (of 22 = 40.900%)
  139. Michael_Fourman has been edited by User:Michael_Fourman 36 times (of 88 = 40.900%) (has autobiography template)
  140. Enda_Caldwell has been edited by User:Enda_Caldwell 79 times (of 193 = 40.900%) (has autobiography template)
  141. Orjen has been edited by User:Orjen 96 times (of 235 = 40.900%)
  142. Kalirai has been edited by User:Kalirai 87 times (of 214 = 40.700%)
  143. Tabakalera has been edited by User:Tabakalera 21 times (of 52 = 40.400%)
  144. 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;