SQL
AخA
USE arwiki_p;
SELECT url, COUNT(*)
FROM (
SELECT SUBSTRING_INDEX(SUBSTRING(el_to, LOCATE('://', el_to) + 3), '/', 1) url
FROM externallinks
WHERE el_from IN (
SELECT page_id
FROM page
WHERE page_namespace = 0
)
) tmp_table
GROUP BY url
HAVING COUNT(*) > 100
ORDER BY COUNT(*) 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.