Untitled query #80265

SQL

SELECT p.page_title,
externallinks.el_to_path,
externallinks.el_to_domain_index
FROM page AS p
JOIN externallinks ON (p.page_id = externallinks.el_from)
WHERE p.page_is_redirect = 0
AND p.page_namespace = 2
AND externallinks.el_to_domain_index NOT LIKE "%wmflabs%"
AND externallinks.el_to_domain_index NOT LIKE "%wikipedia%"
AND externallinks.el_to_domain_index NOT LIKE "%toolforge%"
AND externallinks.el_to_domain_index NOT LIKE "%mediawiki%"
AND externallinks.el_to_domain_index NOT LIKE "%wmcloud%"
AND externallinks.el_to_domain_index NOT LIKE "%wikimedia%"
AND externallinks.el_to_domain_index NOT LIKE "%wikidata%"
GROUP BY p.page_id
SQL

Checking query status...
