Query news sites submission to hacker news

newsites.sql

SELECT 
  title, timestamp, score, url
FROM 
  [bigquery-public-data.hacker_news.full] 
WHERE 
  (REGEXP_MATCH(url,r'nytimes.com|cnn.com|hufftingtonpost.com|usatoday.com|reuters.com|politico.com|yahoo.com
                |npr.org|latimes.com|nbcnews.com|cbsnews.com|nypost.com|abcnews.com|breitbart.com|theonion.com
                |newsmax.com|washingtontimes.com|newsweek.com|observer.com|chicago.suntimes.com|theguardian.com
                |buzzfeed.com|wjs.com|abcnews.go.com|news.bbc.co.uk|usatoday.com|bloomberg.com|news.google.com')) 
                AND deleted IS null AND type='story'
ORDER BY timestamp