LinguaLibre
Difference between revisions of "Speakers"
(Marked this version for translation) |
|||
| (31 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <query> | + | <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 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: | + | BIND(uri(concat("http://www.wikidata.org/entity/", IF( isBLANK(?location), 'Q2', ?location ))) as ?locationItem). |
| − | BIND(uri(concat("http://www.wikidata.org/entity/", ?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] . | |
| − | + | ?locationItem rdfs:label ?place . | |
| − | } | + | FILTER (LANG(?place) = "[AUTO_LANGUAGE]") . |
| − | + | } | |
| − | + | SERVICE wikibase:label { | |
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | 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
|
|
|