Project:SPARQL query service/queries/examples

Simple Queries

These basic queries help to understand SPARQL and the Wikibase RDF format.

Ships

SELECT ?item ?itemLabel 
WHERE 
{
  ?item scdbt:P1 scdb:Q842.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Ships ordered by cargo capacity

SELECT ?item ?itemLabel ?cargoCapacity WHERE 
{
  ?item scdbt:P1 scdb:Q842;
        scdbt:P61 ?cargoCapacity.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?cargoCapacity)

Try it!

List of systems

SELECT ?item ?itemLabel WHERE {
  ?item scdbt:P1 scdb:Q16.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

List of jump points of Stanton system

SELECT ?item ?itemLabel WHERE {
  ?item scdbt:P1 scdb:Q916;
    scdbt:P48 scdb:Q24.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

STAR arkmap type

SELECT ?item ?itemLabel 
WHERE 
{
  ?item scdbt:P10 "STAR".
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!