+my $get_all_branches = qq{
+
+ select distinct branch
+ from nrecent_failures
+ where branch <> 'HEAD'
+ order by branch desc
+
+};
+
+my $all_branches = $db->selectcol_arrayref($get_all_branches);
+unshift (@$all_branches,'HEAD');
+
+my $get_all_members = qq{
+
+ select distinct sysname
+ from nrecent_failures
+ order by sysname
+
+};
+
+my $all_members = $db->selectcol_arrayref($get_all_members);
+
+my $get_all_stages = qq{
+
+ select distinct build_status.stage
+ from build_status
+ join nrecent_failures using (sysname,snapshot,branch)
+
+};
+
+my $all_stages = $db->selectcol_arrayref($get_all_stages);
+