query-6b17353a87886589be94a8923ef58b6c

rq turtle/ttl

Actors and Actresses born in Switzerland and/or having Swiss Citizenship Actors and Actresses born in Switzerland and/or having Swiss Citizenship Acteurs en actrices geboren in Zwitserland en/of met de Zwitserse nationaliteit

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#>
SELECT ?item 
       ?itemLabel 
       ?birthplaceLabel 
       (group_concat(distinct ?citizenshipLabel_en;separator="; ") as ?citizenshipLabels_en)    #Concatenate the values in order not to get several rows per item.
WHERE 
{
  ?item wdt:P106 wd:Q33999.
  { ?item (wdt:P19/wdt:P131*/wdt:P17) wd:Q39 } UNION { ?item wdt:P27 wd:Q39 }.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language, if not, then en language
  OPTIONAL {?item wdt:P19 ?birthplace} .
  OPTIONAL {?item wdt:P27/rdfs:label ?citizenshipLabel_en . FILTER (lang(?citizenshipLabel_en) = "en") }
}
group by ?item                          #List all the variables for which the values are not concatenated!
         ?itemLabel
         ?birthplaceLabel

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Performing_arts/Tools_%26_tasks
• https://www.wikidata.org/wiki/Wikidata:WikiProject_Performing_arts/Tools_%26_tasks/en
• https://www.wikidata.org/wiki/Wikidata:WikiProject_Performing_arts/Tools_%26_tasks/fr
• https://www.wikidata.org/wiki/Wikidata:WikiProject_Performing_arts/Tools_%26_tasks/nl