query-5fb241a38ebf7db9872a303f28e8b7c3
TODO
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 schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel (count(distinct ?wikipedia) as ?count)
WHERE
{
?item wikibase:sitelinks ?sitelinks . # There are linked to ...
FILTER (?sitelinks >= 20) # ... 20 or more wikis (Wikipedias or other)
?item wdt:P106/wdt:P279* wd:Q169470. # they're some sort of physicist
?item wdt:P569 ?dateOfBirth. # they have a date of birth
# (go faster, little query; all dates are dates)
FILTER("1911-00-00"^^xsd:date <= ?dateOfBirth) # DoB is after 1910
FILTER NOT EXISTS {?item wdt:P570 [] .} # WD doesn't think they're dead - no date of death
?article schema:about ?item ; # they have a sitelink
schema:isPartOf ?wikipedia . # which is part of ...
?wikipedia wikibase:wikiGroup "wikipedia" # ... one or other wikipedia
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} group by ?item ?itemLabel having (?count >19)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?article")
v7("?count")
v3("?dateOfBirth")
v2("?item"):::projected
v4("?sitelinks")
v6("?wikipedia"):::projected
a1((" "))
a2((" "))
c8(["wd:Q169470"]):::iri
c15(["bd:serviceParam"]):::iri
c17(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c13(["wikipedia"]):::literal
f0[["?count > '19^^xsd:integer'"]]
f0 --> v7
f1[["not "]]
subgraph f1e0["Exists Clause"]
e0v1 --"wdt:P570"--> e0a1
e0v1("?item"):::projected
e0a1((" ")):::projected
end
f1--EXISTS--> f1e0
f1 --> v2
f1 --> c2
f1 --> a1
v2 --"wdt:P570"--> a1
f2[["'1911-00-00^^xsd:date' <= ?dateOfBirth"]]
f2 --> v3
f3[["?sitelinks >= '20^^xsd:integer'"]]
f3 --> v4
v2 --"wikibase:sitelinks"--> v4
v2 --"wdt:P106"--> a2
a2 --"wdt:P279"--> c8
v2 --"wdt:P569"--> v3
v5 --"schema:about"--> v2
v5 --"schema:isPartOf"--> v6
v6 --"wikibase:wikiGroup"--> c13
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c15 --"wikibase:language"--> c17
end
bind5[/"count(?wikipedia)"/]
v6 --o bind5
bind5 --as--o v7