Talk:Q3112283

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:Q3112283 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
Deputy First Minister of Scotland Jim Wallace, Baron Wallace of Tankerness 1999-05-19 2005-06-23
First Minister of Scotland Henry McLeish 2000-10-27 2001-11-08
Lord Advocate Colin Boyd, Baron Boyd of Duncansby 2000-02-24 2006-10-04
Minister for Education, Europe and External Affairs Jack McConnell 2000-10-26 2001-11-22
Minister for Enterprise and Lifelong Learning Wendy Alexander 2000-10-27
2000-11-01
2001-11-08
2001-11-28
Minister for Environment and Rural Development Ross Finnie 2001-03-01 2001-11-08
Minister for Environment, Sport and Culture Sam Galbraith 2000-10-27 2001-03-01
Minister for Finance and Local Government Angus MacKay 2000-10-27 2001-11-08
Minister for Health and Community Care Susan Deacon 2000-10-27 2001-11-08
Minister for Justice Jim Wallace, Baron Wallace of Tankerness 1999-05-19 2003-05-21
Minister for Parliament Tom McCabe 2000-10-27 2001-11-08
Minister for Rural Development Ross Finnie 2000-10-27 2001-03-01
Minister for Social Justice Jackie Baillie 2000-10-27 2001-11-08
Minister for Transport and Planning Sarah Boyack 2001-03-01 2001-11-08
Minister for Transport and Telecommunications Sarah Boyack 2000-10-27 2001-03-01
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:Q3112283 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!