User
Difference between revisions of "Yug/Gallery"
< User:Yug
| (6 intermediate revisions by the same user not shown) | |||
| Line 9: | Line 9: | ||
?speaker prop:P2 entity:Q3 . | ?speaker prop:P2 entity:Q3 . | ||
FILTER NOT EXISTS { ?speaker prop:P8 ?gender } | FILTER NOT EXISTS { ?speaker prop:P8 ?gender } | ||
| − | ?audio prop:P5 ?speaker . # Filter: P5 'speaker | + | ?audio prop:P5 ?speaker . # Filter: P5 'speaker' |
| − | ?audio prop:P4 ?language . # Filter: P4 'language | + | ?audio prop:P4 ?language . # Filter: P4 'language' |
# Add labels | # Add labels | ||
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"} | SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"} | ||
| Line 23: | Line 23: | ||
?speaker prop:P2 entity:Q3 . | ?speaker prop:P2 entity:Q3 . | ||
FILTER NOT EXISTS { ?speaker prop:P8 ?gender } | FILTER NOT EXISTS { ?speaker prop:P8 ?gender } | ||
| − | ?audio prop:P5 ?speaker . # Filter: P5 'speaker | + | ?audio prop:P5 ?speaker . # Filter: P5 'speaker' |
?audio prop:P4 ?language . # Filter: P4 'language' is Q34 'Marathi' | ?audio prop:P4 ?language . # Filter: P4 'language' is Q34 'Marathi' | ||
# Add labels | # Add labels | ||
| Line 30: | Line 30: | ||
GROUP BY ?speaker ?speakerLabel ?genderLabel ?language ?languageLabel # Sorting first groups per language and speaker | GROUP BY ?speaker ?speakerLabel ?genderLabel ?language ?languageLabel # Sorting first groups per language and speaker | ||
ORDER BY DESC (?audio) | ORDER BY DESC (?audio) | ||
| + | </query> | ||
| + | |} | ||
| + | |||
| + | === Is Sex or Gender ([[Q7]]) → List existing sexes or genders === | ||
| + | ''This query is going to be DEPRECATED as the queried data will no longer be available.'' | ||
| + | {| style="width:100%" | ||
| + | |- style="vertical-align:top;" | ||
| + | |style="padding: 0 3em;width:60%"| | ||
| + | <syntaxhighlight lang="sparql"> | ||
| + | SELECT ?item ?itemLabel | ||
| + | WHERE { | ||
| + | ?item prop:P2 entity:Q7 # Filter: P2 'instance of' is Q7 'sex or gender'. | ||
| + | # Add labels to each variable used. | ||
| + | SERVICE wikibase:label { | ||
| + | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| + | } | ||
| + | } | ||
| + | </syntaxhighlight> | ||
| + | | | ||
| + | <query _pagination="10" item="Property" itemLabel="Values"> | ||
| + | SELECT ?item ?itemLabel | ||
| + | WHERE { | ||
| + | ?item prop:P2 entity:Q7 # Filter: P2 'instance of' is Q7 'sex or gender'. | ||
| + | # Add labels to each variable used. | ||
| + | SERVICE wikibase:label { | ||
| + | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| + | } | ||
| + | } | ||
</query> | </query> | ||
|} | |} | ||
| Line 81: | Line 109: | ||
SELECT ?speakerLabel ?languageLabel ?audioLabel ?filename | SELECT ?speakerLabel ?languageLabel ?audioLabel ?filename | ||
WHERE { | WHERE { | ||
| − | ?audio prop:P5 | + | VALUES ?speakers { entity:Q214043 entity:Q43323 } |
| + | ?audio prop:P5 ?speakers . # Filter: P5 Speaker | ||
?audio prop:P5 ?speaker . # Filter: P5 Speaker | ?audio prop:P5 ?speaker . # Filter: P5 Speaker | ||
?audio prop:P4 ?language . # Filter: P4 language | ?audio prop:P4 ?language . # Filter: P4 language | ||
| Line 96: | Line 125: | ||
SELECT ?speakerLabel ?languageLabel ?audioLabel ?filename | SELECT ?speakerLabel ?languageLabel ?audioLabel ?filename | ||
WHERE { | WHERE { | ||
| − | ?audio prop:P5 | + | VALUES ?speakers { entity:Q214043 entity:Q43323 entity:Q405732 entity:Q5018 } |
| + | ?audio prop:P5 ?speakers . # Filter: P5 Speaker | ||
?audio prop:P5 ?speaker . # Filter: P5 Speaker | ?audio prop:P5 ?speaker . # Filter: P5 Speaker | ||
?audio prop:P4 ?language . # Filter: P4 language | ?audio prop:P4 ?language . # Filter: P4 language | ||
Latest revision as of 08:33, 11 August 2022
✅ 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)
|
|
Is Sex or Gender (sex or gender (Q7)) → List existing sexes or genders
This query is going to be DEPRECATED as the queried data will no longer be available.
SELECT ?item ?itemLabel
WHERE {
?item prop:P2 entity:Q7 # Filter: P2 'instance of' is Q7 'sex or gender'.
# Add labels to each variable used.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
}
}
|
|
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" .
}
}
|
|
✅ Languages with media type video → written word (P7), url (P3) speakers (P5)
SELECT ?word ?filename ?speaker WHERE {
?record prop:P4 entity:Q99628 .
?record prop:P2 entity:Q2 .
?record prop:P7 ?word .
?record prop:P3 ?filename .
?record prop:P5 ?speakerItem .
?speakerItem rdfs:label
?speaker filter ( lang( ?speaker ) = "en" ) .
}
|
|