query-04308f224b833eee548604caca5031d2
added before 2016-10 SELECT ?item ?itemLabel ?coord WHERE { ?item (wdt:P31/wdt:P279*) wd:Q486972. ?item wdt:P17 wd:Q142. ?item rdfs:label ?itemLabel. ?item wdt:P625 ?coord. FILTER((LANG(?itemLabel)) = "fr") FILTER(REGEX(?itemLabel, "ac$")) }
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#>
#added before 2016-10
SELECT ?item ?itemLabel ?coord WHERE {
?item (wdt:P31/wdt:P279*) wd:Q486972.
?item wdt:P17 wd:Q142.
?item rdfs:label ?itemLabel.
?item wdt:P625 ?coord.
FILTER((LANG(?itemLabel)) = "fr")
FILTER(REGEX(?itemLabel, "ac$"))
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?coord"):::projected
v2("?item"):::projected
v1("?itemLabel"):::projected
a1((" "))
c5(["wd:Q486972"]):::iri
c7(["wd:Q142"]):::iri
f0[["regex(?itemLabel,'ac$')"]]
f0 --> v1
f1[["?itemLabel = 'fr'"]]
f1 --> v1
v2 --"wdt:P31"--> a1
a1 --"wdt:P279"--> c5
v2 --"wdt:P17"--> c7
v2 --"rdfs:label"--> v1
v2 --"wdt:P625"--> v3