query-0f89e7c264f046e28cbfd5ee4ff72fc8

rq turtle/ttl

Select Member of Swiss National Council statement SELECT DISTINCT * WHERE { VALUES ?item { wd:Q117117 } # example item

# Select items that have P39 -> Q18510612, then select corresponding statements ?item wdt:P39 wd:Q18510612 .
?item p:P39 ?statement . FILTER EXISTS {?statement ?v wd:Q18510612 . }

OPTIONAL { ?statement pq:P768 ?canton . } OPTIONAL { ?statement pq:P580 ?start_time . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }

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 pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Select Member of Swiss National Council statement
SELECT DISTINCT *
WHERE 
{
  VALUES ?item { wd:Q117117 } # example item

  # Select items that have P39 -> Q18510612, then select corresponding *statements* 
  ?item wdt:P39 wd:Q18510612 .  
  ?item p:P39 ?statement .
  FILTER EXISTS {?statement ?v  wd:Q18510612 .  }

  OPTIONAL { ?statement pq:P768 ?canton . }
  OPTIONAL { ?statement pq:P580 ?start_time . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

• https://www.wikidata.org/wiki/User:Hannes_R%C3%B6st/Queries