query-950f55a51bca727ce113fdd2177ac09f

rq turtle/ttl

PropertiesPM20 folder ID (P4293)instance of (P31)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select distinct ?item ?itemLabel ?pm20Id
where {
  ?item wdt:P4293 ?pm20Id .
  filter(strstarts(?pm20Id, 'sh/'))
  filter( not exists {
    ?item wdt:P31 wd:Q91257459 .
  })
  SERVICE wikibase:label { bd:serviceParam wikibase:language "AUTO_LANGUAGE,en,de". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?item"):::projected v2("?pm20Id"):::projected c6(["bd:serviceParam"]):::iri c8(["AUTO_LANGUAGE,en,de"]):::literal c2(["wd:Q91257459"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P31"--> e0c2 e0v1("?item"):::projected e0c2(["wd:Q91257459"]):::iri end f0--EXISTS--> f0e0 f0 --> v1 f0 --> c1 f0 --> c2 v1 --"wdt:P31"--> c2 f1[["starts-with(?pm20Id,'sh/')"]] f1 --> v2 v1 --"wdt:P4293"--> v2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 end