User:TweetsFactsAndQueries/Queries/highest software versions

Originally posted on Twitter and on Mastodon.

SELECT ?item ?itemLabel ?version WITH {
  SELECT ?item ?version ?versionNumber WHERE {
    ?item wdt:P348 ?version.
    BIND(xsd:integer(REPLACE(STRBEFORE(?version, "."), "^v", "")) AS ?versionNumber)
  }
  ORDER BY DESC(?versionNumber)
  LIMIT 25
} AS %results WHERE {
  INCLUDE %results.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?versionNumber)

Try it!