Help:SPARQL query examples/queries: Difference between revisions

From DataTrek
Jump to navigation Jump to search
No edit summary
(Examples from ChatGPT)
Line 7: Line 7:
SELECT ?episode ?episodeLabel ?publication ?production WHERE {
SELECT ?episode ?episodeLabel ?publication ?production WHERE {
   ?episode wdt:P14 wd:Q10317;
   ?episode wdt:P14 wd:Q10317;
          wdt:P101 ?publication;
          wdt:P1 ?production
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
  }
ORDER BY ASC (?production)
</syntaxhighlight>
=== Episodi di Prodigy ===
Elenco di episodi di '''''[[wikitrek:Star Trek: Prodigy|Prodigy]]'''''
<syntaxhighlight lang="sparql">
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:P101 ?publication;
           wdt:P1 ?production
           wdt:P1 ?production

Revision as of 11:48, 29 December 2024

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.
}