query-564aa868086232e5cd32cbff54680082
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/>
SELECT ?item ?elo ?fide_url 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) .
} 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
bind1[/VALUES ?item/]
bind1-->v3
bind10(["wd:Q110649016"])
bind10 --> bind1
v3 --"p:direct/P31"--> c4
a1 --"p:statement/P1087"--> v1
a1 --"p:qualifier/value/P585"--> a2
a2 --"wikibase:timeValue"--> v2
v3 --"p:P1087"--> a1