Wikimedia Belgium Projects/ListeriaBot/Query

Wikimedia Belgium manages its projects using Wikidata.

When organising projects like edit-a-thons, it can be confusing, and difficult how to identify relevant pages.

Advantages[edit]

Data driven:
- All data in one central place (Wikidata)
- Easy to write queries and to automate using Pywikibot
- Enabling automated reporting
- Linkable against all Wikimedia platforms (including SDC)

Method[edit]

The following can be a typical flow for managing such project:

Create a Wikiproject in Wikidata
- Create claim P31 (Q16695773) (Wikiproject)
- Create claim P664 (organisator of Wikiproject item) (Q18398868) (Wikimedia Belgium)
Create or amend Wikidata items that are maintained by the project:
- Create claim P6104 (maintained by) Wikiproject
Create a Wikipedia project page
Add a ListeriaBot subpage using the above Wikiproject item number, via a below query
Create new Wikipedia pages
Link the Wikipedia pages to the equivalent Wikidata item

Below you can find a list of WMBE projects.

Queries[edit]

Wiki projects by Wikimedia Belgium[edit]

This is a list of projects organised by Wikimedia Belgium:

SELECT ?wikiproject ?wikiprojectLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?wikiproject wdt:P31 wd:Q16695773.
  ?wikiproject wdt:P664 wd:Q18398868.
}

See https://w.wiki/$cN

It has been created by starting Wikidata Query, then entering the search items "wikiproject" and "WMBE" in the Filter section.

Items linked to Wikimedia Belgium projects[edit]

This becomes a huge list...

SELECT DISTINCT ?item WHERE {
  ?item wdt:P6104 ?wikiproject.
  ?wikiproject wdt:P31 wd:Q16695773;
    wdt:P664 wd:Q18398868.
}

See https://w.wiki/5KRe

Missing language labels for items[edit]

SELECT distinct ?item WHERE {
  ?item wdt:P6104 ?wikiproject;
    wdt:P31 wd:Q5.
  ?wikiproject wdt:P31 wd:Q16695773;
    wdt:P664 wd:Q18398868.
  MINUS {
    ?item rdfs:label ?label.
    FILTER((LANG(?label)) = "da")
  }
}

See https://w.wiki/5nkB

The list of Q-numbers can be fed into a Pywikibot script to add the missing labels.