query-e2957416d884e782d67368a910de14b6

rq turtle/ttl

Politicians with start date qualifiers before their end dates including details from two separate terms of office: (P39)position held to only look at politicians. Most of these are due to a single (P580)start time Adapted from a complex constraint on

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX pqv: <http://www.wikidata.org/prop/qualifier/value/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?itemDescription { 
  ?statement pqv:P580 ?start_node; pqv:P582 ?end_node . 
  ?start_node wikibase:timePrecision 11; wikibase:timeValue ?start . 
  ?end_node wikibase:timePrecision 11; wikibase:timeValue ?end . 
  FILTER( ?end < ?start ) . 
  ?item ?p ?statement ; wdt:P106 wd:Q82955 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?end") v5("?end_node") v6("?item"):::projected v7("?p") v2("?start") v4("?start_node") v3("?statement") c4(["11^^xsd:integer"]):::literal c9(["bd:serviceParam"]):::iri c11(["en"]):::literal c7(["wd:Q82955"]):::iri f0[["?end < ?start"]] f0 --> v1 f0 --> v2 v3 --"pqv:P580"--> v4 v3 --"pqv:P582"--> v5 v4 --"wikibase:timePrecision"--> c4 v4 --"wikibase:timeValue"--> v2 v5 --"wikibase:timePrecision"--> c4 v5 --"wikibase:timeValue"--> v1 v6 -->v7--> v3 v6 --"wdt:P106"--> c7 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 end