4 ms·
>SELECT hn_name, hn_karma, hn_last_active FROM comments WHERE TIMESTAMPDIFF(DAY, hn_last_active, NOW()) > 180 ORDER BY hn_karma DESC LIMIT 100 Ah, Hacker News
by krapp 6y ago
>SELECT hn_name, hn_karma, hn_last_active FROM comments WHERE TIMESTAMPDIFF(DAY, hn_last_active, NOW()) > 180 ORDER BY hn_karma DESC LIMIT 100
Ah, Hacker News is too cool to use something as pedestrian as a database ;)
But there is a Google BigQuery dataset[0,1]. I don't know how up to date it is.
[0]https://console.cloud.google.com/bigquery?p=bigquery-public-data&d=hacker_news&page=dataset https://console.cloud.google.com/bigquery?p=bigquery-public-...
[1]https://news.ycombinator.com/item?id=10440502 https://news.ycombinator.com/item?id=10440502