gistfile1.txt

class LeagueMatchup {
   League l
   Team a
   Team b
   Date lastGameEnd

   List<Team> getTeams() {
       return [a,b]
   }

   boolean withinTime(Date d) {
       return (d.time - lastGameEnd.time) < (1000L * 60 * 60 * 180)
   }

   String getKey() { 
       l.league_id + '|' + [a,b].collect { it.valve_id }.sort{}.join('|')   // we want to ignore the start from the lookup
   }
}

Map<Team, LeagueMatchup> prevLookup = [:]
Map<String, Series> seriesLookup = [:]

Matches.list().each { m ->
  prevA = prevLookup.get(m.teams[0])
  prevB = prevLookup.get(m.teams[1])

  if ((prevA) && (prevB) && (prevA == prevB) && (prevA.withinTime(m.startDate)) {
	Series series = seriesLookup.get(prevA.key) ?: new Series()
	seriesLookup[prevA.key] = series
        m.series = series
  }

  newLm = new LeagueMatchup(l: m.league, a: m.teams[0], b: m.teams[1], lastGame: m.startDate + m.duration)  
  
  m.teams.each { prevLookup[it] = newLm }
}