Query Library

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

Viewing the first 20 of total 447 rows

Download Full Results
urltitle
https://vi.wikipedia.org/wiki/Nyan_CatNyan Cat
https://en.wikipedia.org/wiki/Syriac_flagAramean-Syriac flag
https://pl.wikipedia.org/wiki/MajottaMajotta
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/MarcaMarca
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/REX2REX2
https://lv.wikipedia.org/wiki/Lat%C4%AB%C5%86u_alfab%C4%93tsNULL
https://en.m.wikipedia.org/wiki/MacklemoreNULL
https://en.m.wikipedia.org/wiki/Post_turtleNULL
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_KashyapAnurag 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_RubensteinGlenn Rubenstein
https://en.m.wikipedia.org/wiki/Dry_needlingNULL
https://en.m.wikipedia.org/wiki/Tommy_WiseauNULL
https://es.m.wikipedia.org/wiki/Muhammad_Ali_JinnahNULL
https://ca.wikipedia.org/wiki/Tour_del_Llemos%C3%ADTour del Llemosí
https://id.wikipedia.org/wiki/FauquemberguesKomune 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 scanned30.64 GB
Results46.41 KB (447 rows)

Turn the web into a database!

Mixnode is a fast, flexible and massively scalable platform to extract and analyze data from the web.

or contact us at hi@mixnode.com