query-37e2504a2709d5020e2b4f395c989ee3

rq turtle/ttl

External-ids without P9073

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
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 ?p ?pLabel ?si
WHERE {
  ?p wikibase:propertyType wikibase:ExternalId . 
  ?p wdt:P1629 ?si . 
  ?si wdt:P31 ?inst .
  VALUES ?inst { wd:Q2352616 wd:Q8513 wd:Q3331189 wd:Q386724 wd:Q1789476 wd:Q121182 wd:Q170584 }
  MINUS { ?p wdt:P9073 ?av . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY xsd:integer(?p)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?av") v4("?inst") v1("?p"):::projected v2("?si"):::projected c7(["bd:serviceParam"]):::iri c9(["#91;AUTO_LANGUAGE#93;,en"]):::literal c2(["wikibase:ExternalId"]):::iri v1 --"wikibase:propertyType"--> c2 v1 --"wdt:P1629"--> v2 v2 --"wdt:P31"--> v4 bind0[/VALUES ?inst/] bind0-->v4 bind00(["wd:Q2352616"]) bind00 --> bind0 bind01(["wd:Q8513"]) bind01 --> bind0 bind02(["wd:Q3331189"]) bind02 --> bind0 bind03(["wd:Q386724"]) bind03 --> bind0 bind04(["wd:Q1789476"]) bind04 --> bind0 bind05(["wd:Q121182"]) bind05 --> bind0 bind06(["wd:Q170584"]) bind06 --> bind0 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v1 --"wdt:P9073"--> v4 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end