query-9850274c4f7bf5fd4ab6c30ad782051c
P6262 QuickStatements
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?q ("P6262" as ?p6262) ?q_p6262 ("P1810" as ?p1810) ?q_p1810 ("P407" as ?p407) ("Q150" as ?q150) {
?item wdt:P31 wd:Q56582861 .
MINUS { ?item wdt:P6262 [] } .
?item rdfs:label ?labelfr .
FILTER (langMatches(lang(?labelfr), "fr")) .
BIND(REPLACE(str(?item),"http://www.wikidata.org/entity/","") as ?q) .
BIND(xsd:decimal(REPLACE(str(?labelfr),"route impériale ","")) as ?num) .
BIND(REPLACE(str(?labelfr),"route","Route") as ?titre) .
BIND(CONCAT(""routes:",REPLACE(?titre," ","_"),""") as ?q_p6262) .
BIND(CONCAT(""",?titre,""") as ?q_p1810) .
SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" } .
} ORDER BY ?num