Articles with links to select news sites

SQL

SELECT DISTINCT(page_title)
FROM page
JOIN externallinks ON page_id = el_from
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.',
  'https://com.go.abcnews.',
  'https://com.go.abcnews.www',
  'http://com.go.abcnews.',
  'http://com.go.abcnews.www',
  'https://au.com.dailytelegraph.www.',
  'http://au.com.dailytelegraph.www.',
  'https://au.com.theguardian.www.',
  'http://au.com.theguardian.www.',
  'https://com.theguardian.www.',
  'http://com.theguardian.www.',
  'https://com.bbc.www.',
  'http://uk.co.bbc.www.',
  'https://uk.co.bbc.www.',
  'http://com.nytimes.www.',
  'https://com.nytimes.www.',
  'http://com.reuters.www.',
  'https://com.reuters.www.',
  'http://uk.co.telegraph.www.',
  'https://uk.co.telegraph.www.'
)
SQL

Checking query status...
