Difference between revisions of "Speakers"

Revision as of 06:24, 28 August 2018

Other languages:

Bahasa Melayu • ‎Canadian English • ‎Deutsch • ‎English • ‎Esperanto • ‎Taqbaylit • ‎brezhoneg • ‎español • ‎français • ‎norsk bokmål • ‎occitan • ‎polski • ‎svenska • ‎македонски • ‎বাংলা • ‎日本語

... Loading ...

@@ Line 1: / Line 1: @@
-{{DataViz
+<languages/>
- | query = select ?record ?recordLabel ?locutorLabel ?languageLabel ?languageLevelLabel
+<query _pagination="50" locutor="item" locutorLabel="Speaker username" place="Place of residence">
-            where {
+    PREFIX wd: <http://www.wikidata.org/entity/>
-              ?record prop:P2 entity:Q2 .
+    PREFIX wdt: <http://www.wikidata.org/prop/direct/>
-              ?record prop:P5 ?locutor .
-              ?record prop:P4 ?language .
-              ?locutor llp:P4 ?languageStatement .
+    select distinct ?locutor ?locutorLabel ?place
-              ?languageStatement llv:P4 ?language .
+    where {
-              ?languageStatement llq:P13 ?languageLevel .
+        ?locutor prop:P2 entity:Q3 .
+        #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?locutor prop:P4 entity:[EXTRA] .
-              SERVICE wikibase:label {
-                bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr,en" .
+          ?locutor prop:P14 ?location .
-              }
+          BIND(uri(concat("http://www.wikidata.org/entity/", IF( isBLANK(?location), 'Q2', ?location ))) as ?locationItem).
-            } ORDER BY ?languageLabel ?languageLevelLabel
+          SERVICE <https://query.wikidata.org/sparql> {
-}}
+            #extra:{"type":"wikidata", "label":"P14"} ?locationItem wdt:P131*/wdt:P131? wd:[EXTRA] .
+            ?locationItem rdfs:label ?place .
+            FILTER (LANG(?place) = "[AUTO_LANGUAGE]") .
+          }
+        SERVICE wikibase:label {
+            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
+        }
+    }
+</query>