query-82b74967afdc407bd9f6dfc6da52be9d

rq turtle/ttl

Stars up to 18 light years away sorted by the nearest SELECT ?star ?starLabel ?distance ?unitLabel ?lightyears WHERE { { SELECT ?star ?distance ?unit ?lightyears WHERE { ?star wdt:P31 wd:Q523. ?star p:P2583/psv:P2583 ?statement. ?statement wikibase:quantityUnit ?unit. ?statement wikibase:quantityAmount ?distance. ?statement wikibase:quantityNormalized/wikibase:quantityAmount ?distanceNormalized. # convert to normalized unit (meter) BIND (?distanceNormalized / 9460800000000000 AS ?lightyears) FILTER( ?lightyears < 19) } LIMIT 100 } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } } ORDER BY ?lightyears LIMIT 100

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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Stars up to 18 light years away sorted by the nearest
SELECT ?star ?starLabel ?distance ?unitLabel ?lightyears
WHERE
{
  {
    SELECT ?star ?distance ?unit ?lightyears
    WHERE
    {
      ?star wdt:P31 wd:Q523.
      ?star p:P2583/psv:P2583 ?statement.
      ?statement wikibase:quantityUnit ?unit.
      ?statement wikibase:quantityAmount ?distance.
      ?statement wikibase:quantityNormalized/wikibase:quantityAmount ?distanceNormalized. # convert to normalized unit (meter)
      BIND (?distanceNormalized / 9460800000000000  AS ?lightyears)
      FILTER( ?lightyears < 19)
    }
    LIMIT 100
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
ORDER BY ?lightyears
LIMIT 100

Query found at

• https://www.wikidata.org/wiki/User:Infovarius/Queries
• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2020/03