query-4250437f24beb7baa7c6a7deda94e77a
Description d'élément
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?item ?itemL ?description_en ?description_fr WHERE {
?item wdt:P17 wd:Q155 ;
wdt:P31/wdt:P279* wd:Q486972 .
?item schema:description ?description_en filter (lang(?description_en) = "en") .
?item schema:description ?description_fr filter (lang(?description_fr) = "fr") .
?item rdfs:label ?itemL filter (lang(?itemL) = "en") .
FILTER((regex(?description_en, "Brazil", "i"))) .
FILTER(!(regex(?description_fr, "Br[eé]sil", "i"))) .
}
ORDER BY ?itemL
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?description_en"):::projected
v2("?description_fr"):::projected
v4("?item"):::projected
v1("?itemL"):::projected
a1((" "))
c10(["wd:Q486972"]):::iri
c7(["wd:Q155"]):::iri
f0[["not regex(?description_fr,'Br#91;eé#93;sil','i')"]]
f0 --> v2
f1[["regex(?description_en,'Brazil','i')"]]
f1 --> v3
f2[["?itemL = 'en'"]]
f2 --> v1
f3[["?description_fr = 'fr'"]]
f3 --> v2
f4[["?description_en = 'en'"]]
f4 --> v3
v4 --"wdt:P17"--> c7
v4 --"wdt:P31"--> a1
a1 --"wdt:P279"--> c10
v4 --"schema:description"--> v3
v4 --"schema:description"--> v2
v4 --"rdfs:label"--> v1