query-f2d42c2f753e25594df71a1f1d299097
Propertiesinstance of (P31)place of birth (P19)country (P17)date of birth (P569)date of death (P570)place of death (P20) Propertiesinstance of (P31)place of birth (P19)country (P17)date of birth (P569)date of death (P570)place of death (P20) Propertiesinstance of (P31)place of birth (P19)country (P17)date of birth (P569)date of death (P570)place of death (P20)
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 distinct ?itemLabel ?item ?number ?dob ?pobLabel ?dod ?podLabel
where {
{ # select all the numbers of sitelinks
select ?number (count(*) as ?total) {
[] wikibase:sitelinks ?number .
} group by ?number
}.
filter (?number > 40) .
?item wikibase:sitelinks ?number .
?item wdt:P31 wd:Q5.
?item wdt:P19 ?pob.
?pob wdt:P17 wd:Q214.
OPTIONAL { ?item wdt:P569 ?dob }
OPTIONAL { ?item wdt:P570 ?dod }
OPTIONAL { ?item wdt:P20 ?pod }
?sitelink <http://schema.org/about> ?item .
service wikibase:label { bd:serviceParam wikibase:language "sk,en". }
} order by desc(?number)
Query found at
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Slovakia/Showcase_Queries
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Slovakia/Showcase_Queries/cs
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Slovakia/Showcase_Queries/en
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Slovakia/Showcase_Queries/nl
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?dob"):::projected
v6("?dod"):::projected
v3("?item"):::projected
v1("?number"):::projected
v4("?pob")
v7("?pod")
v8("?sitelink")
v2("?total")
a1((" "))
c7(["wd:Q214"]):::iri
c13(["bd:serviceParam"]):::iri
c4(["wd:Q5"]):::iri
c15(["sk,en"]):::literal
f0[["?number > '40^^xsd:integer'"]]
f0 --> v1
a1 --"wikibase:sitelinks"--> v1
bind2[/"count(*)"/]
bind2 --as--o v2
v3 --"wikibase:sitelinks"--> v1
v3 --"wdt:P31"--> c4
v3 --"wdt:P19"--> v4
v4 --"wdt:P17"--> c7
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P569".-> v5
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P570".-> v6
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v3 -."wdt:P20".-> v7
end
v8 --http://schema.org/about--> v3
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c13 --"wikibase:language"--> c15
end