query-f8e65d8a9b67288b4056d0ed34e1bc10

rq turtle/ttl

People who are simultaneously an MP and an MSP

Use at

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#>
SELECT DISTINCT ?who ?whoLabel ?mspLabel ?msp_start ?msp_end ?mp_start ?mp_end {
  ?msp wdt:P279* wd:Q1711695 .
  ?who p:P39 ?posn1 .
  ?who p:P39 ?posn2 .

  ?posn1 ps:P39 ?msp ; pq:P580 ?msp_start .
  OPTIONAL { ?posn1 pq:P582 ?msp_end }
  BIND(if(BOUND(?msp_end), ?msp_end, NOW()) as ?msp_end)

  ?posn2 ps:P39 wd:Q16707842 ; pq:P580 ?mp_start .
  OPTIONAL { ?posn2 pq:P582 ?mp_end }
  BIND(if(BOUND(?mp_end), ?mp_end, NOW()) as ?msp_end)

  FILTER( (?mp_start < ?msp_end) && (?mp_end > ?msp_start) )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
ORDER BY ?whoLabel

Query found at