Most Linked Redirects to Disambiguation Pages

The current time is May 15, 2024, 21:32 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 21

Showing below up to 20 results starting with #1.

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

  1. St Jerome in PenanceSaint Jerome in Penitence (25 of 26 links)
  2. Pleasant Valley, OregonPleasant Valley (22 of 22 links)
  3. PratignaPratigya (14 of 14 links)
  4. ChahamanaChahamanas (12 of 13 links)
  5. Borova, Kharkiv OblastBorova (6 of 6 links)
  6. National Jiaotong UniversityJiaotong University (6 of 6 links)
  7. Ancient MethoneMethone (5 of 5 links)
  8. ReminiscentReminisce (5 of 5 links)
  9. ReticulateReticulation (5 of 5 links)
  10. AzucarAzúcar (4 of 4 links)
  11. Como los pecesCarlos Varela (4 of 4 links)
  12. DevoteeDevotion (4 of 6 links)
  13. Low-mass starsLow-mass star (4 of 11 links)
  14. Michael Hall (American musician)Michael Hall (4 of 4 links)
  15. MizrahiMizrachi (4 of 4 links)
  16. Nancy GonzalezNancy González (4 of 4 links)
  17. AccessoriesAccessory (3 of 3 links)
  18. Arrow-Debreu marketArrow–Debreu market (3 of 3 links)
  19. AutochthonousAutochthon (3 of 4 links)
  20. History of the political divisions of ChinaHistory of the administrative divisions of China (3 of 9 links)

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



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