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

Results
Query

Viewing the first 20 of total 1,303 rows

title	url
Loganair	https://en.wikipedia.org/wiki/Loganair
List of association footballers who died while playing	https://en.wikipedia.org/wiki/List_of_association_footballers_who_died_while_playing
NULL	https://en.wikipedia.org/wiki/Land_of_Punt
Smartmatic	https://en.wikipedia.org/wiki/Smartmatic
Tasmanian Wilderness World Heritage Area	https://en.wikipedia.org/wiki/Tasmanian_Wilderness_World_Heritage_Area
Rugby league	https://en.wikipedia.org/wiki/Rugby_league?rdfrom=http%3A%2F%2Fwww.wiki.jeremymacpherson.net%2Findex...
Ted Kaczynski	https://en.wikipedia.org/wiki/Theodore_Kaczynski
Marriage (Same Sex Couples) Act 2013	https://en.wikipedia.org/wiki/Marriage_(Same_Sex_Couples)_Act_2013
War on Terror	https://en.wikipedia.org/wiki/The_war_on_terror
Jim Murphy	https://en.wikipedia.org/wiki/Jim_Murphy
Sami Khedira	https://en.wikipedia.org/wiki/Sami_Khedira
Warhammer 40,000	https://en.wikipedia.org/wiki/Emperor_of_Mankind
Domestic violence	https://en.wikipedia.org/wiki/Domestic_Violence
Ape	https://en.wikipedia.org/wiki/Hominoid
Taiwan	https://en.wikipedia.org/wiki/Republic_of_China
Circuit diagram	https://en.wikipedia.org/wiki/Electrical_schematic
Taiwan	https://en.wikipedia.org/wiki/R.O.C
Haredi Judaism	https://en.wikipedia.org/wiki/Charedi
McDonnell Douglas MD-80	https://en.wikipedia.org/wiki/McDonnell_Douglas_MD-80_/_MD-90
History of HIV/AIDS	https://en.wikipedia.org/wiki/History_of_HIV/AIDS

Viewing the first 20 of total 1,303 rows

Download Full Results

Query

select
    css_text_first(content, 'h1#firstHeading') as title,
    url
from 
    pages
where 
    url_domain = 'wikipedia.org' 
        and
    url like 'https://en.wikipedia.org/wiki/%'
        and
    url not like 'https://en.wikipedia.org/wiki/Talk:%'
        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 99.53 KB (1,303 rows)

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

Turn the web into a database!