$common_times = "SELECT timestamp FROM pcpu WHERE (nethost IN ($host_list)) GROUP BY timestamp HAVING (count(*) >= $percent_overlap_required)"; $result = $$dbh->selectall_arrayref("SELECT host,timestamp,val FROM pcpu WHERE (host IN ($host_list) AND timestamp IN ($common_times)) GROUP BY nethost,timestamp;");