query-3f6defbae50a6bc203df654707cd7cea

rq turtle/ttl

TODO

Use at

• https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?item ?itemLabel ?itemDescription
                          # we take the results of this named query - a list of ?item and ?citizenship_count
where 
{
   { SELECT ?item (count(distinct ?citizenships) as ?citizenship_count) WHERE 
{
  ?item wdt:P106 wd:Q10833314 . # they're a tennis player
  ?item wdt:P27 wd:Q31.         # they're Belgian
  ?item wdt:P27 ?citizenships.  # get any & all of their citizenships - this creates one row per citizenship
} group by ?item  }                   # and run a second query over the results
  filter (?citizenship_count<2) # rejecting rows where the count is more than 1
  optional {?item rdfs:label ?itemLabel. filter(lang(?itemLabel)="fr")}                     # get labels
  optional {?item schema:description ?itemDescription. filter(lang(?itemDescription)="fr")} # get descriptions
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2018/09