List of URL with invalid Top Level Domain

SQL

with TLDlist as (
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(e.el_to_domain_index,'.',1),'/',-1) as TLD
FROM externallinks as e
JOIN page ON page_id = el_from
WHERE page.page_id=12869134 and  (e.el_to_domain_index like 'http%') 
)
, TLDres as (
SELECT page.page_title, SUBSTRING_INDEX(SUBSTRING_INDEX(el_to_domain_index,'.',1),'/',-1) as TLD
FROM externallinks 
JOIN page ON page_id = el_from
WHERE page.page_namespace =0 and  (el_to_domain_index like 'http%') 
)
SELECT TLDres.page_title, TLDres.TLD
FROM TLDres LEFT JOIN TLDlist on TLDres.TLD=TLDlist.TLD
WHERE TLDlist.TLD is null
LIMIT 100

SQL

Checking query status...