User:MB-one

From Wikidata
Jump to navigation Jump to search
Babel user information
de-N Dieser Benutzer spricht Deutsch als Muttersprache.
en-3 This user has advanced knowledge of English.
fr-1 Cet utilisateur dispose de connaissances de base en français.
pt-1 Este utilizador tem um nível básico de português.
Users by language

given name (P735)  Matti (Q1474085), residence (P551)  Berlin (Q64)

Wikidata heart logo.svg

multiple languages (Q20923490)

Current activity[edit]

Tools & queries[edit]

Snippets[edit]

  • p:P31/ps:P31/wdt:P279* (checks subclasses)
  • BIND(SUBSTR(STR(?item), (STRLEN(STR(<http://www.wikidata.org/entity/>))) + 1) AS ?qid) (extracts QID from URL)
  • BIND(SUBSTR( ?string, 1, 4 ) as ?substring) (extracts substrings; here: 1 = starting at first character; 4 = four characters long)
  • (COUNT(?item) AS ?count) (counts items)
  • (CONCAT('"', ?item, '"') AS ?value) (concatenates values and strings)
  • ?article schema:about ?item .
?article schema:isPartOf <https://en.wikipedia.org/>. (checks for existing articles in other wikis)
  • OPTIONAL {?item rdfs:label ?label_en , ?label_de , ?label_fr}
filter(lang(?label_en) = 'en' && lang(?label_de) = 'de' && lang(?label_fr) = 'fr') (gives multiple language labels)
  • OPTIONAL {?item schema:description ?desc FILTER (LANG (?desc) = "de") .} (gives description in selected language)
  • BIND( IF( ?value1 = ?value2, "same", "different" ) AS ?result ) (compares values)
  • { ?item wdt:P131 ?admin1. }
UNION
{ ?item wdt:P131 ?admin2. } (Union of two separate statements)

Full Queries[edit]

Tools[edit]