Open main menu

MB-one

Joined 31 October 2012
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), educated at (P69) Technical University of Berlin (Q51985)

Wikidata heart logo.svg

multiple languages (Q20923490)

Contents

Current activityEdit

Tools & queriesEdit

SnippetsEdit

  • 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)
  • ?item p:P131 ?statement.
?statement ps:P131 wd:Q472 .
FILTER NOT EXISTS {
?statement prov:wasDerivedFrom ?ref
}(statement without references)

Full QueriesEdit

ToolsEdit