LinguaLibre
Difference between revisions of "Speakers"
(Marked this version for translation) |
|||
(24 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | < | + | <languages/> |
− | + | {| 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 wd: <http://www.wikidata.org/entity/> | ||
PREFIX wdt: <http://www.wikidata.org/prop/direct/> | PREFIX wdt: <http://www.wikidata.org/prop/direct/> | ||
− | |||
select distinct ?locutor ?locutorLabel ?place | 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] . | ||
− | |||
− | |||
?locutor prop:P14 ?location . | ?locutor prop:P14 ?location . | ||
− | BIND(uri(concat("http://www.wikidata.org/entity/", ?location)) as ?locationItem). | + | BIND(uri(concat("http://www.wikidata.org/entity/", IF( isBLANK(?location), 'Q2', ?location ))) as ?locationItem). |
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
#extra:{"type":"wikidata", "label":"P14"} ?locationItem wdt:P131*/wdt:P131? wd:[EXTRA] . | #extra:{"type":"wikidata", "label":"P14"} ?locationItem wdt:P131*/wdt:P131? wd:[EXTRA] . | ||
?locationItem rdfs:label ?place . | ?locationItem rdfs:label ?place . | ||
− | FILTER (LANG(?place) = " | + | FILTER (LANG(?place) = "[AUTO_LANGUAGE]") . |
− | } | + | } |
− | + | SERVICE wikibase:label { | |
− | + | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | |
− | bd:serviceParam wikibase:language " | ||
} | } | ||
} | } | ||
</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
|
|