SQL
x
USE arwiki_p;
SELECT site, COUNT(*)
FROM (SELECT REGEXP_REPLACE(el_to, '^(?:[a-z]*:)?//([^/]*)(?:.*)', '\\1') AS site
FROM externallinks
JOIN page ON page_id = el_from
JOIN categorylinks ON cl_from = page_id
WHERE cl_to IN ('جائحة_فيروس_كورونا_في_السعودية')) sq
GROUP BY site;
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.