Difference between revisions of "Records"

Revision as of 10:42, 25 January 2019

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

... Loading ...

@@ Line 1: / Line 1: @@
-<div style="color:red; text-align: center;">
+For performance reasons, the maximum number of audio recording shown at a time is 1000. This will be enhanced in the future.
-The SPARQL endpoint isn't ready yet, come back in a few days :)
-</div>
-<query record="item" recordLabel="transcription" locutorLabel="locuteur" languageLabel="langue" languageLevelLabel="Niveau de langue">
+<query _pagination="100" record="Item" audio="Record" recordLabel="Transcription" locutorLabel="Speaker" langLabel="Language" levelLabel="Language level">
-     select distinct ?record ?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 {
          ?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 .
@@ Line 18: / Line 17: @@
            ?locutor llp:P4 ?languageStatement .
            ?languageStatement llv:P4 ?language .
-           ?languageStatement llq:P13 ?level .
+           ?languageStatement llq:P16 ?level .
-           #extra:{"type": "wikibase-item", "filter":"Q5", "label": "P13", "multiple": true} ?languageStatement llq:P13 entity:[EXTRA] .
+           #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:P8 ?transcription.
+         ?record prop:P7 ?transcription.
-         #extra:{"type": "string", "label": "P8"}  filter contains(lcase(?transcription), lcase('[EXTRA]')).
+         #extra:{"type": "string", "label": "P7"}  filter contains(lcase(?transcription), lcase('[EXTRA]')).
          SERVICE wikibase:label {
@@ Line 33: / Line 32: @@
              ?language rdfs:label ?languageLabel.
          }
-     } ORDER BY ?recordLabel
+     } ORDER BY ?recordLabel LIMIT 1000
 </query>