query-7895a62e86e35628f1f11f12f3f8d25d
Places in France whose names end in "ange". a thread on RedditCreated in response to
Use at
- https://query.wikidata.org/sparql
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#>
SELECT ?city ?name WHERE {
?city wdt:P17 wd:Q142;
wdt:P625 [].
?city rdfs:label ?name FILTER (lang(?name)="fr") FILTER ( REGEX(?name, "ange$", "") )
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?city"):::projected
v1("?name"):::projected
a1((" "))
c5(["wd:Q142"]):::iri
f0[["regex(?name,'ange$','')"]]
f0 --> v1
f1[["?name = 'fr'"]]
f1 --> v1
v2 --"wdt:P17"--> c5
v2 --"wdt:P625"--> a1
v2 --"rdfs:label"--> v1