query-aab623e33e8c164e915d928e585cb8be
List humans having property P2580
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 bd: <http://www.bigdata.com/rdf#>
SELECT
?human ?humanLabel ?fatherLabel ?motherLabel ?dateOfBirth ?placeOfBirthLabel ?dateOfDeath ?placeOfDeathLabel
(GROUP_CONCAT(DISTINCT ?bblid) AS ?bblids)
(GROUP_CONCAT(DISTINCT ?isni) AS ?isnis)
(GROUP_CONCAT(DISTINCT ?viaf) AS ?viafs)
(GROUP_CONCAT(DISTINCT ?gnd) AS ?gnds)
(GROUP_CONCAT(DISTINCT ?geni) AS ?genis)
WHERE {
?human wdt:P31 wd:Q5 .
OPTIONAL{?human wdt:P2580 ?bblid .}
OPTIONAL{?human wdt:P22 ?father .}
OPTIONAL{?human wdt:P25 ?mother .}
OPTIONAL{?human wdt:P569 ?dateOfBirth .}
OPTIONAL{?human wdt:P19 ?placeOfBirth .}
OPTIONAL{?human wdt:P570 ?dateOfDeath .}
OPTIONAL{?human wdt:P20 ?placeOfDeath .}
OPTIONAL{?human wdt:P213 ?isni .}
OPTIONAL{?human wdt:P214 ?viaf .}
OPTIONAL{?human wdt:P227 ?gnd .}
?human wdt:P2600 ?geni .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
GROUP BY ?human ?humanLabel ?fatherLabel ?motherLabel ?dateOfBirth ?placeOfBirthLabel ?dateOfDeath ?placeOfDeathLabel
ORDER BY ?dateOfBirth
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?bblid"):::projected
v13("?bblids")
v1("?dateOfBirth"):::projected
v7("?dateOfDeath"):::projected
v4("?father")
v12("?geni"):::projected
v17("?genis")
v11("?gnd"):::projected
v16("?gnds")
v2("?human"):::projected
v9("?isni"):::projected
v14("?isnis")
v5("?mother")
v6("?placeOfBirth")
v8("?placeOfDeath")
v10("?viaf"):::projected
v15("?viafs")
c15(["bd:serviceParam"]):::iri
c2(["wd:Q5"]):::iri
c17(["#91;AUTO_LANGUAGE#93;,en"]):::literal
v2 --"wdt:P31"--> c2
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P2580".-> v3
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P22".-> v4
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P25".-> v5
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P569".-> v1
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P19".-> v6
end
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P570".-> v7
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P20".-> v8
end
subgraph optional7["(optional)"]
style optional7 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P213".-> v9
end
subgraph optional8["(optional)"]
style optional8 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P214".-> v10
end
subgraph optional9["(optional)"]
style optional9 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P227".-> v11
end
v2 --"wdt:P2600"--> v12
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c15 --"wikibase:language"--> c17
end
bind5[/"?bblid"/]
v3 --o bind5
bind5 --as--o v13
bind6[/"?isni"/]
v9 --o bind6
bind6 --as--o v14
bind7[/"?viaf"/]
v10 --o bind7
bind7 --as--o v15
bind8[/"?gnd"/]
v11 --o bind8
bind8 --as--o v16
bind9[/"?geni"/]
v12 --o bind9
bind9 --as--o v17