Difference between revisions of "Records"

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 ...

@@ Line 1: / Line 1: @@
-{{DataViz
+<languages/>
- | query = select ?record ?recordLabel ?locutorLabel ?languageLabel ?languageLevelLabel
+<translate>
-            where {
+<!--T:1-->
-              ?record prop:P2 entity:Q2 .
+For performance reasons, the maximum number of audio recording shown at a time is 1000. This current page will be enhanced in the future.
-              ?record prop:P5 ?locutor .
+</translate>
-              #extra:{"type": "wikibase-item", "filter":"Q3", "label": "P5", "multiple": true} ?record prop:P5 entity:[EXTRA] .
+{| style="width:100%"
-              ?record prop:P4 ?language .
+|- style="vertical-align:top;padding:.5em;"
-              #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
+| 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)
+    where {
+        ?record prop:P2 entity:Q2 .
+        ?record prop:P5 ?locutor .
+        ?record prop:P3 ?audio .
+        #extra:{"type": "wikibase-item", "filter":"Q3", "label": "P5", "multiple": true} ?record prop:P5 entity:[EXTRA] .
+        ?record prop:P4 ?lang .
+        #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] .
+        BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ).
+      	OPTIONAL {
+          ?locutor llp:P4 ?languageStatement .
+          ?languageStatement llv:P4 ?language .
+          ?languageStatement llq:P16 ?level .
+          #extra:{"type": "wikibase-item", "filter":"Q5", "label": "P16", "multiple": true} ?languageStatement llq:P16 entity:[EXTRA] .
+          BIND( IF( isBLANK(?level), entity:Q5, ?level ) as ?languageLevel ).
+		}
+        ?record prop:P7 ?transcription.
+        #extra:{"type": "string", "label": "P7"}  filter contains(lcase(?transcription), lcase('[EXTRA]')).
+        SERVICE wikibase:label {
+            bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
+            ?languageLevel rdfs:label ?languageLevelLabel.
+            ?record rdfs:label ?recordLabel.
+            ?locutor rdfs:label ?locutorLabel.
+            ?language rdfs:label ?languageLabel.
+        }
+    } ORDER BY ?recordLabel LIMIT 1000
+</query>
+|
-              ?locutor llp:P4 ?languageStatement .
+<query _pagination="100" records="Number of records">
-              ?languageStatement llv:P4 ?language .
+select (COUNT(DISTINCT ?record) as ?records)
-              ?languageStatement llq:P13 ?languageLevel .
+where {
-              #extra:{"type": "wikibase-item", "filter":"Q5", "label": "P13", "multiple": true} ?languageStatement llq:P13 entity:[EXTRA] .
+  ?record prop:P2 entity:Q2 .
+}
+</query>
+|}
-              SERVICE wikibase:label {
+[[Category:Lingua Libre:DataViz{{#translation:}}]]
-                bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
-              }
-            } ORDER BY ?languageLabel ?languageLevelLabel
-}}