From Wikidata
Jump to navigation Jump to search
Babel user information
en-N This user has a native understanding of English.
fr-3 Cet utilisateur dispose de connaissances avancées en français.
it-2 Questo utente può contribuire con un livello intermedio in italiano.
sv-1 Den här användaren har grundläggande kunskaper i svenska.
Users by language

Main userpage over on the English Wikipedia: here.

Main projects (volunteer)

Coordinator on Wikidata (part of my work with Europeana)

My to-do lists:

Trying to become SPARQLy[edit]

Examples via Harmonia Amanda:

Things to remember[edit]

  • Mandatory incantation before end of WHERE block
SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
  • Property or any of its subclasses:
  • SELECT DISTINCT to return unique results (useful for when using "property or subclasses of" (wdt:P31/wdt:P279*)
  •  To find whether an item has an article in Wikipedia, add:
1   ?article schema:about ?item ;
2            schema:isPartOf <>.
  • ORDER BY goes inside brackets, GROUP BY does not. GROUP BY must list all the things not in special brackets (e.g. (COUNT(?sitelink) AS ?count)) in the SELECT line.
1 GROUP BY ?item ?itemLabel ?article
2 ORDER BY DESC(?count)
3 LIMIT 50
  • To request NOT or EXCEPT something use MINUS { <the triple(s)> }.
  • To request the number of pages in all wikimedia projects add ?sitelink schema:about ?item . as a triple, and (COUNT(?sitelink) AS ?count) in the SELECT block.
  • OR statements are expressed with UNION between two sets of triples each within braces. e.g.
    { ?item wdt:P19 wd:Q13972 .} UNION {?item wdt:P19 wd:Q1770 .}

Tests for myself...[edit]


  • "All instances of <topic> that have an article on <language> Wikipedia". solution!
    • "...and also <different> language solution!
    • "...but not <different> language. solution!
    • ...sorted by number of total articles. solution!


  • "All instances of <topic> that have a <language> label"
    • "...and also <different> language
    • "...but not <different> language