Help
SPARQL for maintenance
Revision as of 13:14, 18 January 2022 by Yug (talk | contribs) (→Usernames containing reserved sign `-`)
SPARQL for maintenance gather some SPARQL queries which help to monitors errors and bring fix to our resources.
Revision as of 13:14, 18 January 2022 by Yug (talk | contribs) (→Usernames containing reserved sign `-`)
Users
✅ Speakers → Username containing reserved sign `-`
- See also T297635
SELECT *
WHERE {
?id prop:P2 entity:Q3 .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
?id rdfs:label ?name .
}
BIND (regex(STR(?name),"-") AS ?has_separator)
}
ORDER BY DESC (?has_separator)
|
|
SELECT ?has_separator (COUNT(?has_separator) AS ?found)
WHERE {
?id prop:P2 entity:Q3 .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
?id rdfs:label ?name .
}
BIND (regex(STR(?name),"-") AS ?has_separator)
# filter( regex(?name, "-" ))
}
#ORDER BY DESC (?has_separator)
GROUP BY (?has_separator)
|
|
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 .