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

Results
Query

Viewing the first 20 of total 6,112 rows

title	url
Худхуд (циклон)	https://ru.wikipedia.org/wiki/%D0%A5%D1%83%D0%B4%D1%85%D1%83%D0%B4_(%D1%86%D0%B8%D0%BA%D0%BB%D0%BE%D...
سیا	https://fa.wikipedia.org/wiki/%D8%A2%DA%98%D8%A7%D9%86%D8%B3_%D8%A7%D8%B7%D9%84%D8%A7%D8%B9%D8%A7%D8...
NULL	https://tr.wikipedia.org/wiki/Gabriel_Garcia_Marquez
Terratrèmol de Kermanshah de 2017	https://ca.wikipedia.org/wiki/Terratr%C3%A8mol_de_Kermanshah_de_2017
2020 Democratic Party presidential primaries	https://en.wikipedia.org/wiki/2020_Democratic_Party_presidential_primaries
Fronteira Estados Unidos-México	https://pt.wikipedia.org/wiki/Fronteira_M%C3%A9xico-Estados_Unidos
Sweden	https://en.wikipedia.org/wiki/Sweden
Order of the British Empire	https://en.wikipedia.org/wiki/Order_of_the_British_Empire
Inchindown oil tanks	https://en.wikipedia.org/wiki/Inchindown_oil_tanks
نیلوفر آبی	https://fa.wikipedia.org/wiki/%D9%84%D9%88%D8%AA%D9%88%D8%B3_%28%DA%AF%D9%84%29
九二共識	https://zh.wikipedia.org/wiki/%E4%B9%9D%E4%BA%8C%E5%85%B1%E8%AD%98
უეფა-ს სუპერთასი	https://ka.wikipedia.org/wiki/%E1%83%A3%E1%83%94%E1%83%A4%E1%83%90-%E1%83%A1_%E1%83%A1%E1%83%A3%E1%8...
Спадкування	https://uk.wikipedia.org/wiki/%D0%A1%D0%BF%D0%B0%D0%B4%D0%BA%D1%83%D0%B2%D0%B0%D0%BD%D0%BD%D1%8F
Azerbaijan	https://en.wikipedia.org/wiki/Azerbaijan
Đánh bom Ankara tháng 2 năm 2016	https://vi.wikipedia.org/wiki/%C4%90%C3%A1nh_bom_Ankara_th%C3%A1ng_2_n%C4%83m_2016
Франція	https://uk.wikipedia.org/wiki/%D0%A4%D1%80%D0%B0%D0%BD%D1%86%D1%96%D1%97
特里嘎纳航空267号班机空难	https://zh.wikipedia.org/wiki/%E7%89%B9%E9%87%8C%E5%98%8E%E7%BA%B3%E8%88%AA%E7%A9%BA267%E5%8F%B7%E7%...
NULL	https://ru.m.wikipedia.org/wiki/UKIP
Acidente radiológico de Goiânia	https://pt.wikipedia.org/wiki/Acidente_radiol%C3%B3gico_de_Goi%C3%A2nia
Ausschreitungen in Odessa am 2. Mai 2014	https://de.wikipedia.org/wiki/Ausschreitungen_in_Odessa_am_2._Mai_2014

Viewing the first 20 of total 6,112 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://www.bbc.com', 'href="http://www.bbc.com', 'href="https://bbc.com', 'href="http://bbc.com', 'href="www.bbc.com', 'href="bbc.com'])

Load in editor

Data scanned 30.64 GB

Results 599.23 KB (6,112 rows)

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

Turn the web into a database!