query-d96336345381463e9494a42ab4c634ba
Personenliste - Alle Personen, die Maler in der Renaissance waren (Tätigkeitliste, Epochenliste) TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel
(GROUP_CONCAT(DISTINCT ?occupation; SEPARATOR = ",") AS ?occupationUID)
(GROUP_CONCAT(DISTINCT ?occupationLabel; SEPARATOR = ",") AS ?occupations)
(GROUP_CONCAT(DISTINCT ?movementLabel; SEPARATOR = ",") AS ?movements)
WHERE {
?item wdt:P106 ?o; # constrain what items are returned by predicate values in the filters
wdt:P135 ?m.
FILTER(?m IN(wd:Q4692, wd:Q1472236, wd:Q1474884, wd:Q979160))
FILTER(?o IN(wd:Q1028181))
?item wdt:P106 ?occupation; # find out all values of these two predicates
wdt:P135 ?movement.
# FILTER(?occupation NOT IN(wd:Q1028181))
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
?item rdfs:label ?itemLabel.
?occupation rdfs:label ?occupationLabel.
?movement rdfs:label ?movementLabel.
}
}
GROUP BY ?item ?itemLabel
Query found at
- https://www.wikidata.org/wiki/User:Stefan_K%C3%BChn/Persondata
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2023/01
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?item"):::projected
v6("?itemLabel"):::projected
v2("?m")
v5("?movement")
v8("?movementLabel"):::projected
v11("?movements")
v1("?o")
v4("?occupation"):::projected
v7("?occupationLabel"):::projected
v9("?occupationUID")
v10("?occupations")
c9(["bd:serviceParam"]):::iri
c11(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["?o = 'wd:Q1028181'"]]
f0 --> v1
list0c4(["wd:Q979160"]):::iri
list0c1(["wd:Q4692"]):::iri
list0c3(["wd:Q1474884"]):::iri
list0c2(["wd:Q1472236"]):::iri
list0c1 --o f1
list0c2 --o f1
list0c3 --o f1
list0c4 --o f1
f1[[" in "]]
f1 --> v2
v3 --"wdt:P106"--> v1
v3 --"wdt:P135"--> v2
v3 --"wdt:P106"--> v4
v3 --"wdt:P135"--> v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
v3 --"rdfs:label"--> v6
v4 --"rdfs:label"--> v7
v5 --"rdfs:label"--> v8
end
bind5[/"?occupation"/]
v4 --o bind5
bind5 --as--o v9
bind6[/"?occupationLabel"/]
v7 --o bind6
bind6 --as--o v10
bind7[/"?movementLabel"/]
v8 --o bind7
bind7 --as--o v11