Common domains in CAT:LRN

SQL

USE commonswiki_p;
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(el_to, "/", 3), "/", -2), 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(SUBSTRING_INDEX(el_to, "/", 3), "/", -2)
ORDER BY COUNT(*) DESC
SQL

Checking query status...
