SQL
AخA
USE enwiki_p;
SELECT COUNT(el_id) AS links, SUBSTRING_INDEX(el_index, "/", 3) as domain
FROM externallinks
JOIN page
ON el_from = page_id
AND page_namespace = 0
GROUP BY domain
ORDER BY links DESC;
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.