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

Other languages:
Deutsch • ‎English • ‎Esperanto • ‎brezhoneg • ‎français • ‎norsk bokmål • ‎occitan • ‎polski • ‎svenska • ‎македонски • ‎русский • ‎বাংলা • ‎தமிழ் • ‎日本語

For performance reasons, the maximum number of audio recording shown at a time is 1000. This current page will be enhanced in the future.

... Loading ...
... Loading ...