Help
Difference between revisions of "SPARQL for maintenance"
SPARQL for maintenance gather some SPARQL queries which help to monitors errors and bring fix to our resources.
m (→Languages) |
|||
| Line 5: | Line 5: | ||
== Recordings == | == Recordings == | ||
| − | === Recordings | + | === ✅ Recordings → With ISO-639-3 `<code>zho</code>` to change to `<code>cmn</code>` === |
| + | {| style="width:100%" | ||
| + | |- style="vertical-align:top;" | ||
| + | |style="padding: 0 3em;width:60%"| | ||
| + | <syntaxhighlight lang="sparql"> | ||
| + | |||
| + | </syntaxhighlight> | ||
| + | || | ||
| + | <query _pagination="5"> | ||
| + | |||
| + | </query> | ||
| + | |} | ||
| + | |||
| + | SELECT ?langLabel ?isoLabel (SUBSTR(STR(?audio),32) AS ?Audio) ?audioLabel | ||
| + | WHERE { | ||
| + | ?audio prop:P2 entity:Q2 . # Filter: P4 language is Q21 French ; | ||
| + | { | ||
| + | ?audio prop:P4 entity:Q130 . # Filter: P4 language is Q130 zho ; | ||
| + | } UNION { | ||
| + | ?audio prop:P4 entity:Q113 . # Filter: P4 language is Q113 cmn ; | ||
| + | } | ||
| + | ?audio prop:P4 ?lang . | ||
| + | ?lang prop:P13 ?iso . | ||
| + | # Add Labels | ||
| + | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } | ||
| + | } ORDER BY ASC(?isoLabel) | ||
| + | # Helper: Chinese writing zho:Q130/wd:Q7850 ; Chinese mandarin cmn:Q113/wd:Q9192 . | ||
== Languages == | == Languages == | ||
{{Lingua Libre scripts}} | {{Lingua Libre scripts}} | ||
Revision as of 13:11, 18 January 2022
Users
Usernames containing reserved sign `-`
Recordings
✅ Recordings → With ISO-639-3 `zho` to change to `cmn`
|
|
SELECT ?langLabel ?isoLabel (SUBSTR(STR(?audio),32) AS ?Audio) ?audioLabel WHERE {
?audio prop:P2 entity:Q2 . # Filter: P4 language is Q21 French ;
{
?audio prop:P4 entity:Q130 . # Filter: P4 language is Q130 zho ;
} UNION {
?audio prop:P4 entity:Q113 . # Filter: P4 language is Q113 cmn ;
}
?audio prop:P4 ?lang .
?lang prop:P13 ?iso .
# Add Labels
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
} ORDER BY ASC(?isoLabel)
- Helper: Chinese writing zho:Q130/wd:Q7850 ; Chinese mandarin cmn:Q113/wd:Q9192 .