# Use this for calculating running stats my $all_current_plays = $game->plays->search({ GameIdentifier => $play->GameIdentifier, id => { '<=', $play->id } })->search(undef, { cache => 1 } ); my $all_current_home_plays = $all_current_plays->search({ b_home_possession => 1 })->search(undef, { cache => 1 }); my $all_current_away_plays = $all_current_plays->search({ b_home_possession => 0 })->search(undef, { cache => 1 });