Difference between revisions of "LinguaLibre:Records"

(10 intermediate revisions by the same user not shown)

Line 1:

−

+

−

select ?record ?recordLabel ?locutorLabel ?languageLabel ?languageLevelLabel

+

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 ?~~language~~ .

+

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

−

~~?locutor llp:P4 ?languageStatement .~~

−

~~?languageStatement llv:P4 ?language .~~

−

~~?languageStatement llq:P13 ?languageLevel .~~

−

~~#extra:{"type": "wikibase-item", "filter":"Q5", "label": "P13", "multiple": true} ?languageStatement llq:P13 entity:[EXTRA] .~~

−

?record prop:P8 ?transcription.

+

OPTIONAL {

−

#extra:{"type": "string", "label": "P8"} filter contains(lcase(?transcription), lcase('[EXTRA]')).

+

?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 ?~~languageLabel ?languageLevelLabel~~

+

} ORDER BY ?recordLabel

</query>

LinguaLibre

Difference between revisions of "Records"

Revision as of 09:23, 25 December 2018

@@ Line 1: / Line 1: @@
-<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 ?record ?recordLabel ?locutorLabel ?languageLabel ?languageLevelLabel
+     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 ?language .
+         ?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 ).
-        ?locutor llp:P4 ?languageStatement .
-        ?languageStatement llv:P4 ?language .
-        ?languageStatement llq:P13 ?languageLevel .
-        #extra:{"type": "wikibase-item", "filter":"Q5", "label": "P13", "multiple": true} ?languageStatement llq:P13 entity:[EXTRA] .
-         ?record prop:P8 ?transcription.
+      	OPTIONAL {
-         #extra:{"type": "string", "label": "P8"}  filter contains(lcase(?transcription), lcase('[EXTRA]')).
+          ?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 ?languageLabel ?languageLevelLabel
+     } ORDER BY ?recordLabel
 </query>