query-f4215a6983ac2865141d00c7616202a2

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 ?item ?itemLabel ?isni ?isniLink ?gnd ?gndLink ?loc ?locLink
WHERE {
   {
  SELECT ?item ?itemLabel ?isni ?gnd ?loc WHERE {
    ?item wdt:P31 wd:Q5 .
    ?item wdt:P213 ?isni .
    MINUS {?item wdt:P214 [] .}
    OPTIONAL {?item wdt:P227 ?gnd.}
    OPTIONAL {?item wdt:P244 ?loc.}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
  }
}
   {
  SELECT * WHERE {
    wd:P213 wdt:P1630 ?isniFormatterUrl.
    wd:P227 wdt:P1630 ?gndFormatterUrl.
    wd:P244 wdt:P1630 ?locFormatterUrl.
  }
}
  BIND(IRI(REPLACE(?isniFormatterUrl, "\\$1", ?isni)) AS ?isniLink)
  BIND(IRI(REPLACE(?gndFormatterUrl, "\\$1", ?gnd)) AS ?gndLink)
  BIND(IRI(REPLACE(?locFormatterUrl, "\\$1", ?loc)) AS ?locLink)
}
ORDER BY DESC(?gnd) DESC(?loc)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?gnd"):::projected v6("?gndFormatterUrl") v9("?gndLink"):::projected v4("?isni"):::projected v5("?isniFormatterUrl") v8("?isniLink"):::projected v3("?item"):::projected v2("?loc"):::projected v7("?locFormatterUrl") v10("?locLink"):::projected a1((" ")) c11(["wd:P213"]):::iri c14(["wd:P244"]):::iri c8(["bd:serviceParam"]):::iri c10(["#91;AUTO_LANGUAGE#93;"]):::literal c13(["wd:P227"]):::iri c2(["wd:Q5"]):::iri v3 --"wdt:P31"--> c2 v3 --"wdt:P213"--> v4 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v3 --"wdt:P214"--> a1 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P227".-> v1 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P244".-> v2 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end c11 --"wdt:P1630"--> v5 c13 --"wdt:P1630"--> v6 c14 --"wdt:P1630"--> v7 bind1[/"replace(?isniFormatterUrl,'\$1',?isni)"/] v5 --o bind1 v4 --o bind1 bind1 --as--o v8 bind2[/"replace(?gndFormatterUrl,'\$1',?gnd)"/] v6 --o bind2 v1 --o bind2 bind2 --as--o v9 bind3[/"replace(?locFormatterUrl,'\$1',?loc)"/] v7 --o bind3 v2 --o bind3 bind3 --as--o v10