Fork of
Untitled query #77227
by GreenC
This query is marked as a draft
This query has been published
by Cryptic.
SQL
AخA
SELECT page_title,
page_namespace,
CONCAT(REGEXP_REPLACE(el_to_domain_index,
'^(.*?://)(?:([^.]+)\\.)([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)$',
'\\1\\9\\8\\7\\6\\5\\4\\3\\2'),
el_to_path) AS url
FROM externallinks
JOIN page ON page_id = el_from
WHERE el_to_domain_index LIKE 'https://nl.kb.%' OR el_to_domain_index LIKE 'http://nl.kb.%';
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.