query-c8a0e9f524fef3916ead4e8bf1b8b950
Chess Elo but it is displayed wrong. Instead of listing the correct elo for January 2023 where she has elo rating 1,656, it instead shows that her elo rating is 1,574 but that is from June 2022. (Q110649016)Kler Çaku is supposed to show all the chess players who got elo data for the current month, but I think it doesn't really succeed in doing that. As of now the only player for January 2023 is displayed as Wikidata:WikiProject_Chess/Lists/Elo_recentSo in short, how do I make this query:
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/>
SELECT ?item ?elo ?fide_url WHERE { ?item wdt:P31 wd:Q5; p:P1087 [ ps:P1087 ?elo; pqv:P585/wikibase:timeValue ?time ] . FILTER (YEAR(?time) = 2023 && MONTH(?time) = 1) . } ORDER BY DESC(?elo) LIMIT 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?elo"):::projected
v3("?item"):::projected
v2("?time")
a1((" "))
a2((" "))
c4(["wd:Q5"]):::iri
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