query-1c34b02a11380ac73eb953eb59c59cff
Brothers and sisters without P3373 works. What is wrong in mine please? similar queryHi, I'm trying to find all people with same mother and father but without P3373. But, even without the filter on P3373, I've got no results while a
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 ?father ?mother ?child1 ?child1Label ?child2 ?child2Label WHERE {
?child1 wdt:P31 wd:Q5;
wdt:P22 ?father;
wdt:P25 ?mother.
?child2 wdt:P31 wd:Q5;
wdt:P22 ?father;
wdt:P25 ?mother.
#MINUS {?child1 wdt:P3373 ?child2}
FILTER (?child1 =! ?child2)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?child1"):::projected
v2("?child2"):::projected
v3("?father"):::projected
v4("?mother"):::projected
c6(["bd:serviceParam"]):::iri
c2(["wd:Q5"]):::iri
c8(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["?child1 = not ?child2"]]
f0 --> v1
f0 --> v2
v1 --"wdt:P31"--> c2
v1 --"wdt:P22"--> v3
v1 --"wdt:P25"--> v4
v2 --"wdt:P31"--> c2
v2 --"wdt:P22"--> v3
v2 --"wdt:P25"--> v4
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c6 --"wikibase:language"--> c8
end