Help:SPARQL query examples/queries: Difference between revisions

From DataTrek
Jump to navigation Jump to search
(Examples from ChatGPT)
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
=== Episodi di Lower Decks ===
<div class="mw-heading mw-heading2">
  <h2>Queries with cats</h2>
</div>
<div class="mw-heading mw-heading3">
  <h3>Cats</h3>
</div>
<syntaxhighlight lang="sparql">
SELECT ?cat ?catLabel WHERE {
  ?cat prefix:P1 prefix:Q2
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}
</syntaxhighlight>
 
<div class="mw-heading mw-heading2">
  <h2>Queries with dogs</h2>
</div>
<div class="mw-heading mw-heading3">
  <h3>Dogs</h3>
</div>
<syntaxhighlight lang="sparql">
SELECT ?dog ?dogLabel WHERE {
  ?dog prefix:P1 prefix:Q3
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}
</syntaxhighlight>
 
 
<!-- === Episodi di Lower Decks === -->
__NOTOC__
<div class="mw-heading mw-heading3">
  <h3>Episodi di Lower Decks</h3>
</div>
Elenco di episodi di '''''[[wikitrek:Star Trek: Lower Decks|Lower Decks]]'''''
Elenco di episodi di '''''[[wikitrek:Star Trek: Lower Decks|Lower Decks]]'''''
<syntaxhighlight lang="sparql" line>
<syntaxhighlight lang="sparql" line>

Latest revision as of 18:37, 6 January 2025

Queries with cats

Cats

SELECT ?cat ?catLabel WHERE {
  ?cat prefix:P1 prefix:Q2
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}

Queries with dogs

Dogs

SELECT ?dog ?dogLabel WHERE {
  ?dog prefix:P1 prefix:Q3
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}


Episodi di Lower Decks

Elenco di episodi di Lower Decks 

PREFIX wd: <https://data.wikitrek.org/entity/>
PREFIX wdt: <https://data.wikitrek.org/prop/direct/>
	
SELECT ?episode ?episodeLabel ?publication ?production WHERE {
  ?episode wdt:P14 wd:Q10317;
           wdt:P101 ?publication;
           wdt:P1 ?production
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
  }
ORDER BY ASC (?production)

Episodi di Prodigy

Elenco di episodi di Prodigy 

PREFIX wd: <https://data.wikitrek.org/entity/>
PREFIX wdt: <https://data.wikitrek.org/prop/direct/>
	
SELECT ?episode ?episodeLabel ?publication ?production WHERE {
  ?episode wdt:P14 wd:Q10692;
           wdt:P101 ?publication;
           wdt:P1 ?production
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
  }
ORDER BY ASC (?production)

Planets

A list of planets. 

SELECT ?planet WHERE {
  ?planet wdt:P31 wd:Q634.
}

Starships

Starships in the galaxy. 

SELECT ?starship WHERE {
  ?starship wdt:P31 wd:Q170383.
}
Retrieved from "https://data.wikitrek.org/dt/index.php?title=Help:SPARQL_query_examples/queries&oldid=86511"