query-3d3d3554c38a743dafbc412b076985d2

rq turtle/ttl

Imported from something else than a Wikimedia project

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 prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?p ?reference ?referenceLabel WITH {
#SELECT ?reference ?referenceLabel (COUNT(*) AS ?cnt) WHERE {
   {
  SELECT DISTINCT ?item WHERE {
    ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 .
  }
}.
  ?item ?p [ prov:wasDerivedFrom/pr:P143 ?reference ] .
  MINUS { ?reference wdt:P31/wdt:P279* wd:Q14827288 }
  SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}# GROUP BY ?reference ?referenceLabel

Query found at