Fork of
Top-500 most-interlinked pages
by Whym
This query is marked as a draft
This query has been published
by Evolutionoftheuniverse.
SQL
AخA
USE trwiki_p;
SELECT page_title, COUNT(iwl_from) AS num_links, GROUP_CONCAT(CONCAT("[[:",iwl_prefix,":"iwl_title,"]]") SEPARATOR ", ") FROM iwlinks
JOIN page ON iwl_from=page_id AND page_namespace=0 AND (iwl_prefix REGEXP "^[a-z]{2,3}_?(?:[a-z]{2,3})?$" OR iwl_prefix="w")
GROUP BY page_title
ORDER BY num_links DESC
LIMIT 1;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.