query-b0e3ab2a3f4147c7ab3a4da797e3ea5a

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 ?item ?itemLabel ?url ?value {
?item wdt:P16 wd:Q1426271 .
?item wdt:P6262 ?value .
FILTER(STRSTARTS(?value,"routes:")) .
FILTER(!(STRENDS(?value,"(971)")|| STRENDS(?value,"(972)") || STRENDS(?value,"(973)") || STRENDS(?value,"(974)") || STRENDS(?value,"(975)") || STRENDS(?value,"(976)"))) .
BIND(IRI(REPLACE(?value,"routes:","https://routes.fandom.com/wiki/")) AS ?url) .
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" } .
} ORDER BY ?value

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item"):::projected v3("?url"):::projected v1("?value"):::projected c9(["wd:Q1426271"]):::iri c14(["fr"]):::literal c12(["bd:serviceParam"]):::iri f0[["not (ends-with(?value,'(971)') || (ends-with(?value,'(972)') || (ends-with(?value,'(973)') || (ends-with(?value,'(974)') || (ends-with(?value,'(975)') || ends-with(?value,'(976)'))))))"]] f0 --> v1 f1[["starts-with(?value,'routes:')"]] f1 --> v1 v2 --"wdt:P16"--> c9 v2 --"wdt:P6262"--> v1 bind2[/"replace(?value,'routes:','https://routes.fandom.com/wiki/')"/] v1 --o bind2 bind2 --as--o v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end