query-3c0794d157f360ff14431b46d5b4e36f

rq turtle/ttl

FIDE rankings ]reply[02:40, 15 May 2018 (UTC)) talk (Hrodvarsson each month, as I believe it is useful for this information to be accessible without leaving Wikipedia. Is there a means of automating this process, or to record the data here so it could simply replicated across other languages? The English and Russian Wikipedia are the only languages with up-to-date rankings. FIDE world rankingsI have been updating : I don't think this is possible at the moment. Have look for example at this query:Hrodvarsson@ ]reply[22:50, 2 September 2018 (UTC)) talk (Hrodvarsson. The rest of the data is numerical. I have little experience on Wikidata so I don't know if this possible, but the idea seems useful to me. Q106807: Thanks. That de-wiki template is also useful but what I meant was the creation of a template on Wikidata that could be transcluded onto all languages of Wikipedia. The template would contain the same data as the wikitable currently seen on en-wiki FIDE world rankings, except with en-wiki article links replaced with Wikidata links. For example, replacing the link to "Magnus Carlsen" with Steak@ ]reply[11:41, 2 September 2018 (UTC)) talk (Steak. If not, please be more precise. de:Vorlage:Elo-Diagramm: because yours did probably not work. What you are looking for is probably something similar to the Edgars2007: Another ping for @Hrodvarsson@ ]reply[19:48, 1 September 2018 (UTC)) talk (Hrodvarsson: Thanks for the reply and sorry for the late response (I must have missed the ping). What I meant was a template that could be transcluded in other languages of Wikipedia, so if I were to update the rankings here it would apply across all languages, rather than just updating the rankings on en-wiki. Similar to updating a wikidata infobox would apply to articles that contain the wikidata infobox. Edgars2007@ ]reply[15:52, 26 May 2018 (UTC)) talk (Edgars2007: Currently updating the rankings. From now on it should be more often (more or less in time). --Hrodvarsson@

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT distinct ?item ?itemLabel ?elo ?date 
WHERE {
  {
    SELECT ?item (MAX(?date) AS ?date) WHERE {
        {
  SELECT ?item ?stmt ?elo ?date WHERE {
     ?item p:P1087 ?stmt .
     ?stmt ps:P1087 ?elo .
     FILTER(?elo > 2599)
     optional {?stmt pq:P585 ?date }
  }
}.
    } GROUP BY ?item 
  }
   {
  SELECT ?item ?stmt ?elo ?date WHERE {
     ?item p:P1087 ?stmt .
     ?stmt ps:P1087 ?elo .
     FILTER(?elo > 2599)
     optional {?stmt pq:P585 ?date }
  }
}.   
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
order by desc(?elo )

Query found at

• https://www.wikidata.org/wiki/Wikidata_talk:WikiProject_Chess