query-22fa7955b45a7a84656f66f8af5a1d04

rq turtle/ttl

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

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

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