Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
0bamboo
.
Toggle Highlighting
SQL
#SELECT (COUNT(*) AS ?num) #WHERE #{ SELECT (?personLabel AS ?name) ?born ?dead (?birthPlaceLabel AS ?birthPlace) (?birthPlaceCountryLabel AS ?birthPlaceCountry) (?personDescription AS ?description) ?popularity #?wikipediaArticle WHERE { ?person wdt:P31 wd:Q5; wikibase:sitelinks ?popularity. FILTER (?popularity > 20). ?person rdfs:label ?personLabel. FILTER(LANG(?personLabel) = "en"). OPTIONAL { ?person wdt:P569 ?born. } OPTIONAL { ?person wdt:P570 ?dead. } OPTIONAL { ?person wdt:P19 ?birthPlace. ?birthPlace rdfs:label ?birthPlaceLabel. FILTER(LANG(?birthPlaceLabel) = "en"). } OPTIONAL { FILTER(BOUND(?birthPlace)). ?birthPlace wdt:P17 [ rdfs:label ?birthPlaceCountryLabel ] FILTER(LANG(?birthPlaceCountryLabel) = "en"). } #OPTIONAL { # ?wikipediaArticle schema:about ?person. # ?wikipediaArticle schema:isPartOf <https://en.wikiquote.org/>. #} #SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } LIMIT 10000 #}
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...