Wikipedia:WikiProject Red Link Recovery/DPWIR
Appearance
Overview
[edit]The list below shows deleted pages (that have not been recreated) in the main namespace with the greatest number of incoming links from the main namespace. It shows the top 250 entries only (of approximately 80,000). It was generated on Wikimedia labs by TB (talk) 07:54, 20 May 2015 (UTC)
Relevant policy/guidelines
[edit]- (A) - Wikipedia:Red_link#Dealing with existing red links - "a plausible red link might be to driving in Bangladesh, since an article on driving in the United States exists, and country-specific driving articles like these are a likely area for future creation"
- (B) - Wikipedia:Deletion policy#Copyright violations - deletion of an article for copyright violation does not attest to the un-notability of that subject.
- (C) - Article deleted as spam/gibberish with no comment as to it's notability. It would seem an article being 'so bad that deletion is a net gain for Wikipedia' is not as high a bar as one would think.
- (D) - Article deleted (AfD, PROD or CSD) with prejudice.
- (E) - Article deleted (AfD, PROD or CSD) without prejudice.
Report
[edit]SEP-227162 - 1187 links(D)- Telecommunications_in_Oceania - 1085 links (A)
- Telecommunications_in_Africa - 1085 links (A)
- Telecommunications_in_Asia - 1084 links (A)
- Telecommunications_in_North_America - 1082 links (A)
- Telecommunications_in_South_America - 1081 links (A)
- 2005–06_in_Italian_football - 1029 links (A)
- II-VI_Incorporated - 1022 links (B)
- Aspidytidae - 841 links (C)
- Ramavaram - 792 links (C)
- Kasimedu - 792 links (C)
- Irumbuliyur - 791 links (C)
- Pudupet - 791 links (C)
- Velachery_Aquatic_Complex - 790 links (B)
- Pulianthope - 790 links (C)
R_Prabhakar- 670 links (D)Five-card_majors- 669 links (E) (undeleted)- 2C-EF - 580 links (E)
- Stepladder_Mountains_Wilderness - 574 links (A)
- Pahrump_Valley_Wilderness - 574 links (A)
- Turtle_Mountains_Wilderness - 573 links (A)
- Sheephole_Valley_Wilderness - 572 links (A)
- Grass_Valley_Wilderness - 571 links (A)
- Golden_Valley_Wilderness - 571 links (A)
- Warner_Valley_Wildlife_Area - 569 links (A)
- San_Felipe_Valley_Wildlife_Area - 569 links (A)
- Saline_Valley_Ecological_Reserve - 569 links (A)
- Stunt_Ranch_Santa_Monica_Mountains_Reserve - 568 links (B)
- Colusa-Sacramento_River_State_Recreation_Area - 568 links (A)
- History_of_Roseville,_California - 565 links (B)
- North_Kananaskis_Pass - 548 links (A)
- Kananaskis_Pass - 547 links (A)
England_national_rugby_union_team_(u21)- 526 links (D) (naming convention mixup for unwritten article)- 7-Acetoxymitragynine - 499 links (E)
- List_of_Marathi_films_of_2008 - 458 links (A)
- List_of_Marathi_films_of_2006 - 457 links (A)
- List_of_Marathi_films_of_2002 - 456 links (A)
- List_of_Marathi_films_of_2005 - 456 links (A)
- List_of_Marathi_films_of_2007 - 456 links (A)
- List_of_Marathi_films_of_2001 - 455 links (A)
- List_of_Marathi_films_of_2004 - 455 links (A)
- List_of_Marathi_films_of_2003 - 454 links (A)
- Anourosoricini - 446 links (D) (needs expert attention)
- Kallahalli - 441 links (A)
- List_of_Marathi_films_of_1988 - 434 links (A)
- List_of_Marathi_films_of_1980 - 434 links (A)
- List_of_Marathi_films_of_1995 - 434 links (A)
- List_of_Marathi_films_of_1981 - 434 links (A)
- List_of_Marathi_films_of_1989 - 434 links (A)
- List_of_Marathi_films_of_1983 - 434 links (A)
- List_of_Marathi_films_of_1986 - 434 links (A)
- List_of_Marathi_films_of_1990 - 434 links (A)
- List_of_Marathi_films_of_1991 - 434 links (A)
- List_of_Marathi_films_of_1984 - 434 links (A)
- List_of_Marathi_films_of_1987 - 434 links (A)
- List_of_Marathi_films_of_1993 - 434 links (A)
- List_of_Marathi_films_of_1997 - 434 links (A)
- List_of_Marathi_films_of_1998 - 434 links (A)
- List_of_Marathi_films_of_1996 - 434 links (A)
- List_of_Marathi_films_of_1999 - 434 links (A)
- List_of_Marathi_films_of_1955 - 434 links (A)
- List_of_Marathi_films_of_1994 - 434 links (A)
- List_of_Marathi_films_of_2000 - 434 links (A)
- List_of_Marathi_films_of_1992 - 434 links (A)
- 2013_Japanese_Regional_Leagues - 409 links (A)
- Fritz_Böhm - 407 links (E)
- Franz_Mader - 407 links (E)
- Summer_Hill_Creek - 406 links (A)
- Reedy_Creek_(New_South_Wales) - 405 links (A)
- Bakers_Creek_(New_South_Wales) - 405 links
- Quegobla_Creek - 405 links (A)
- Quirindi_Creek - 405 links (A)
- Sewells_Creek - 405 links (A)
- Queen_Charlottes_Creek - 405 links (A)
- Emu_Swamp_Creek - 404 links (A)
- Evans_Plains_Creek - 404 links (A)
- Dungowan_Creek - 404 links (A)
- Carole_Creek - 404 links (A)
- Bundock_Creek - 404 links (A)
- Horsearm_Creek - 404 links (A)
- Ewenmar_Creek - 404 links (A)
- Abington_Creek - 404 links (A)
- Cheshire_Creek - 404 links (A)
- Frazers_Creek - 404 links (A)
- Halls_Creek_(New_South_Wales) - 404 links (A)
- Coolibah_Watercourse - 404 links (A)
Platform_technology- 381 links (D)'- Visa_requirements_for_Mauritanian_citizens - 371 links (A)
- Visa_requirements_for_Somali_citizens - 370 links (A)
- Barauni-Samastipur-Muzaffarpur-Hajipur_line - 370 links (E)
- N-Benzyl-1-phenethylamine - 369 links (E)
- 1945–46_FA_Cup_Qualifying_Rounds - 365 links (E)
- 2C-SE - 363 links
- 25H-NBOMe - 361 links
- Malaysia_Federal_Route_602 - 360 links
- Dicyclopropyltryptamine - 360 links
- Malaysia_Federal_Route_25 - 360 links
- List_of_programs_broadcast_by_Network_Ten - 357 links
- List_of_programs_broadcast_by_Channel_3_(Thailand) - 355 links
- List_of_programs_broadcast_by_Peachtree_TV - 355 links
- List_of_programs_currently_being_broadcast_by_TV_2_(Norway) - 354 links
- 203d_RED_HORSE_Squadron - 352 links
- 244th_Combat_Communications_Squadron - 352 links
- 234th_Combat_Communications_Squadron - 352 links
- CNBC-TV18 - 333 links
- Iran_national_under-15_football_team - 326 links
- Amrutrao - 323 links
- Nalin_Kohli - 308 links
- Tourism_of_Baranya - 302 links
- Pura,_India - 299 links
- Old_Haji_Camp - 294 links
- Khada_Memon_Society - 294 links
- Heinkel_He_278 - 293 links
- WBOX_(AM) - 292 links
- Sufotidine - 288 links
- MK-0249 - 287 links
- Focke-Wulf_Fw_238 - 287 links
- Syndiniaceae - 286 links
- Haemogregarinidae - 286 links
- Colpodellidae - 285 links
- Pelagothrix - 284 links
- Nokia_301 - 282 links
- Nokia_207 - 281 links
- Nokia_208 - 281 links
- Petroglyphs_of_Quiaca - 281 links
- Punkuri - 280 links
- Trinchera_Fortress - 280 links
- Ruins_of_Miraflores - 280 links
- Bannihatti - 278 links
- Blohm_&_Voss_BV_237 - 275 links
- Thailand_national_under-14_football_team - 273 links
- Thailand_Selection/Thailand_XI - 271 links
- Holopaw_State_Forest - 269 links
- Jamesport_State_Park - 269 links
- Dean's_Cove_Boat_Launch - 269 links
- Southeastern_Regional_Vocational_Technical_High_School - 268 links
- Mystic_Valley_Regional_Charter_School - 268 links
- Eurofest - 267 links
- Marlborough_High_School - 267 links
- Swekawngaw - 266 links
- Franklin_County_Technical_School - 266 links
- Joseph_P._Keefe_Technical_High_School - 266 links
- Avon_Middle_High_School - 266 links
- Equatorial_Guinean_passport - 266 links
- Four_Rivers_Charter_Public_School - 265 links
- Kramer_Rk_344 - 265 links
- Athol_High_School - 265 links
- Marcia_Greenberger - 263 links
- Messerschmitt_Me_364 - 262 links
- Messerschmitt_Me_164 - 262 links
- Uttar_Pradesh_Madhyamik_Shiksha_Parishad - 262 links
- AFL_Victoria_Youth_Girls_Competition - 261 links
- KQQB - 260 links
- Lacrosse_in_India - 259 links
- Hypsugo_alaschanicus - 259 links
- USAAF_Second_Air_Force_Tactical_Airfields - 256 links
- USAAF_Very_Heavy_Bomber_Bases - 256 links
- 1831_in_India - 249 links
- 1833_in_India - 249 links
- 1810_in_India - 248 links
- 1854_in_India - 248 links
- 1648_in_India - 248 links
- VP-1 - 248 links
- Adams_Street - 247 links
- Mochdre,_Powys - 245 links
- VP-45 - 243 links
- Nathan_Brackett - 242 links
- De_Heesterboom,_Leiden - 241 links
- HSL-60 - 241 links
- Table_of_years_in_paleontology - 241 links
- Education_in_Liechtenstein - 241 links
- Honda_Remix - 240 links
- ATPA - 240 links
- Education_in_Monaco - 238 links
- Education_in_East_Timor - 237 links
- Education_in_Brunei - 237 links
- Punch_TV - 237 links
- Ryan_Warner - 235 links
- 198th_Infantry_Division_(Wehrmacht) - 230 links
- 196th_Infantry_Division_(Wehrmacht) - 229 links
- LeTV.com - 229 links
- Jammu_and_Kashmir_Football_League - 227 links
- Tamilnadu_Football_Association - 227 links
- Onapristone - 227 links
- V_Cast - 226 links
- Tamil_Nadu_Board_of_Higher_Secondary_Education - 226 links
- Second_Battle_of_Dong_Ha - 225 links
- Action_of_16_June_1968 - 225 links
- Operation_Twinkletoes - 225 links
- Sheffield_to_Hull_Line - 224 links
- Paranyctimene - 222 links
- List_of_Hockey_Night_in_Canada_commentators_(2010s) - 222 links
- Economic_region - 222 links
- 199th_Infantry_Division_(Wehrmacht) - 221 links
- Boneia - 220 links
- Occam's_Razor_(Improv_Troupe) - 220 links
- Bengbu_Railway_Station - 220 links
- Ojaleshi - 219 links
- List_of_foreign_football_players_in_Liga_I_2010–11 - 217 links
- USS_LST-577 - 217 links
- National_Industrial_Symbiosis_Programme - 216 links
- USS_Sublette_County_(LST-1144) - 215 links
- USS_LST-618 - 215 links
- USS_Sumner_County_(LST-1148) - 215 links
- USS_LST-793 - 214 links
- John_IV_of_Constantinople - 214 links
- USS_LST-620 - 214 links
- 411_Building - 210 links
- Confederación_Panamericana_de_Roller_Sports - 210 links
- Qarasu,_Kazakhstan - 209 links
- 2014_Piala_Indonesia - 209 links
- Pokrovka,_Kazakhstan - 209 links
- Bear_MCG - 207 links
- Cioteronel - 207 links
- United_States_House_of_Representatives_elections_in_Illinois,_2004 - 206 links
- Banat_Zone_League - 205 links
- Toyota_i-swing - 204 links
- Toyota_Nadia - 203 links
- Judy_(comic) - 202 links
- Andy_Sneap - 201 links
- Nottingham_Mavericks - 200 links
- GNOME_Ease - 199 links
- Imperial_College_Devils - 198 links
- Chelmsford_Cobras - 198 links
- Bristol_Lions - 198 links
- Kent_Knights - 198 links
- Kalex - 198 links
- Kadian_clan - 198 links
- 1071_AM - 197 links
- Military_Intelligence_Unit - 197 links
- Dick_Bakker - 197 links
- Joe_Gracy - 195 links
- Gliese_867 - 194 links
- Texas_Tornado_(dinghy) - 194 links
- Wadi_Boura - 193 links
- The_Cody_Center - 193 links
- Criminal_Investigative_Department - 193 links
- HMS_Crocus_(K49) - 192 links
- Derry_Lindsay - 192 links
- Research_Department_Unit - 192 links
- Military_ranks_of_Slovakia - 191 links
- HMS_Petunia_(K79) - 191 links
- HMS_Pennywort_(K111) - 190 links
- AppFlower - 190 links
- Antonio_Mendoza - 189 links
- Gullringens_GOIF - 189 links
- 21st_Century_Learning - 189 links
- 2015_Liga_Nusantara - 189 links
- Tlail - 187 links
Regenerating
[edit]-- Find all deleted page titles with visible old revisions
CREATE TABLE deletedpages AS
SELECT DISTINCT ar_namespace as 'dp_namespace', ar_title as 'dp_title'
FROM enwiki_p.archive
WHERE ar_deleted = 0;
-- Remove all titles that still exist or have been recreated
DELETE d
FROM deletedpages d
INNER JOIN enwiki_p.page ON page_namespace = d.dp_namespace and page_title = d.dp_title;
-- Count the number of incoming links to each remaining title from namespace 0
ALTER TABLE deletedpages ADD COLUMN ( c int(5) NULL );
UPDATE deletedpages
SET c = ( SELECT count(*)
FROM enwiki_p.pagelinks
INNER JOIN enwiki_p.page ON pl_from = page_id
WHERE page_namespace = 0
AND pl_namespace = dp_namespace
AND pl_title = dp_title )
WHERE c IS NULL
LIMIT 300000;
select concat( '*[[', dp_title, ']] - ', c, ' links' )
from deletedpages
where dp_namespace = 0
order by c desc
limit 250;