Help

Difference between revisions of "SPARQL"

Line 54: Line 54:
 
}
 
}
 
</query>
 
</query>
|}<!--
+
|}
 
== Speaker name → Speaker Qid ==
 
== Speaker name → Speaker Qid ==
 
== Speaker Qid → Speaker data ==
 
== Speaker Qid → Speaker data ==
Line 69: Line 69:
 
== Tools ==
 
== Tools ==
 
* [[Special:ApisSandbox]] – API queries generator for Lingualibre wikipage and wikibase contents.
 
* [[Special:ApisSandbox]] – API queries generator for Lingualibre wikipage and wikibase contents.
-->
 

Revision as of 23:45, 3 December 2021

Base

✅ Property Gender(Q7) → list all possible values

SELECT ?item ?itemLabel
WHERE {
  ?item prop:P2/prop:P9 * entity:Q7
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
  } 
}
... Loading ...

✅ Query → list all speakers

select ?locutor ?locutorLabel
where {
  ?locutor prop:P2 entity:Q3 .
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
  } 
}
... Loading ...

Speaker name → Speaker Qid

Speaker Qid → Speaker data

Speaker Qid → Speaker data → speaker languages

Speaker Qid + language → list of audios in target language

Isolang → Language LL Qid

Isolang → Language WD Qid

Language WD Qid → Language data

Language LL Qid → Language data

Langue + speaker + word → Audio's Qid

Audio Qid → Audio data

✅ Langue + speaker + word → Audio's Commons url

Tools