Most Linked Redirects to Disambiguation Pages

The current time is November 21, 2024, 9:59 UTC. Replication lag is 2 seconds.

             SELECT redirect_title,
                    redirect_id,
                    dab_title,
                    count(*) AS count,
                    lc_amnt AS dab_count
               FROM all_dab_links, dab_link_count
              WHERE dab_id = lc_id
                AND redirect_title <> dab_title
                AND dab_title NOT LIKE '%_(disambiguation)'
              GROUP BY redirect_title
              ORDER BY count DESC, redirect_title ASC
         LIMIT 51

Showing below up to 50 results starting with #1.

View (previous 50) (next 50) (20 | 50 | 100 | 250 | 500)

  1. Charles Gavan DuffyCharles Duffy (8 of 19 links)
  2. Al-JanadJanad (6 of 6 links)
  3. Gavan DuffyCharles Duffy (5 of 19 links)
  4. Undivided Samastha Kerala Jem-iyyathul UlamaSamastha (5 of 5 links)
  5. Gavan Duffy (politician)Charles Duffy (4 of 19 links)
  6. IndustriesIndustry (4 of 5 links)
  7. InfluentialInfluence (4 of 4 links)
  8. DiverseDiversity (3 of 3 links)
  9. Duke of DurazzoDuchy of Durazzo (3 of 3 links)
  10. GeziraJazira (3 of 3 links)
  11. KaradakhQaradagh (3 of 3 links)
  12. Left Front (India)Left Front (3 of 3 links)
  13. LovingkindnessLoving-kindness (3 of 3 links)
  14. Marko VukčevićMarko Vukcevic (3 of 3 links)
  15. MeaninglessnessMeaning (3 of 3 links)
  16. MisbehaviorMisbehaviour (3 of 3 links)
  17. Night BirdNightbird (3 of 3 links)
  18. PolarizedPolarization (3 of 4 links)
  19. Quantum LeapQuantum leap (3 of 3 links)
  20. SathiyaSaathiya (3 of 3 links)
  21. XisXIS (3 of 4 links)
  22. AboriginalAborigine (2 of 2 links)
  23. Al-RaziRazi (2 of 2 links)
  24. Australia national football teamAustralia national soccer team (2 of 2 links)
  25. Bengali filmsBengali cinema (2 of 3 links)
  26. Bill LawrenceWilliam Lawrence (2 of 2 links)
  27. Black beltBlack Belt (2 of 2 links)
  28. Broken BridgeBroken bridge (2 of 2 links)
  29. Call of Duty: ZombiesCall of Duty Zombies (2 of 2 links)
  30. Camino RealEl Camino Real (2 of 2 links)
  31. Canadian Rugby Football UnionCanadian Rugby Union (2 of 2 links)
  32. Carlos DíazCarlos Diaz (2 of 2 links)
  33. ChaldeansChaldean (2 of 3 links)
  34. Charlie Brown Jr.Charles Brown (2 of 2 links)
  35. Chris MooreChristopher Moore (2 of 2 links)
  36. Chuck TaylorCharles Taylor (2 of 2 links)
  37. CynicismCynic (2 of 2 links)
  38. DeDE (2 of 2 links)
  39. EANEan (2 of 2 links)
  40. EsES (2 of 2 links)
  41. EstablishedEstablishment (2 of 2 links)
  42. Fenix FCFenix (2 of 3 links)
  43. First OfficerFirst officer (2 of 2 links)
  44. George Gray (footballer)George Gray (2 of 2 links)
  45. Gerolamo PriuliGirolamo Priuli (2 of 2 links)
  46. GuaraníGuarani (2 of 3 links)
  47. HypostatizedHypostasis (2 of 3 links)
  48. IndependantL'Indépendant (2 of 2 links)
  49. Indian tradeIndian Trade (2 of 3 links)
  50. Internal exileInternal Exile (2 of 2 links)

View (previous 50) (next 50) (20 | 50 | 100 | 250 | 500)



Contact: the bot discussion page on the English Wikipedia.
Source code available here.