LinguaLibre
Difference between revisions of "Speakers"
(to allow translating the column title) |
(Marked this version for translation) |
||
| (9 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
| − | + | {| style="width:100%" | |
| − | <query _pagination="50" locutor="item" locutorLabel="Speaker username" place="Place of residence"> | + | |- 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/", IF( isBLANK(?location), 'Q2', ?location ))) as ?locationItem). | BIND(uri(concat("http://www.wikidata.org/entity/", IF( isBLANK(?location), 'Q2', ?location ))) as ?locationItem). | ||
| Line 18: | Line 17: | ||
?locationItem rdfs:label ?place . | ?locationItem rdfs:label ?place . | ||
FILTER (LANG(?place) = "[AUTO_LANGUAGE]") . | FILTER (LANG(?place) = "[AUTO_LANGUAGE]") . | ||
| − | } | + | } |
| − | + | SERVICE wikibase:label { | |
| − | |||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
} | } | ||
} | } | ||
| − | </query></translate> | + | </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
|
|
|