Which Wikipedia articles have at least one link to reddit.com?

Results
Query

Viewing the first 20 of total 447 rows

url	title
https://vi.wikipedia.org/wiki/Nyan_Cat	Nyan Cat
https://en.wikipedia.org/wiki/Syriac_flag	Aramean-Syriac flag
https://pl.wikipedia.org/wiki/Majotta	Majotta
https://ru.wikipedia.org/wiki/%D0%9A%D0%B0%D1%82%D0%B5%D0%B3%D0%BE%D1%80%D0%B8%D1%8F:%D0%98%D1%81%D0...	Категория:Искусство Индонезии
https://pt.wikipedia.org/wiki/Marca	Marca
https://pi.m.wikipedia.org/wiki/%E0%A4%B0%E0%A5%8B%E0%A4%97%E0%A4%B6%E0%A4%BE%E0%A4%B8%E0%A5%8D%E0%A...	NULL
https://en.wikipedia.org/wiki/REX2	REX2
https://lv.wikipedia.org/wiki/Lat%C4%AB%C5%86u_alfab%C4%93ts	NULL
https://en.m.wikipedia.org/wiki/Macklemore	NULL
https://en.m.wikipedia.org/wiki/Post_turtle	NULL
https://en.wikipedia.org/wiki/Home_Free_(group)	Home Free (group)
https://ru.wikipedia.org/wiki/%D0%9E%D0%B4%D0%BD%D0%B0%D0%B6%D0%B4%D1%8B_%D0%B2_%D1%81%D0%BA%D0%B0%D...	Однажды в сказке (сезон 4)
https://en.wikipedia.org/wiki/Anurag_Kashyap	Anurag Kashyap
https://ru.wikipedia.org/wiki/%D0%AD%D0%B9%D0%B2%D0%B5,_%D0%9C%D0%B0%D0%BA%D1%81	Эйве, Макс
https://en.wikipedia.org/wiki/Glenn_Rubenstein	Glenn Rubenstein
https://en.m.wikipedia.org/wiki/Dry_needling	NULL
https://en.m.wikipedia.org/wiki/Tommy_Wiseau	NULL
https://es.m.wikipedia.org/wiki/Muhammad_Ali_Jinnah	NULL
https://ca.wikipedia.org/wiki/Tour_del_Llemos%C3%AD	Tour del Llemosí
https://id.wikipedia.org/wiki/Fauquembergues	Komune di departemen Pas-de-Calais

Viewing the first 20 of total 447 rows

Download Full Results

Query

select
    url,
    css_text_first(content, 'h1#firstHeading') as title
from 
    pages
where 
    url_domain = 'wikipedia.org' 
        and
    url like '%/wiki/%'
        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 30.64 GB

Results 46.41 KB (447 rows)

Which Wikipedia articles have at least one link to reddit.com?

Turn the web into a database!