Untitled query #84607

SQL

SELECT DISTINCT(page_title)
FROM page
JOIN pagelinks ON pl_from = page_id
JOIN linktarget ON pl_target_id = lt_id
WHERE page_namespace = 0
AND page_is_redirect = 0
AND pl_from_namespace = 0
AND lt_namespace = 0
AND lt_title IN ('ABC_News', 'ABC_News_(United_States)')
AND page_id IN (SELECT DISTINCT(page_id)
                FROM page
                JOIN externallinks ON el_from = page_id
                WHERE page_namespace = 0
                AND page_is_redirect = 0
                AND el_to_domain_index IN ('http://au.net.abc.www.', 'https://au.net.abc.www.', 'http://au.net.abc.', 'https://au.net.abc.'))
SQL

Checking query status...
