Open main menu


Joined 30 October 2012
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.

Coordinator on Wikidata (part of my work with Europeana)

My personal to-do lists:

Trying to become SPARQLyEdit

Examples via Harmonia Amanda:

Things to rememberEdit

  • 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