query-404a1a5a12f11959ed70614d3e9099c2
title:Persons with Italian and Latin names + matches with SBN SELECT DISTINCT ?it ?la ?item (URI(CONCAT("https://flt.hf.uio.no/author/",?flt,"/")) AS ?fltURL) (URI(CONCAT("https://opac.sbn.it/nome/",?sbn,"/")) AS ?sbnURL) WHERE { ?item wdt:P11336 ?flt . OPTIONAL { ?item wdt:P396 ?sbn } . OPTIONAL { ?item rdfs:label ?it . FILTER(LANG(?it) = 'it') . } OPTIONAL { ?item rdfs:label ?la . FILTER(LANG(?la) = 'la') . } } ORDER BY ?it
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#title:Persons with Italian and Latin names + matches with SBN
SELECT DISTINCT ?it ?la ?item
(URI(CONCAT("https://flt.hf.uio.no/author/",?flt,"/")) AS ?fltURL)
(URI(CONCAT("https://opac.sbn.it/nome/",?sbn,"/")) AS ?sbnURL)
WHERE {
?item wdt:P11336 ?flt .
OPTIONAL { ?item wdt:P396 ?sbn } .
OPTIONAL { ?item rdfs:label ?it . FILTER(LANG(?it) = 'it') . }
OPTIONAL { ?item rdfs:label ?la . FILTER(LANG(?la) = 'la') . }
}
ORDER BY ?it
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?flt"):::projected
v6("?fltURL")
v1("?it"):::projected
v3("?item"):::projected
v2("?la"):::projected
v5("?sbn"):::projected
v7("?sbnURL")
v3 --"wdt:P11336"--> v4
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P396".-> v5
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v3 -."rdfs:label".-> v1
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v3 -."rdfs:label".-> v2
end
bind0[/"concat('https://flt.hf.uio.no/author/',?flt,'/')"/]
v4 --o bind0
bind0 --as--o v6
bind1[/"concat('https://opac.sbn.it/nome/',?sbn,'/')"/]
v5 --o bind1
bind1 --as--o v7