Which Wikipedia pages link to Hacker News?

Results
Query

Viewing the first 20 of total 27 rows

title	url
DuckDuckGo	https://ru.wikipedia.org/wiki/DuckDuckGo
استاندارد رمزنگاری پیشرفته	https://fa.wikipedia.org/wiki/%D8%A7%D8%B3%D8%AA%D8%A7%D9%86%D8%AF%D8%A7%D8%B1%D8%AF_%D8%B1%D9%85%D8...
Wes McKinney	https://en.wikipedia.org/wiki/Wes_McKinney
Open Whisper Systems	https://en.wikipedia.org/wiki/Open_Whisper_Systems
Dolby Digital	https://fr.wikipedia.org/wiki/Dolby_Digital
Kuro5hin	https://en.wikipedia.org/wiki/Kuro5hin.org
Advanced Encryption Standard	https://en.wikipedia.org/wiki/Advanced_Encryption_Standard
NULL	https://uk.wikipedia.org/wiki/%D0%A1%D0%BE%D0%BB%D1%8C%D1%81%D0%B5
A Plus (aplus.com)	https://en.wikipedia.org/wiki/A_Plus_(aplus.com)
CoffeeScript	https://fr.wikipedia.org/wiki/CoffeeScript
NULL	https://ja.m.wikipedia.org/wiki/ENIAC
Talk:Joe job	https://en.wikipedia.org/wiki/Talk:Joe_job
Convergence (SSL)	https://en.wikipedia.org/wiki/Convergence_(SSL)
NULL	https://en.m.wikipedia.org/wiki/Perl
Transport Layer Security	https://es.wikipedia.org/wiki/Transport_Layer_Security
Bojan Krkić	https://tr.wikipedia.org/wiki/Bojan_Krki%C4%87
Quiry-le-Sec	https://de.wikipedia.org/wiki/Quiry-le-Sec
elementary OS	https://ja.wikipedia.org/wiki/Elementary_OS
Cross-site scripting	https://en.wikipedia.org/wiki/Cross-site_Scripting
Gitorious	https://en.wikipedia.org/wiki/Gitorious

Viewing the first 20 of total 27 rows

Download Full Results

Query

select
    css_text_first(content, 'h1#firstHeading') as title,
    url
from 
    pages
where 
    url_domain = 'wikipedia.org' 
    	and        
    contains_any(content, array['href="https://news.ycombinator.com', 'href="http://news.ycombinator.com', 'href="https://news.ycombinator.com', 'href="http://news.ycombinator.com', 'href="news.ycombinator.com'])

Load in editor

Data scanned 30.6 GB

Results 2.08 KB (27 rows)

Which Wikipedia pages link to Hacker News?

Turn the web into a database!