query-31a2e1afce631a20f94d70706de133d6
The following query works as expected: La següent consulta funciona com esperem: The following query works as expected: Die folgende Abfrage funktioniert wie erwartet: The following query works as expected: The following query works as expected: The following query works as expected: Järgnev päring töötab õigesti: La requête suivante fonctionne comme on s'y attend : השאילתה הבאה עובדת כצפוי: The following query works as expected: Kueri berikut bekerjea sebagaimana yang diharapkan: La seguente query funziona: 以下のクエリは期待通りの動作をします。 The following query works as expected: De volgende query werkt zoals verwacht: The following query works as expected: TODO The following query works as expected: The following query works as expected: The following query works as expected: The following query works as expected: Цей запит працює належним чином: The following query works as expected:
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 ?person ?personLabel (group_concat(?citizenshipLabel;separator="/") as ?citizenships) {
?person wdt:P106 wd:Q3400985 ;
wdt:P27 ?citizenship .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?citizenship rdfs:label ?citizenshipLabel .
?person rdfs:label ?personLabel .
}
} group by ?person ?personLabel having (count(?citizenship) > 2)
Query found at
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/ar
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/ca
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/da
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/de
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/en
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/en-gb
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/es
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/et
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/fr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/he
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/hy
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/id
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/it
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/ja
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/lb
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/nl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/pl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/pt-br
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/ru
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/sv
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/szl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/tr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/uk
- https://www.wikidata.org/wiki/Wikidata:SPARQL_tutorial/zh