query-22fa7955b45a7a84656f66f8af5a1d04
Players with highest elo rating in October 2024When the bot doesn't update the list please press on "Manually update list" and it should spend some time to update it. If it didn't work you can also manually use this query. If you want to use the Query instead press on "Run it!" and change some values which is explained below: TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pqv: <http://www.wikidata.org/prop/qualifier/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?time ?elo WHERE
{
# VALUES ?item {wd:Q110649016}
?item wdt:P31 wd:Q5;
p:P1087 [ ps:P1087 ?elo; pqv:P585/wikibase:timeValue ?time ] .
FILTER (YEAR(?time) = 2023 && MONTH(?time) = 1) .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?elo) LIMIT 100
Query found at
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2023/01
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Chess/Lists/Elo_recent
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?elo"):::projected
v3("?item"):::projected
v2("?time"):::projected
a1((" "))
a2((" "))
c10(["bd:serviceParam"]):::iri
c4(["wd:Q5"]):::iri
c12(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["year-from-dateTime(?time) = '2023^^xsd:integer'month-from-dateTime(?time) = '1^^xsd:integer'"]]
f0 --> v2
v3 --"p:direct/P31"--> c4
a1 --"p:statement/P1087"--> v1
a1 --"p:qualifier/value/P585"--> a2
a2 --"wikibase:timeValue"--> v2
v3 --"p:P1087"--> a1
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c10 --"wikibase:language"--> c12
end