Query Library

Get the title of every Wikipedia article that contains the substring 'Elon Musk'

Viewing the first 20 of total 269 rows

Download Full Results
urltitle
https://th.m.wikipedia.org/wiki/%E0%B8%9E.%E0%B8%A8._2561NULL
https://en.wikipedia.org/wiki/Open-source_modelOpen-source model
https://es.wikipedia.org/wiki/HyperloopHyperloop
https://en.wikipedia.org/wiki/Reaction_Engines_SkylonSkylon (spacecraft)
https://fa.wikipedia.org/wiki/%D8%A7%D8%B3%D9%BE%DB%8C%D8%B3%E2%80%8C%D8%A7%DA%A9%D8%B3اسپیساکس
https://en.wikipedia.org/wiki/Portal:Current_events/February_2018Portal:Current events/February 2018
https://es.m.wikipedia.org/wiki/Royal_SocietyNULL
https://vi.wikipedia.org/wiki/Th%E1%BB%83_lo%E1%BA%A1i:L%E1%BA%ADp_tr%C3%ACnh_vi%C3%AAn_M%E1%BB%B9Thể loại:Lập trình viên Mỹ
https://fr.wikipedia.org/wiki/Universit%C3%A9_Queen%27sUniversité Queen's
https://th.wikipedia.org/wiki/%E0%B8%84%E0%B8%A3%E0%B8%B4%E0%B8%AA%E0%B8%95%E0%B9%8C%E0%B8%AA%E0%B8%...คริสต์สหัสวรรษที่ 3
https://es.wikipedia.org/wiki/Iron_Man_2Iron Man 2
https://en.wikipedia.org/wiki/Viking_landerViking program
https://no.wikipedia.org/wiki/Serey_DieNULL
https://cs.wikipedia.org/wiki/Kolonizace_MarsuKolonizace Marsu
https://de.wikipedia.org/wiki/Combined_Charging_SystemCombined Charging System
https://en.wikipedia.org/wiki/Automation_in_automobilesVehicular automation
https://fr.wikipedia.org/wiki/Epic_Rap_Battles_of_HistoryEpic Rap Battles of History
https://nl.wikipedia.org/wiki/Tesla_RoadsterTesla Roadster
https://gl.wikipedia.org/wiki/Categor%C3%ADa:Personalidades_da_inform%C3%A1ticaCategoría:Personalidades da informática
https://az.wikipedia.org/wiki/%C4%B0lon_Maskİlon Mask

Viewing the first 20 of total 269 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(content, 'Elon Musk')
Load in editor
Data scanned30.65 GB
Results22.6 KB (269 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