query-f77ba567f6fb05e30b0c98eeda14c339
Honda Sports Award alma mater): Wikidata:Project chatOriginal query (from when the article does not have a photo. That last aspect might be tricky (although maybe not because one could check to see if there is an image), but I already have a list of winners for which there is no photo, so if I have a list of all winners and their alma mater, I can merge that with my list and identify those without photos.(Q5892712)Honda Sports Award I need some help creating a query. what I really want is a list of the alma mater for winners of the I see that as a field for educated at but it can include both high school and college. I'm only interested in college but if I get both I think I can figure out how to throw away the high school..(Q5892712)Honda Sports Award There are a number of Honda sports awards such as on the sports award for volleyball, on the sports award for basketball but all of them should be part of My goal is to generate a list that I can dump into Excel for other purposes.00:28, 12 July 2020 (UTC)) talk (SphilbrickIt may be helpful to point out that there are 487 award winners, 314 of which have Wikipedia articles. 144 these articles do have a photo, and 170 do not. --: Try this: Sphilbrick@
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?person ?personLabel ?school ?schoolLabel WHERE {
?person wdt:P166/wdt:P31 wd:Q5892712.
?person wdt:P69 ?school.
?school wdt:P31/wdt:P279* wd:Q38723.
# uncomment the line below to restrict to those without an image in Wikidata
# MINUS {?person wdt:P18 []}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}