query-7c48a00fafee60161e41a8f41255ca69
Personen, die Lehrkraft an der TU-Dresden sind/waren
----------------------------------------------------------
SELECT ?item ?itemLabel ?firstnameLabel ?lastnameLabel ?itemDescription WHERE { ?item wdt:P108 wd:Q158158; wdt:P106 wd:Q1622272; #wdt:P106 wd:Q593644; wdt:P569 ?born. FILTER (?born >= "1945-01-01T00:00:00Z"^^xsd:dateTime) . OPTIONAL { ?item wdt:P734 ?lastname . } # Nachname OPTIONAL { ?item wdt:P735 ?firstname . } # Vorname SERVICE wikibase:label { bd:serviceParam wikibase:language "de,[AUTO_LANGUAGE]". } } order by ?lastnameLabel ?firstnameLabel
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#----------------------------------------------------------
# Personen, die Lehrkraft an der TU-Dresden sind/waren
#----------------------------------------------------------
SELECT ?item ?itemLabel ?firstnameLabel ?lastnameLabel ?itemDescription
WHERE
{
?item wdt:P108 wd:Q158158;
wdt:P106 wd:Q1622272;
#wdt:P106 wd:Q593644;
wdt:P569 ?born.
FILTER (?born >= "1945-01-01T00:00:00Z"^^xsd:dateTime) .
OPTIONAL { ?item wdt:P734 ?lastname . } # Nachname
OPTIONAL { ?item wdt:P735 ?firstname . } # Vorname
SERVICE wikibase:label { bd:serviceParam wikibase:language "de,[AUTO_LANGUAGE]". }
}
order by ?lastnameLabel ?firstnameLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?born")
v6("?firstname")
v2("?firstnameLabel"):::projected
v4("?item"):::projected
v5("?lastname")
v1("?lastnameLabel"):::projected
c10(["bd:serviceParam"]):::iri
c5(["wd:Q1622272"]):::iri
c12(["de,#91;AUTO_LANGUAGE#93;"]):::literal
c3(["wd:Q158158"]):::iri
f0[["?born >= '1945-01-01T00:00:00Z^^xsd:dateTime'"]]
f0 --> v3
v4 --"wdt:P108"--> c3
v4 --"wdt:P106"--> c5
v4 --"wdt:P569"--> v3
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v4 -."wdt:P734".-> v5
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v4 -."wdt:P735".-> v6
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c10 --"wikibase:language"--> c12
end