User
Yug/Gallery
< User:YugRevision as of 14:00, 10 August 2022 by Yug (talk | contribs) (→✅ Languages with media type video → written word (P7), url (P3) speakers (P5))
Revision as of 14:00, 10 August 2022 by Yug (talk | contribs) (→✅ Languages with media type video → written word (P7), url (P3) speakers (P5))
✅ Speakers → missing gender value
- This query returns speakers who have missing gender value. See also list of genders.
SELECT ?speaker ?speakerLabel ?gender ?language ?languageLabel (COUNT(?audio) AS ?audio)
WHERE {
?speaker prop:P2 entity:Q3 .
FILTER NOT EXISTS { ?speaker prop:P8 ?gender }
?audio prop:P5 ?speaker . # Filter: P5 'speaker'
?audio prop:P4 ?language . # Filter: P4 'language'
# Add labels
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"}
}
GROUP BY ?speaker ?speakerLabel ?genderLabel ?language ?languageLabel # Sorting first groups per language and speaker
ORDER BY DESC (?audio)
|
|
Language LL Qid → List speakers
This query is going to be DEPRECATED as the queried data will no longer be available.
SELECT ?language ?speaker ?speakerLabel ?genderLabel (COUNT(?audio) AS ?audio)
WHERE {
VALUES ?language { entity:Q150 }
?speaker prop:P2 entity:Q3 . # P2 'instance of' is Q3 'speaker'
?speaker prop:P4 ?language . # P4 'language'
?speaker prop:P8 ?gender . # P8 'language'
# Audios
?audio prop:P5 ?speaker . # Filter: P5 'speaker'
?audio prop:P4 ?language . # Filter: P4 'language'
# Add labels
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"}
}
GROUP BY ?language ?speaker ?speakerLabel ?genderLabel
ORDER BY DESC (?audio)
|
|
Speaker Qid + Language LL Qid → List records
This query is going to be DEPRECATED as the queried data will no longer be available.
SELECT ?speakerLabel ?languageLabel ?audioLabel ?filename
WHERE {
VALUES ?speakers { entity:Q214043 entity:Q43323 }
?audio prop:P5 ?speakers . # Filter: P5 Speaker
?audio prop:P5 ?speaker . # Filter: P5 Speaker
?audio prop:P4 ?language . # Filter: P4 language
?audio prop:P3 ?filename .
# ?speaker prop:P8 ?gender
# Add labels
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
}
}
|
|