SQL
AخA
USE frwiki_p;
SELECT CONCAT('# ', el_to, COUNT(*) AS link_count)
FROM page
JOIN externallinks
ON page_id = el_from
WHERE page_namespace = 0
AND (el_to LIKE 'http://insee.fr/%' OR el_to LIKE 'https://www.insee.fr/%')
GROUP BY el_to
ORDER BY link_count DESC el_to;
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.