query-ddb62e084c72f679168be2707bf6b664

rq turtle/ttl

Double cousins: children of 2 brothers marrying 2 sisters SELECT ?person ?personLabel ?relative ?relativeLabel ?link ?f1 ?f1Label ?m1 ?m1Label ?f2 ?f2Label ?m2 ?m2Label # ?gf1 ?gf1Label ?gm1 ?gm1Label # ?gf2 ?gf2Label ?gm2 ?gm2Label WITH { SELECT ?person ?f1 ?m1 ?relative ?f2 ?m2 ?link ?gf1 ?gf2 ?gm1 ?gm2 { ?person wdt:P22 ?f1 ; wdt:P25 ?m1 . ?relative wdt:P22 ?f2 ;wdt:P25 ?m2 . { ?f1 wdt:P3373 ?f2 . ?m1 wdt:P3373 ?m2 . BIND("2 brothers/2 sisters" as ?link) # checks to avoid half-siblings: ?f1 wdt:P22 ?gf1 ; wdt:P25 ?gm1 . ?f2 wdt:P22 ?gf1 ; wdt:P25 ?gm1 . ?m1 wdt:P22 ?gf2 ; wdt:P25 ?gm2 . ?m2 wdt:P22 ?gf2 ; wdt:P25 ?gm2 . } FILTER ( ?person != ?relative && ?f1 != ?f2 && ?m1 != ?m2 && ?gf1 != ?gf2 && ?gm1 != ?gm2 ) #avoid more closely related } LIMIT 200 } as %basic WHERE { # hint:Query hint:optimizer "None". INCLUDE %basic ?person wdt:P31 wd:Q5 . ?relative wdt:P31 wd:Q5 . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }

Use at

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#>
# Double cousins: children of 2 brothers marrying 2 sisters
SELECT 
  ?person ?personLabel
  ?relative ?relativeLabel
  ?link
  ?f1 ?f1Label
  ?m1 ?m1Label
  ?f2 ?f2Label
  ?m2 ?m2Label
  # ?gf1 ?gf1Label    ?gm1 ?gm1Label
  # ?gf2 ?gf2Label    ?gm2 ?gm2Label
WHERE
{
    # hint:Query hint:optimizer "None".

{
  SELECT   ?person   ?f1   ?m1   ?relative ?f2 ?m2 ?link ?gf1 ?gf2 ?gm1 ?gm2
  {
    ?person wdt:P22 ?f1 ; wdt:P25 ?m1 .
    ?relative wdt:P22 ?f2 ;wdt:P25 ?m2 .
    { ?f1 wdt:P3373 ?f2 . ?m1 wdt:P3373 ?m2 . BIND("2 brothers/2 sisters" as ?link)
    # checks to avoid half-siblings:
    ?f1 wdt:P22 ?gf1 ; wdt:P25 ?gm1 . 
    ?f2 wdt:P22 ?gf1 ; wdt:P25 ?gm1 .
    ?m1 wdt:P22 ?gf2 ; wdt:P25 ?gm2 .
    ?m2 wdt:P22 ?gf2 ; wdt:P25 ?gm2 .
    } 
    FILTER ( ?person != ?relative && ?f1 != ?f2 && ?m1 != ?m2 && ?gf1 != ?gf2  && ?gm1 != ?gm2 )  #avoid more closely related
  }  LIMIT 200
}    ?person wdt:P31 wd:Q5 .
    ?relative wdt:P31 wd:Q5 .
    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; v3("?f1"):::projected v4("?f2"):::projected v7("?gf1") v8("?gf2") v9("?gm1") v10("?gm2") v11("?link"):::projected v5("?m1"):::projected v6("?m2"):::projected v1("?person"):::projected v2("?relative"):::projected c7(["bd:serviceParam"]):::iri c5(["wd:Q5"]):::iri c9(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["?person != ?relative?f1 != ?f2?m1 != ?m2?gf1 != ?gf2?gm1 != ?gm2"]] f0 --> v1 f0 --> v2 f0 --> v3 f0 --> v4 f0 --> v5 f0 --> v6 f0 --> v7 f0 --> v8 f0 --> v9 f0 --> v10 v1 --"wdt:P22"--> v3 v1 --"wdt:P25"--> v5 v2 --"wdt:P22"--> v4 v2 --"wdt:P25"--> v6 v3 --"wdt:P3373"--> v4 v5 --"wdt:P3373"--> v6 bind1[/"'2 brothers/2 sisters'"/] bind1 --as--o v11 v3 --"wdt:P22"--> v7 v3 --"wdt:P25"--> v9 v4 --"wdt:P22"--> v7 v4 --"wdt:P25"--> v9 v5 --"wdt:P22"--> v8 v5 --"wdt:P25"--> v10 v6 --"wdt:P22"--> v8 v6 --"wdt:P25"--> v10 v1 --"wdt:P31"--> c5 v2 --"wdt:P31"--> c5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end