Talk:Q3112009

From Wikidata
Jump to navigation Jump to search

Members[edit]

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes | Query: SELECT DISTINCT ?item ?who ?mem_start ?mem_end { wd:Q3112009 wdt:P2670 ?item ; wdt:P571 ?cabinet_start; wdt:P576 ?cabinet_end . OPTIONAL { ?who p:P39 [ ps:P39 ?item ; pq:P580 ?mem_start; pq:P582 ?mem_end ] . FILTER ( (?mem_end > ?cabinet_start) && (?mem_start < ?cabinet_end) ) } }
Article ?who ?mem_start ?mem_end
Chief Whip and Government Business Manager Tom McCabe 1999-05-17 2000-10-11
Deputy First Minister of Scotland Jim Wallace, Baron Wallace of Tankerness 1999-05-19 2005-06-23
First Minister of Scotland Donald Dewar 1999-05-13 2000-10-11
Lord Advocate Colin Boyd, Baron Boyd of Duncansby
Andrew Hardie, Baron Hardie
2000-02-24
1997-01-01
2006-10-04
2000-02-01
Minister for Children and Education Sam Galbraith 1999-05-17 2000-10-11
Minister for Enterprise and Lifelong Learning Henry McLeish 1999-05-17 2000-10-26
Minister for Finance Jack McConnell 1999-05-17 2000-10-26
Minister for Health and Community Care Susan Deacon 1999-05-17 2000-10-11
Minister for Justice Jim Wallace, Baron Wallace of Tankerness 1999-05-19 2003-05-21
Minister for Rural Affairs Ross Finnie 1999-05-19 2000-10-11
Minister for Social Inclusion, Local Government and Housing Wendy Alexander 1999-05-19 2000-10-11
Minister for Transport and the Environment Sarah Boyack 1999-05-17 2000-10-11
End of automatically generated list.

---

The underlying query behind this report is:

SELECT DISTINCT ?position ?positionLabel ?cabinet_start ?cabinet_end ?who ?whoLabel ?mem_start ?mem_end {
  wd:Q3112009 wdt:P2670 ?position ; wdt:P571 ?cabinet_start; wdt:P576 ?cabinet_end .
  OPTIONAL { 
    ?who p:P39 [ ps:P39 ?position ; pq:P580 ?mem_start; pq:P582 ?mem_end ] .
    FILTER ( (?mem_end > ?cabinet_start) && (?mem_start < ?cabinet_end) )
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
} 
ORDER BY ?positionLabel ?mem_start
Try it!