query-b9e37d9fb35519384a6e02c08e655a63

rq turtle/ttl

Propertiesinstance of (P31)   subclass of (P279)   located in the administrative territorial entity (P131)   position held (P39)  

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
1 PREFIX q: <http://www.wikidata.org/prop/qualifier/>
 2 PREFIX v: <http://www.wikidata.org/prop/statement/>
 3 
 4 SELECT ?of
 5 (GROUP_CONCAT(DISTINCT ?of_in ; separator = ",") AS ?of_in)
 6 (GROUP_CONCAT(DISTINCT ?of_in_label ; separator = ",") AS ?of_in_label)
 7 (GROUP_CONCAT(DISTINCT ?of_number ; separator = ",") AS ?of_number)
 8 WHERE {
 9     ?person wdt:P31 wd:Q5 .
10     ?person p:P39 ?mandate .
11     ?mandate v:P39 wd:Q3044918 .
12     ?mandate q:P768 ?of .
13     ?of wdt:P31/wdt:P279* wd:Q15620943 .
14     ?of wdt:P131 ?of_in .
15     ?mandate q:P580 ?start .
16     FILTER (?start >= "1958-12-09T00:00:00Z"^^xsd:dateTime)
17     OPTIONAL { ?of_in rdfs:label ?of_in_label filter (lang(?of_in_label) = "fr") . }
18     OPTIONAL { ?of p:P31 ?p31 . ?p31 q:P1545 ?of_number . }
19 }
20 GROUP BY ?of

Query found at