LinguaLibre
Difference between revisions of "Records"
m (0x010C moved page DataViz:Records to LinguaLibre:Records: before the deletion of the "DataViz" Namespace) |
|||
| (14 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <query _pagination="100" record="Item" audio="Record" recordLabel="Transcription" locutorLabel="Speaker" langLabel="Language" levelLabel="Language level"> | + | <languages/> |
| + | <translate> | ||
| + | <!--T:1--> | ||
| + | For performance reasons, the maximum number of audio recording shown at a time is 1000. This current page will be enhanced in the future. | ||
| + | </translate> | ||
| + | {| style="width:100%" | ||
| + | |- style="vertical-align:top;padding:.5em;" | ||
| + | | style="padding-right:.5em;"| | ||
| + | <query _pagination="100" record="<translate><!--T:3--> Item</translate>" audio="<translate><!--T:4--> Record</translate>" recordLabel="<translate><!--T:5--> Transcription</translate>" locutorLabel="<translate><!--T:6--> Speaker</translate>" langLabel="<translate><!--T:7--> Language</translate>" levelLabel="<translate><!--T:8--> Language level</translate>"> | ||
select distinct ?record ?audio ?recordLabel ?locutorLabel (if( ?language = entity:Q4, '???', ?languageLabel ) as ?langLabel) (if( ?languageLevel = entity:Q5 || !BOUND(?languageLevel), '???', ?languageLevelLabel ) as ?levelLabel) | select distinct ?record ?audio ?recordLabel ?locutorLabel (if( ?language = entity:Q4, '???', ?languageLabel ) as ?langLabel) (if( ?languageLevel = entity:Q5 || !BOUND(?languageLevel), '???', ?languageLevelLabel ) as ?levelLabel) | ||
where { | where { | ||
| Line 9: | Line 17: | ||
#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 ). | ||
| − | |||
| − | |||
OPTIONAL { | OPTIONAL { | ||
| − | |||
?locutor llp:P4 ?languageStatement . | ?locutor llp:P4 ?languageStatement . | ||
?languageStatement llv:P4 ?language . | ?languageStatement llv:P4 ?language . | ||
| Line 22: | Line 27: | ||
?record prop:P7 ?transcription. | ?record prop:P7 ?transcription. | ||
#extra:{"type": "string", "label": "P7"} filter contains(lcase(?transcription), lcase('[EXTRA]')). | #extra:{"type": "string", "label": "P7"} filter contains(lcase(?transcription), lcase('[EXTRA]')). | ||
| − | |||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| Line 30: | Line 34: | ||
?language rdfs:label ?languageLabel. | ?language rdfs:label ?languageLabel. | ||
} | } | ||
| − | } ORDER BY ?recordLabel | + | } ORDER BY ?recordLabel LIMIT 1000 |
</query> | </query> | ||
| + | | | ||
| + | |||
| + | <query _pagination="100" records="Number of records"> | ||
| + | select (COUNT(DISTINCT ?record) as ?records) | ||
| + | where { | ||
| + | ?record prop:P2 entity:Q2 . | ||
| + | } | ||
| + | </query> | ||
| + | |} | ||
| + | |||
| + | [[Category:Lingua Libre:DataViz{{#translation:}}]] | ||
Latest revision as of 23:28, 13 January 2022
For performance reasons, the maximum number of audio recording shown at a time is 1000. This current page will be enhanced in the future.
|
|
|