query-aac89881ce1395c26cf678d9f3e6991b

rq turtle/ttl

wikibase:Label and aggregations A query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata, does not show the names of those countries in the ?citizenships column: wikibase: Etiquetes i agregacionsUna consulta com la següent, que busca a Wikidata totes les persones acadèmiques amb ciutadania de més de dos països, no mostra el nom d'aquests països a la columna ?citizenships: wikibase:Label and aggregations A query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata, does not show the names of those countries in the ?citizenships column: wikibase:Label und AggregatEine Abfrage, wie die folgende, die alle Akademiker in Wikidata mit mehr als zwei Staatsangehörigkeiten sucht, gibt die Namen dieser Länder in der ?citizenships-Spalte nicht aus: wikibase:Label and aggregationsA query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata, does not show the names of those countries in the ?citizenships column: wikibase:Label and aggregations bug There is currently (February 2020) a problem with the query service when you want to use the $service service with aggregation functions. A query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata and is supposed to show the names of those countries in an aggregate string: wikibase:Label and aggregations A query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata, does not show the names of those countries in the ?citizenships column: wikibase:Label ja agregeerimine Päringuteenusel on praegu üks puudus, mis ilmneb, kui tahad kasutada $service teenust koos agregeerivate funktsioonidega. Järgnev päring otsib kõiki topeltkodakondusega akadeemilisi isikuid Wikidatas ja peaks tagastama nende riikide nimed agregeeritud sõnena: wikibase:Label et agrégationsUne requête telle que la suivante, qui recherche toutes les personnes académiques avec plus de deux pays de citoyenneté dans Wikidata, n'affiche pas les noms de ces pays dans la colonne ?citizenships : wikibase:Label וכינוסיםשאילתה כמו זו, שמחפשת את כל אנשי האקדמיה עם אזרחות ביותר משתי מדינות בוויקינתונים, לא מציגה את שמות המדינות האלה בעמודה ‎?citizenships: wikibase:Label and aggregations A query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata, does not show the names of those countries in the ?citizenships column: Kutu wikibase:Label dan agregasi Pada saat ini (Februari 2020) terdapat masalah dengan layanan kueri ketika Anda ingin menggunakan layanan $service dengan fungsi agregasi. Kueri seperti yang berikut ini, yang mencari semua tokoh akademik denga nlebih dari dua kewarganegaraan di Wikidata dan seharusnya menampilkan nama negara-negara tersebut di dalam string agregat: wikibase:Label and aggregations A query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata, does not show the names of those countries in the ?citizenships column: wikibase:ラベルと集約2つ以上の国で市民権を持つすべての学者をWikidat内に検索するような、以下のようなクエリでは、これらの国の名前は?citizenships列に表示されません。 wikibase:Label and aggregations A query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata, does not show the names of those countries in the ?citizenships column: wikibase:Label en aggregatiesEen query als de volgende, die alle academische personen met meer dan twee landen van burgerschaps verwacht in Wikidata, laat de namen van die landen niet zien in de kolom ?citizenships: wikibase:Label and aggregations A query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata, does not show the names of those countries in the ?citizenships column: TODO wikibase:Label and aggregations A query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata, does not show the names of those countries in the ?citizenships column: wikibase:Label and aggregations A query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata, does not show the names of those countries in the ?citizenships column: wikibase:Label and aggregations A query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata, does not show the names of those countries in the ?citizenships column: wikibase:Label and aggregations A query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata, does not show the names of those countries in the ?citizenships column: wikibase:Назви й агрегаціїЗапит, подібний до наведеного нижче, який шукає у Вікіданих усіх науковців із більш ніж двома країнами громадянства, не показує назви цих країн у стовпці ?citizenships: wikibase:标签和聚合的bug A query such as the following, which searches all academic persons with more than two countries of citizenships in Wikidata, does not show the names of those countries in the ?citizenships column:

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 bd: <http://www.bigdata.com/rdf#>
select ?person ?personLabel (group_concat(?citizenshipLabel;separator="/") as ?citizenships) {
  # find all academics
  ?person wdt:P106 wd:Q3400985 ;   
          wdt:P27  ?citizenship .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} group by ?person ?personLabel having (count(?citizenship) > 2)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?_anon_42b5416610844a34809f33a099ae9de115224") v2("?citizenship") v3("?citizenshipLabel"):::projected v5("?citizenships") v1("?person"):::projected a1((" ")) c3(["wd:Q3400985"]):::iri c6(["bd:serviceParam"]):::iri c8(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[[" > '2^^xsd:integer'"]] f0 --> a1 v1 --"wdt:P106"--> c3 v1 --"wdt:P27"--> v2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 end bind3[/"count(?citizenship)"/] v2 --o bind3 bind3 --as--o v4 bind4[/"?citizenshipLabel"/] v3 --o bind4 bind4 --as--o v5