query-9933c4648fdd273b8761b1d581d8bdcc
All Vidhan sabha terms of a single person SELECT DISTINCT ?constituencyLabel ?partyLabel ?start ?electionLabel ?end ?causeLabel { wd:Q28968902 p:P39 ?positionStatement . # all positions held by V. Sugnana Kumari Deo ?positionStatement ps:P39 [wdt:P279* wd:Q24546266] . # filter to positions which are a subclass of MLA, Odisha OPTIONAL { ?positionStatement pq:P768 ?constituency . } # then find various specific values for each term OPTIONAL { ?positionStatement pq:P4100|pq:P102 ?party . } OPTIONAL { ?positionStatement pq:P580 ?start . } OPTIONAL { ?positionStatement pq:P2715 ?election . } OPTIONAL { ?positionStatement pq:P582 ?end . } OPTIONAL { ?positionStatement pq:P1534 ?cause . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en". } } ORDER BY ?start
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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# All Vidhan sabha terms of a single person
SELECT DISTINCT ?constituencyLabel ?partyLabel ?start ?electionLabel ?end ?causeLabel {
wd:Q28968902 p:P39 ?positionStatement . # all positions held by V. Sugnana Kumari Deo
?positionStatement ps:P39 [wdt:P279* wd:Q24546266] . # filter to positions which are a subclass of MLA, Odisha
OPTIONAL { ?positionStatement pq:P768 ?constituency . } # then find various specific values for each term
OPTIONAL { ?positionStatement pq:P4100|pq:P102 ?party . }
OPTIONAL { ?positionStatement pq:P580 ?start . }
OPTIONAL { ?positionStatement pq:P2715 ?election . }
OPTIONAL { ?positionStatement pq:P582 ?end . }
OPTIONAL { ?positionStatement pq:P1534 ?cause . }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en". }
}
ORDER BY ?start