User:Sebastian Wallroth

Babel user information
mul-1 This user has basic knowledge of multiple languages.
Users by language

→ meta:User:Sebastian Wallroth

Create family name with Quickstatements

Copy code below into text editor, replace "Schaxel" with new family name, and use https://quickstatements.toolforge.org/#/batch to create new family name.

 CREATE /* replace Schaxel with family name */
 LAST	P1705	de:"Schaxel"
 LAST	P31	Q101352
 LAST	P282	Q8229
 LAST	Lmul	"Schaxel"

Menschen aus dem Deutschen Reich ohne Familienname

{{SPARQL|query=SELECT ?item ?itemLabel WHERE {
  ?item wdt:P27 wd:Q1206012.
  MINUS { ?item wdt:P734 _:b0. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}
LIMIT 8
}}

Urheber, die 1946 verstorben sind

{{SPARQL|query=SELECT ?Objekt ?Name ?Beschreibung ?Bild (COUNT(DISTINCT ?sitelink) as ?Artikel)
WHERE
{
  ?Objekt wdt:P31 wd:Q5 .
  ?Objekt wdt:P570 ?Tod FILTER (YEAR(?Tod)=1946) .
  ?Objekt wdt:P106/wdt:P279* wd:Q2500638 .
  ?sitelink schema:about ?Objekt
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "de,en" .
    ?Objekt rdfs:label ?Name .
    ?Objekt schema:description ?Beschreibung
  }
  OPTIONAL { ?Objekt wdt:P18 ?Bild }
}
GROUP BY ?Objekt ?Name ?Beschreibung ?Bild
ORDER BY DESC (?Artikel)
LIMIT 1000
}}

V2

New version by Dipsacus fullonum. --Sebastian Wallroth (talk) 08:55, 4 January 2021 (UTC)

{{SPARQL
|query=SELECT DISTINCT ?item ?articlecount
WITH
{
  SELECT ?item
  WHERE
  {
    ?item wdt:P570 ?deathdate .
    hint:Prior hint:rangeSafe true .
    FILTER ( ?deathdate < "1947-00-00"^^xsd:dateTime && ?deathdate >= "1946-00-00"^^xsd:dateTime )
  }
}
AS %subquery
WHERE
{
  INCLUDE %subquery
  ?item wikibase:sitelinks ?articlecount .
  ?item p:P106 ?occupationStatement .
  ?occupationStatement ps:P106/wdt:P279* wd:Q2500638 .
  hint:Prior hint:gearing "forward" .
  MINUS { ?occupationStatement wikibase:rank wikibase:DeprecatedRank . }
}
ORDER BY DESC (?articlecount)
}}

Menschen mit "Zika" in der Bezeichnung (label)

{{SPARQL|query=#Menschen mit "Zika" in der Bezeichnung (label)
SELECT ?item ?itemLabel 
WITH {
  SELECT * WHERE {
    BIND ("zika" AS ?searchfor)
  }
} AS %p
WITH {
  SELECT ?item
  WHERE {
    INCLUDE %p
    BIND (CONCAT("haswbstatement:P31=Q5 ", ?searchfor) AS ?searchstr)
    SERVICE wikibase:mwapi {
      bd:serviceParam wikibase:endpoint "www.wikidata.org" .
      bd:serviceParam wikibase:api "Generator" .
      bd:serviceParam mwapi:generator "search" .
      bd:serviceParam mwapi:gsrsearch ?searchstr .
      bd:serviceParam mwapi:gsrlimit "max" .
      bd:serviceParam mwapi:gsrnamespace "0" .
	  bd:serviceParam mwapi:gsrprop "" .
      ?item wikibase:apiOutputItem mwapi:title .
    }
  }
} AS %i
WHERE {
  INCLUDE %i
  INCLUDE %p
  ?item rdfs:label ?itemLabel .
  FILTER (LANG(?itemLabel)="en")
  FILTER(CONTAINS(LCASE(?itemLabel), ?searchfor))
  OPTIONAL { ?item wdt:P698 ?PMID. }
  OPTIONAL { ?item wdt:P356 ?DOI. }
}
}}

This person participated in the
International Museum Day 2022 Wikidata Competition.

This person participated in the
Wikidata contest Coordinate Me 2024.