query-ad02d96e6c2ea9dc4623677c1d08a9bf

rq turtle/ttl

البلديات الفرنسية بأسماء تنتهي بـac French communes with names ending in ac French communes with names ending in ac Francouzské obce s názvy končícími na ac French communes with names ending in ac Französische Kommunen der Name mit ac endet French communes with names ending in ac French communes with names ending in ac French communes with names ending in ac French communes with names ending in ac French communes with names ending in ac Communes françaises dont le nom finit en ac French communes with names ending in ac French communes with names ending in ac French communes with names ending in ac Comuni francesi con nomi che finiscono in ac French communes with names ending in ac French communes with names ending in ac French communes with names ending in ac French communes with names ending in ac French communes with names ending in ac Franse gemeenten met namen eindigend op ac French communes with names ending in ac French communes with names ending in ac French communes with names ending in ac French communes with names ending in ac French communes with names ending in ac Franska kommuner med namn som slutar på ac French communes with names ending in ac French communes with names ending in ac Французькі комуни з назвами, що закінчуються на ac French communes with names ending in ac 以ac结尾的法国公社

Use at

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#>
#defaultView:Map
SELECT ?item ?itemLabel ?coord
WHERE
{
  ?item wdt:P31/wdt:P279* wd:Q484170;
        wdt:P17 wd:Q142;
        rdfs:label ?itemLabel;
        wdt:P625 ?coord;
  FILTER (lang(?itemLabel) = "fr").
  FILTER regex (?itemLabel, "ac$").
  FILTER not exists { ?item wdt:P131 wd:Q33788 } # excluding Koumac, New Caledonia...
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?coord"):::projected v1("?item"):::projected v2("?itemLabel"):::projected a1((" ")) c7(["wd:Q484170"]):::iri c2(["wd:Q33788"]):::iri c9(["wd:Q142"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P131"--> e0c2 e0v1("?item"):::projected e0c2(["wd:Q33788"]):::iri end f0--EXISTS--> f0e0 f0 --> v1 f0 --> c1 f0 --> c2 v1 --"wdt:P131"--> c2 f1[["regex(?itemLabel,'ac$')"]] f1 --> v2 f2[["?itemLabel = 'fr'"]] f2 --> v2 v1 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c7 v1 --"wdt:P17"--> c9 v1 --"rdfs:label"--> v2 v1 --"wdt:P625"--> v3