wikidata_sexuality_but_no_reference.sparql

# query that finds people who have a sexual orientation set
# but for which there is no source.

PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX wikibase: <http://wikiba.se/ontology#>

SELECT DISTINCT ?item ?itemLabel ?statement WHERE {
  ?item wdt:P31 wd:Q5 .
  ?item wdt:P91 ?propValue .
  ?item p:P91 ?statement .
  
  OPTIONAL {
  	?statement prov:wasDerivedFrom ?derivedFrom  .
  }
  FILTER (!BOUND(?derivedFrom))
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 100