LinguaLibre

Difference between revisions of "Speakers"

(Marked this version for translation)
 
(32 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<query>
+
<languages/>
     select distinct ?locutor ?locutorLabel
+
{| style="width:100%"
 +
|- style="vertical-align:top;padding:.5em;"
 +
| style="padding-right:.5em;"|
 +
<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 {
 
     where {
 
         ?locutor prop:P2 entity:Q3 .
 
         ?locutor prop:P2 entity:Q3 .
 
         #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?locutor prop:P4 entity:[EXTRA] .
 
         #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?locutor prop:P4 entity:[EXTRA] .
        SERVICE wikibase:label {
+
          ?locutor prop:P14 ?location .
             bd:serviceParam wikibase:language "fr,en" .
+
          BIND(uri(concat("http://www.wikidata.org/entity/", IF( isBLANK(?location), 'Q2', ?location ))) as ?locationItem).
 +
 
 +
          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>
 
</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:}}]]

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 ...
... Loading ...