Template:SPARQL/sandbox

From Wikidata
Jump to navigation Jump to search
Documentation icon Template documentation[view] [edit] [history] [purge]

Usage[edit]

This template displays SPARQL query with syntax highlighting, prefixes and link to WDQS beta site to run the query.

Template parameters

ParameterDescriptionTypeStatus
queryquery

SPARQL query

Example
SELECT * WHERE { ?x wdt:P31 wd:Q5 } LIMIT 1
Stringrequired
pp

Produce p: prefix if set

Booleanoptional
qq

Produce q: prefix if set

Booleanoptional
vv

Produce v: prefix if set

Booleanoptional
Extraprefixextraprefix

Extra prefixes to be added

Example
PREFIX wikibase: <http://wikiba.se/ontology#>
Stringoptional
Statestate

Either "collapsed" or "expanded", both make the query code collapsible, "collapsed" makes it start collapsed. In a list ("*" or "#" at beginning of line) the "Collapse"/"Expand" toggle button is displayed next to the link to the Wikidata Query Service.

Stringoptional
Labellabel

Text to be used as the label of the link to the Wikidata Query Service

Default
Try it!
Contentoptional

Examples[edit]

  • {{SPARQL|query=SELECT DISTINCT ?person ?name ?language ?death (URI(CONCAT("https://www.gutenberg.org/ebooks/author/", ?gutenberg)) AS ?gberglink) WHERE { ?person wdt:P1938 ?gutenberg. ?person wdt:P570 ?death. # Dead people only MINUS { ?enws schema:about ?person. ?enws schema:isPartOf <https://en.wikisource.org/> } OPTIONAL {?person wdt:P1412 ?lang}. FILTER (!BOUND(?lang) {{!}}{{!}} ?lang = wd:Q1860) # Language: English or absent BIND(IF(BOUND(?lang),"English","Not specified") AS ?language ) ?person rdfs:label ?name. FILTER((LANG(?name)) = "en") } ORDER BY ?death }}
SELECT DISTINCT ?person ?name ?language ?death (URI(CONCAT("https://www.gutenberg.org/ebooks/author/", ?gutenberg)) AS ?gberglink) WHERE {
  ?person wdt:P1938 ?gutenberg.
  ?person wdt:P570 ?death. # Dead people only
  MINUS {
    ?enws schema:about ?person.
    ?enws schema:isPartOf <https://en.wikisource.org/>
  }
  OPTIONAL {?person wdt:P1412 ?lang}.
  FILTER (!BOUND(?lang) || ?lang = wd:Q1860) # Language: English or absent
  BIND(IF(BOUND(?lang),"English","Not specified") AS ?language
)  ?person rdfs:label ?name.
  FILTER((LANG(?name)) = "en")
}
ORDER BY ?death
Try it!

See also[edit]

Try it!