query-c8a0e9f524fef3916ead4e8bf1b8b950

rq turtle/ttl

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

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