Common domains in CAT:LRN

SQL

USE commonswiki_p;
SELECT SUBSTRING_INDEX(el_to, "/", 3), COUNT(*)
FROM externallinks
JOIN categorylinks ON cl_from = el_from
WHERE 
	cl_to = "License_review_needed"
    AND el_to NOT LIKE "archive.org"
    AND el_to NOT LIKE "toolforge.org"
    AND el_to NOT LIKE "wmflabs.org"
    AND SUBSTRING_INDEX(el_to, "/", 3) NOT IN (
      "https://creativecommons.org",
      "https://www.wikidata.org",
      "//www.worldcat.org",
      "//maps.google.com",
      "https://archive.today"
    )
GROUP BY SUBSTRING_INDEX(el_to, "/", 3)
ORDER BY COUNT(*) DESC
SQL

Checking query status...
