query-3d5dc1cea4c8c544cad45ed0b238e86f

rq turtle/ttl

MPs who entered Parliament before their parents did

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?item ?itemLabel ?item_earliest ?parent ?parentLabel ?parent_earliest ?years
WHERE {
  { select distinct ?item (min(?start) as ?item_earliest) where {
    ?item p:P39 ?ps .?ps ps:P39 ?term . 
    {?term wdt:P279 wd:Q16707842 } UNION { ?term wdt:P279 wd:Q18015642 } UNION { ?term wdt:P279 wd:Q18018860 }
    { ?ps pq:P580 ?start } union { ?term wdt:P571 ?start . filter not exists { ?ps pq:P580 [] } }
  } group by ?item }

  { select distinct ?parent (min(?start) as ?parent_earliest) where {
    ?parent p:P39 ?ps .?ps ps:P39 ?term . 
    {?term wdt:P279 wd:Q16707842 } UNION { ?term wdt:P279 wd:Q18015642 } UNION { ?term wdt:P279 wd:Q18018860 }
    { ?ps pq:P580 ?start } union { ?term wdt:P571 ?start . filter not exists { ?ps pq:P580 [] } }
  } group by ?parent }
  ?item wdt:P22

Query found at