query-a2537b236e9277a69f0a820b0d77fd7a
Is there an automated way to reorder a list in Wikidata 01:36, 18 March 2020 (UTC)) talk (RAN I have a list of participants in an event, I add the people as I figure out who they are and make an entry for them in Wikidata. That leads to a list not in ordinal order, is there a way to reorder them, so I do not have to do it by hand? --(Q68255449)1930 Ford National Reliability Air Tour At : Less wieldy than you might have been hoping for, but try this:Richard Arthur Norton (1958- )@
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?event ?eventLabel ?ordinal ?participant ?participantLabel ?participantDescription WHERE {
BIND (wd:Q68255449 AS ?event)
?event p:P710 ?statement .
?statement ps:P710 ?participant ;
pq:P1545 ?ordinal .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
} ORDER BY xsd:integer(?ordinal)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?event"):::projected
v1("?ordinal"):::projected
v4("?participant"):::projected
v3("?statement")
c5(["bd:serviceParam"]):::iri
c7(["en"]):::literal
bind0[/"'wd:Q68255449'"/]
bind0 --as--o v2
v2 --"p:P710"--> v3
v3 --"p:statement/P710"--> v4
v3 --"p:qualifier/P1545"--> v1
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c5 --"wikibase:language"--> c7
end