Difference between revisions of "Speakers"

Latest revision as of 23:39, 13 January 2022

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: @@
-<div style="color:red; text-align: center;">
+<languages/>
-The SPARQL endpoint isn't ready yet, come back in a few days :)
+{| style="width:100%"
-</div>
+|- style="vertical-align:top;padding:.5em;"
+| style="padding-right:.5em;"|
-<query>
+<query _pagination="50" locutor="<translate><!--T:4--> item</translate>" locutorLabel="<translate><!--T:5--> Speaker username</translate>" place="<translate><!--T:6--> Place of residence</translate>">
      PREFIX wd: <http://www.wikidata.org/entity/>
      PREFIX wdt: <http://www.wikidata.org/prop/direct/>
      select distinct ?locutor ?locutorLabel ?place
      where {
          ?locutor prop:P2 entity:Q3 .
          #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?locutor prop:P4 entity:[EXTRA] .
+           ?locutor prop:P14 ?location .
+           BIND(uri(concat("http://www.wikidata.org/entity/", IF( isBLANK(?location), 'Q2', ?location ))) as ?locationItem).
-           ?locutor prop:P12 ?location .
-           BIND(uri(concat("http://www.wikidata.org/entity/", ?location)) as ?locationItem).
            SERVICE <https://query.wikidata.org/sparql> {
-             #extra:{"type":"wikidata", "label":"P12"} ?locationItem wdt:P131*/wdt:P131? wd:[EXTRA] .
+             #extra:{"type":"wikidata", "label":"P14"} ?locationItem wdt:P131*/wdt:P131? wd:[EXTRA] .
              ?locationItem rdfs:label ?place .
-             FILTER (LANG(?place) = "fr") .
+             FILTER (LANG(?place) = "[AUTO_LANGUAGE]") .
            }
+          SERVICE wikibase:label {
-        SERVICE wikibase:label {
+             bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
-             bd:serviceParam wikibase:language "fr,en" .
          }
      }
 </query>
+|
+<query _pagination="100" languages="<translate><!--T:7--> Number of speakers</translate>" records="<translate><!--T:8--> Number of records</translate>">
+select (COUNT(DISTINCT ?speaker) as ?speakers)
+where {
+  ?speaker prop:P2 entity:Q3 .
+}
+</query>
+|}
+[[Category:Lingua Libre:DataViz{{#translation:}}]]