User:Oravrattas/daynotes/2017-06-20

Member of Parliament (Q16707842) where electoral district (P768) != constituency of the House of Commons (Q27971968)

SELECT DISTINCT ?who ?whoLabel ?constituency ?constituencyLabel {
  ?who p:P39 [ ps:P39 wd:Q16707842 ; pq:P768 ?constituency ] .
  FILTER NOT EXISTS { ?constituency wdt:P31 wd:Q27971968 }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
ORDER BY ?constituencyLabel

Try it!

Members of the 57th Parliament of the United Kingdom (Q29974940) by Constituency

SELECT ?item ?itemLabel ?person ?personLabel {
  ?item wdt:P31 wd:Q27971968 
  FILTER NOT EXISTS { ?item wdt:P576 ?end }
  OPTIONAL { 
     ?person p:P39 ?positionStatement .
     ?positionStatement ps:P39 wd:Q16707842; pq:P2937 wd:Q29974940 ; pq:P768 ?item .
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}
ORDER BY ?itemLabel

Try it!

Turned into a report at Wikidata:WikiProject British Politicians/Report:Q29974940

Members of the 57th Parliament of the United Kingdom (Q29974940) with no Constituency

People with a relevant position held (P39), but no electoral district (P768) qualifier:

Wikidata:WikiProject British Politicians/Report:Q29974940/No constituency