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

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

Produce p: prefix if set

Default
empty
Example
empty
Auto value
empty
Booleanoptional
qq

Produce q: prefix if set

Default
empty
Example
empty
Auto value
empty
Booleanoptional
vv

Produce v: prefix if set

Default
empty
Example
empty
Auto value
empty
Booleanoptional
Extraprefixextraprefix

Extra prefixes to be added

Default
empty
Example
PREFIX wikibase: <http://wikiba.se/ontology#>
Auto value
empty
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.

Default
empty
Example
empty
Auto value
empty
Stringoptional
Labellabel

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

Default
Try it!
Example
empty
Auto value
empty
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!