3 ms·
Something along the lines of: SELECT id, title FROM [bigquery-public-data:hacker_news.full_201510] WHERE title CONTAINS "Ask HN" AND url="" LIMIT 1
by minimaxir 10y ago
Something along the lines of:
SELECT id, title
FROM [bigquery-public-data:hacker_news.full_201510]
WHERE title CONTAINS "Ask HN" AND url=""
LIMIT 1000
Output: https://docs.google.com/spreadsheets/d/12HZ2DqkR_nl380bpxM0BLgfVfwCzb3l7hBSFKjlPDuw/edit?usp=sharing https://docs.google.com/spreadsheets/d/12HZ2DqkR_nl380bpxM0B...