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 
)
, TLDres as (
SELECT el.el_from, SUBSTRING_INDEX(SUBSTRING_INDEX(el.el_to_domain_index,'.',1),'/',-1) as TLD, el.el_to_domain_index, el.el_to_path
FROM externallinks as el
WHERE  SUBSTRING_INDEX(el_to_domain_index,':',1) in ('http','https') 
)
, p as (SELECT page.page_id, page.page_title FROM page WHERE page.page_namespace =0) 
SELECT p.page_title, TLDres.TLD,  TLDres.el_to_domain_index,  TLDres.el_to_path
FROM  p INNER JOIN TLDres 
     ON p.page_id = TLDres.el_from
  LEFT JOIN   TLDlist 
     ON TLDlist.TLD =TLDres.TLD
WHERE TLDlist.TLD is null     
LIMIT 100
SQL

Checking query status...
