Most Linked Redirects to Disambiguation Pages

The current time is April 19, 2024, 5:55 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 21

Showing below up to 20 results starting with #1.

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

  1. Communist Party of Nepal—MaoistCommunist Party of Nepal (Maoist) (75 of 75 links)
  2. Team Giant–ShimanoTeam dsm–firmenich PostNL (34 of 34 links)
  3. 4–4–2442 (32 of 32 links)
  4. Steve Smith (ice hockey, born in Canada)Steven Smith (20 of 20 links)
  5. Pontiac—TémiscaminguePontiac–Témiscamingue (19 of 30 links)
  6. ChahamanaChahamanas (13 of 13 links)
  7. Azizur Rahman (Bangladeshi politician)Azizur Rahman (12 of 15 links)
  8. National Jiaotong UniversityJiaotong University (12 of 12 links)
  9. Palmans–CollstropPalmans-Collstrop (10 of 10 links)
  10. Pontiac-TémiscaminguePontiac–Témiscamingue (10 of 30 links)
  11. Joao FonsecaJoão Fonseca (9 of 13 links)
  12. Ancient MethoneMethone (8 of 9 links)
  13. Russia-Africa SummitRussia–Africa Summit (8 of 8 links)
  14. Andries Botha (politician)Andries Botha (7 of 7 links)
  15. Borova, Kharkiv OblastBorova (7 of 7 links)
  16. Edmonton StrathconaStrathcona (7 of 7 links)
  17. SaradhaSharada (6 of 7 links)
  18. Shanghai–PudongShanghai Pudong (6 of 9 links)
  19. Álex FernándezAlex Fernandez (6 of 6 links)
  20. ReminiscentReminisce (5 of 5 links)

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



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