query-271fe1e5b47cea46d88a9d6cd7df096d
Switch name-surname 22:58, 8 December 2021 (UTC) dosisEpì), the labels have the order "Surname Name", but they should have the order "Name Surname". Could you fix them? Thanks, --(Q110007067)Stefania Żbik , (Q110007038)Yevgenia Zavalnaya . I'd have just one request: I see that in some items, probably most of them (e.g. (P1979)Righteous Among The Nations ID Hi! Thanks for your import of today from As of now, the inversion should be applied to all these items (nearly 15 thousands):
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel
WHERE {
?item wdt:P1979 ?g .
?item wikibase:identifiers 1 .
FILTER ((xsd:integer(SUBSTR(STR(?item),33))) > 109000000) .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?itemLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?g")
v2("?item"):::projected
v1("?itemLabel"):::projected
c5(["1^^xsd:integer"]):::literal
c7(["bd:serviceParam"]):::iri
c9(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["http://www.w3.org/2001/XMLSchema#integer(substring(str(?item),'33^^xsd:integer')) > '109000000^^xsd:integer'"]]
f0 --> v2
v2 --"wdt:P1979"--> v3
v2 --"wikibase:identifiers"--> c5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end