query-6fb1a31f30b4d2a7d98e9b5dbef59d41

rq turtle/ttl

Propertieslanguage of work or name (P407)OCLC control number (P243)DNB edition ID (P1292)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?sLabel ?s ?languageLabel ?ocnURI ?dnbURI
WHERE {
  ?s rdfs:label ?sLabel ;
     wdt:P407 ?language ;
     wdt:P243 ?ocn ;
     wdt:P1292 ?dnb .
  BIND(URI(CONCAT('http://www.worldcat.org/oclc/', ?ocn)) AS ?ocnURI)
  BIND(URI(CONCAT('http://d-nb.info/', ?dnb)) AS ?dnbURI)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?sLabel
LIMIT 100

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?dnb") v7("?dnbURI"):::projected v3("?language") v4("?ocn") v6("?ocnURI"):::projected v2("?s"):::projected v1("?sLabel"):::projected c6(["bd:serviceParam"]):::iri c8(["en"]):::literal v2 --"rdfs:label"--> v1 v2 --"wdt:P407"--> v3 v2 --"wdt:P243"--> v4 v2 --"wdt:P1292"--> v5 bind0[/"concat('http://www.worldcat.org/oclc/',?ocn)"/] v4 --o bind0 bind0 --as--o v6 bind1[/"concat('http://d-nb.info/',?dnb)"/] v5 --o bind1 bind1 --as--o v7 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 end