query-aab623e33e8c164e915d928e585cb8be

rq turtle/ttl

List humans having property P2580

Use at

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