Wikidata talk:WikiProject Genealogy/numbers/descendants

SELECT
  ?subject ?subjectLabel ?dob 
  ?relative ?relativeLabel ?dob2
{ 
  BIND( wd:Q57224 as ?subject )
  ?subject wdt:P40+ ?relative . 
  ?subject wdt:P569 ?dob .
  ?relative wdt:P569 ?dob2 .
  FILTER (?dob > ?dob2 )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

SELECT
  ?subject ?subjectLabel ?dob 
  ?relative ?relativeLabel ?dob2
  ?parent ?parentLabel ?dob3 
{ 
  BIND( wd:Q57224 as ?subject )
  ?subject wdt:P40+ ?relative . 
  ?subject wdt:P569 ?dob .
  ?relative wdt:P569 ?dob2 .
  FILTER (?dob > ?dob2 )
  ?parent wdt:P40 ?relative .
  ?parent wdt:P569 ?dob3 .
  FILTER (?dob3 > ?dob2 )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

SELECT ?depth ?item ?itemLabel ?dob2 ?dod2
WHERE
{
  BIND( wd:Q57224 as ?s ) 
  ?s wdt:P569 ?dob ; wdt:P570 ?dod .
  SERVICE gas:service {
    gas:program gas:gasClass "com.bigdata.rdf.graph.analytics.SSSP" ;
                gas:in wd:Q57224 ;
                gas:traversalDirection "Forward" ;
                gas:out ?item ;
                gas:out1 ?depth ;
                gas:maxIterations 100 ;
                gas:linkType wdt:P40 .
  }
  OPTIONAL { ?item wdt:P569 ?dob2 }
  OPTIONAL { ?item wdt:P570 ?dod2 }
  FILTER ( !BOUND(?dod2) || ?dod2 < ?dob )
  FILTER ( !BOUND(?dob2) || ?dob2 < ?dod )    
  FILTER ( !BOUND(?dod2) || ?dod2 < ?dob )    
  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}