query-66d151b756c3b4bb6dbefba51887e60a

SPARQL - label in Deutsch und EnglischList of countries in English and German

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 ?country ?label_en ?label_de
WHERE
{
    ?country wdt:P31 wd:Q6256.
    ?country rdfs:label ?label_en filter (lang(?label_en) = "en").
    ?country rdfs:label ?label_de filter (lang(?label_de) = "de").
}

Query found at

https://www.wikidata.org/wiki/User:MTheiler

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?country"):::projected v1("?label_de"):::projected v2("?label_en"):::projected c4(["wd:Q6256"]):::iri f0[["?label_de = 'de'"]] f0 --> v1 f1[["?label_en = 'en'"]] f1 --> v2 v3 --"wdt:P31"--> c4 v3 --"rdfs:label"--> v2 v3 --"rdfs:label"--> v1