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.
  FILTER(0 < ?cargoCapacity).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?cargoCapacity)

Try it!

List manufacturers with manufacturer type

SELECT ?item ?itemLabel (GROUP_CONCAT(DISTINCT(?instanceLabel); separator=", ") as ?instances) WHERE {
  ?item scdbt:P1/scdbt:P26* scdb:Q843;
        scdbt:P1 ?instance .

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
    ?item rdfs:label ?itemLabel .
    ?instance rdfs:label ?instanceLabel  
  }
}
GROUP BY ?item ?itemLabel

Try it!

Manufacturers with their vehicles (Tree view)

#defaultView:Tree
SELECT ?manufacturer ?manufacturerLabel ?item ?itemLabel 
WHERE 
{
  ?item scdbt:P1/scdbt:P26 scdb:Q1181;
        scdbt:P23 ?manufacturer.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?manufacturerLabel ?itemLabel

Try it!

Search by label

SELECT ?item ?itemLabel WHERE {
  ?item rdfs:label ?itemLabel.
  FILTER(REGEX(?itemLabel, "^Ballista.*", "i"))
}
LIMIT 10

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!

List spaceship build date (Timeline)

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

Try it!

Ship vendors with ship list

#defaultView:Tree
SELECT ?manufacturer ?manufacturerLabel ?item ?itemLabel 
WHERE 
{
  ?item scdbt:P1/scdbt:P26 scdb:Q1181;
        scdbt:P83 ?manufacturer.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?manufacturerLabel ?itemLabel

Try it!

Maintenance Queries

List everything from Query Service

SELECT ?item ?itemLabel
WHERE { 
  ?item rdfs:label ?itemLabel. 
} ORDER BY ?item

Try it!

Find items with same scunpacked reference

SELECT ?id (COUNT(?obj) AS ?count) (GROUP_CONCAT(?obj; SEPARATOR = " , ") AS ?items)
WHERE 
{
  ?obj scdbt:P78 ?id.
}
GROUP BY ?id
HAVING(?count > 1)

Try it!