Most Linked Redirects to Disambiguation Pages
The current time is May 15, 2024, 1:17 UTC. Replication lag is 1 second.
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)
- St Jerome in Penance → Saint Jerome in Penitence (25 of 26 links)
- Pleasant Valley, Oregon → Pleasant Valley (22 of 22 links)
- Pratigna → Pratigya (14 of 14 links)
- Chahamana → Chahamanas (12 of 12 links)
- Borova, Kharkiv Oblast → Borova (6 of 6 links)
- National Jiaotong University → Jiaotong University (6 of 6 links)
- Ancient Methone → Methone (5 of 5 links)
- Reminiscent → Reminisce (5 of 5 links)
- Reticulate → Reticulation (5 of 5 links)
- Azucar → Azúcar (4 of 4 links)
- Como los peces → Carlos Varela (4 of 4 links)
- Devotee → Devotion (4 of 6 links)
- Michael Hall (American musician) → Michael Hall (4 of 4 links)
- Mizrahi → Mizrachi (4 of 4 links)
- Nancy Gonzalez → Nancy González (4 of 4 links)
- Accessories → Accessory (3 of 3 links)
- Arrow-Debreu market → Arrow–Debreu market (3 of 3 links)
- Autochthonous → Autochthon (3 of 4 links)
- Fruit flies → Fruit fly (3 of 3 links)
- Inclusivity → Inclusive (3 of 3 links)
- Krishnaraj → Krishnaraja (3 of 3 links)
- La Trinitaria → Trinitaria (3 of 3 links)
- Long Hai → Long Hải (3 of 3 links)
- Lufeng City → Lufeng (3 of 3 links)
- Matt Johnson → Matthew Johnson (3 of 3 links)
- Metro rail → Metrorail (3 of 3 links)
- Mission church → Mission Church (3 of 3 links)
- Mister Universe → Mr. Universe (3 of 4 links)
- Nakhichevan → Nakhchivan (3 of 4 links)
- Nepean–Carleton → Nepean (3 of 3 links)
- OTT → Ott (3 of 3 links)
- Punjabi Brahmin → Punjabi Brahmins (3 of 5 links)
- R.W.D. Molenbeek → RWDM (3 of 3 links)
- Saint-Raphael → Saint Raphael (3 of 3 links)
- The Sorbonne → Sorbonne (3 of 5 links)
- Tornadoes of 1945 → 1945 tornado outbreak (3 of 3 links)
- YMCA FC → YMCA F.C. (3 of 3 links)
- Yu Lu → Yulu (3 of 3 links)
- ANSA → Ansa (2 of 2 links)
- Agents → Agent (2 of 3 links)
- Al → AL (2 of 2 links)
- Al Hasa → Al-Ahsa (2 of 2 links)
- Alexander Kulikov → Aleksandr Kulikov (2 of 2 links)
- Assoc → Assoc. (2 of 2 links)
- Asynchronous → Asynchrony (2 of 3 links)
- Azizur Rahman (Bangladeshi politician) → Azizur Rahman (2 of 2 links)
- Bouquets → Bouquet (2 of 2 links)
- Cavities → Cavity (2 of 2 links)
- Charlie Jones → Charles Jones (2 of 2 links)
- Chris Evans → Christopher Evans (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.