Which Hacker News stories or comments link to reddit.com?

Results
Query

Viewing the first 20 of total 37 rows

title	url
Introduction to Guitar	https://news.ycombinator.com/item?id=5464311
A History of Programming Games 1961-1989	https://news.ycombinator.com/item?id=7042320
HN is 6 today. Here's traffic since the beginning	https://news.ycombinator.com/item?id=5253773
_why is no more	https://news.ycombinator.com/item?id=773106
This link says it's from YouTube but it's not	https://news.ycombinator.com/item?id=1259695
That WoW server blade	https://news.ycombinator.com/item?id=8153781
So you want to get started in an Infosec Career?	https://news.ycombinator.com/item?id=1409735
Bitcoin Visa debit cards are cancelled	https://news.ycombinator.com/item?id=16077873
100,000 tasklets: Stackless and Go	https://news.ycombinator.com/item?id=943304
Warning: 2016 MacBook Pro is not compatible with Linux	https://news.ycombinator.com/item?id=12924051
How Zidisha (YC W14) Is Misleading the Public About Its Interest Rates	https://news.ycombinator.com/item?id=7546394
Ask HN: I've learned a programming language – how do I solve problems with code?	https://news.ycombinator.com/item?id=8672200
New sub-reddit devoted to datasets	https://news.ycombinator.com/item?id=1242029
I'm learning to code by building 180 websites in 180 days. Today is day 115	https://news.ycombinator.com/item?id=6097155
6.5 Million LinkedIn Password Hashes Leaked	https://news.ycombinator.com/item?id=4073309
NULL	https://news.ycombinator.com/item?id=6041726
Nicehash down – rumors of $60M in Bitcoin stolen	https://news.ycombinator.com/item?id=15863306
Truthcoin: Trustless, Decentralized Bitcoin Prediction Marketplace	https://news.ycombinator.com/item?id=7691289
Ask HN: What under $100 item would you recommend everyone buy?	https://news.ycombinator.com/item?id=7478408
After raising $50M, Reddit forces all remote workers to relocate to SF	https://news.ycombinator.com/item?id=8398127

Viewing the first 20 of total 37 rows

Download Full Results

Query

select
    css_text_first(content, '.storylink') as title,
    url
from 
    pages
where 
    url_domain = 'ycombinator.com' 
        and
    url like 'https://news.ycombinator.com/item%'
        and     
    contains_any(content, array['href="https://www.reddit.com', 'href="http://www.reddit.com', 'href="https://reddit.com', 'href="http://reddit.com', 'href="www.reddit.com', 'href="reddit.com'])

Load in editor

Data scanned 63.62 MB

Results 3.55 KB (37 rows)

Which Hacker News stories or comments link to reddit.com?

Turn the web into a database!