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.

This is my volunteer account. As LWyatt (WMF) I'm an employee of the Wikimedia Foundation I was the Wikicite program coordinator (2019-2021), and Wikimedia Enterprise program manager (2020 - ).

SLNSW presentation

I was the coordinator on Wikidata (part of my work with Europeana)

My personal 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:
  ?article schema:about ?item ;
           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.
GROUP BY ?item ?itemLabel ?article
  • 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

Troubles edit

WikiCite Satellite Cologne 2020 edit

Hi Wittylama - you have added yourself to the list of people who are interested in the WikiCite Satellite Cologne 2020 meeting. The call for submissions is still open and we would love to see your contribution! Let me know if you have any questions. Best wishes!

Konrad Foerstner (talk) 18:32, 12 February 2020 (UTC)