query-502b22be9bef0ccebacae23144dc24d8
Biologists with Twitter accounts SELECT DISTINCT ?person ?personLabel ?twitterName WHERE { ?person wdt:P2002 ?twitterName ; wdt:P106 ?occupation . ?occupation wdt:P279* wd:Q864503 . # all subclasses of biologists FILTER NOT EXISTS { ?person wdt:P496 ?orcid } SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } }
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#>
#Biologists with Twitter accounts
SELECT DISTINCT ?person ?personLabel ?twitterName
WHERE {
?person wdt:P2002 ?twitterName ;
wdt:P106 ?occupation .
?occupation wdt:P279* wd:Q864503 . # all subclasses of biologists
FILTER NOT EXISTS { ?person wdt:P496 ?orcid }
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?occupation")
v2("?orcid")
v1("?person"):::projected
v3("?twitterName"):::projected
c7(["bd:serviceParam"]):::iri
c9(["en"]):::literal
c5(["wd:Q864503"]):::iri
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"wdt:P496"--> e0v2
e0v2("?orcid"):::projected
e0v1("?person"):::projected
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> c1
f0 --> v2
v1 --"wdt:P496"--> v2
v1 --"wdt:P2002"--> v3
v1 --"wdt:P106"--> v4
v4 --"wdt:P279"--> c5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end