query-8f6969f8ff4d486fc6d32100e429f149

rq turtle/ttl

Language Wikipedia's serving African countries, by language SELECT ?item ?itemLabel ?language ?languageLabel (group_concat(distinct ?countryLabel;separator="; ") as ?countries) WHERE { ?item wdt:P31 wd:Q10876391. # it's a language wikipedia ?item wdt:P407 ?language . # in this language ?language wdt:P17 ?country . # language is associated with country ?country wdt:P30 wd:Q15 . # country is in the continent of Africa SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?item rdfs:label ?itemLabel . ?country rdfs:label ?countryLabel . ?language rdfs:label ?languageLabel .} # get labels for values } group by ?item ?itemLabel ?language ?languageLabel # show only one row per language wikipedia / language order by ?itemLabel # sort the results

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
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#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Language Wikipedia's serving African countries, by language
SELECT ?item ?itemLabel ?language ?languageLabel (group_concat(distinct ?countryLabel;separator="; ") as ?countries)
WHERE 
{
  ?item wdt:P31 wd:Q10876391.     # it's a language wikipedia 
  ?item wdt:P407 ?language .      # in this language
  ?language wdt:P17 ?country .    # language is associated with country
  ?country wdt:P30 wd:Q15 .       # country is in the continent of Africa
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
                         ?item rdfs:label ?itemLabel .
                         ?country rdfs:label ?countryLabel .
                         ?language rdfs:label ?languageLabel .}
                                   # get labels for values
} group by ?item ?itemLabel ?language ?languageLabel
                                  # show only one row per language wikipedia / language
order by ?itemLabel               # sort the results

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2020/10