query-d25cd7734fdd989ebf022be1c1c988cc
title: humans with double gender (non trans) SELECT ?item where { # (count(distinct ?item) as ?count) WHERE { # ?item wdt:P21 wd:Q6581072 . ?item wdt:P21 wd:Q6581097 . filter not exists {?item wdt:P21/wdt:P279* wd:Q189125 } ?item wdt:P31 wd:Q5 . #bind (replace(xsd:string(?item),"http://www.wikidata.org/entity/","") as ?itemQid)
#SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en" } . } order by ?item offset 0 limit 100
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 bd: <http://www.bigdata.com/rdf#>
#title: humans with double gender (non trans)
SELECT ?item where { # (count(distinct ?item) as ?count) WHERE { #
?item wdt:P21 wd:Q6581072 .
?item wdt:P21 wd:Q6581097 .
filter not exists {?item wdt:P21/wdt:P279* wd:Q189125 }
?item wdt:P31 wd:Q5 .
#bind (replace(xsd:string(?item),"http://www.wikidata.org/entity/","") as ?itemQid)
#SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en" } .
} order by ?item offset 0 limit 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?item"):::projected
a1((" "))
c3(["wd:Q189125"]):::iri
c5(["wd:Q6581097"]):::iri
c7(["wd:Q5"]):::iri
c4(["wd:Q6581072"]):::iri
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"wdt:P21"--> e0a1
e0a1 --"wdt:P279"--> e0c3
e0v1("?item"):::projected
e0a1((" ")):::projected
e0c3(["wd:Q189125"]):::iri
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> c1
f0 --> a1
f0 --> c2
f0 --> c3
v1 --"wdt:P21"--> a1
a1 --"wdt:P279"--> c3
v1 --"wdt:P21"--> c4
v1 --"wdt:P21"--> c5
v1 --"wdt:P31"--> c7