query-b06ba0b0450ba151a6dee72590cc16ec

TODO

Use at

https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?value
{
  ?item wdt:P6363 ?dbvalue .

  BIND(URI(REPLACE(STR(?dbvalue), "^(https?://.+/)(.*?)$", "$1")) AS ?value)

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
ORDER BY ?value

Query found at

https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/02

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?dbvalue") v2("?item") v4("?value"):::projected c3(["bd:serviceParam"]):::iri c5(["#91;AUTO_LANGUAGE#93;,en"]):::literal v2 --"wdt:P6363"--> v3 bind0[/"replace(str(?dbvalue),'^(https?://.+/)(.*?)$','$1')"/] v3 --o bind0 bind0 --as--o v4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c3 --"wikibase:language"--> c5 end