LinguaLibre
Difference between revisions of "Stats"
(Marked this version for translation) |
(+Languages) |
||
(3 intermediate revisions by one other user not shown) | |||
Line 26: | Line 26: | ||
?record prop:P2 entity:Q2 . | ?record prop:P2 entity:Q2 . | ||
?record prop:P4 ?lang . | ?record prop:P4 ?lang . | ||
− | |||
− | |||
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | ||
Line 42: | Line 40: | ||
<!--T:8--> | <!--T:8--> | ||
− | <query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records"> | + | <query _pagination="10" locutor="Item" locutorLabel="Speaker" nb="Number of records" languages="Spoken languages"> |
− | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) | + | select ?locutor ?locutorLabel (COUNT(?record) as ?nb) (GROUP_CONCAT(DISTINCT ?langLabel;separator=", ") as ?languages) |
where { | where { | ||
?record prop:P2 entity:Q2 . | ?record prop:P2 entity:Q2 . | ||
Line 49: | Line 47: | ||
?record prop:P4 ?lang . | ?record prop:P4 ?lang . | ||
#extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] . | #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] . | ||
− | |||
− | |||
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | ||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
+ | ?lang rdfs:label ?langLabel . | ||
+ | ?locutor rdfs:label ?locutorLabel . | ||
} | } | ||
} | } | ||
Line 73: | Line 71: | ||
?record prop:P7 ?transcription. | ?record prop:P7 ?transcription. | ||
− | |||
− | |||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . |