$schema->resultset("Thing")->join('last_event_of_type1','last_event_of_type2')
  ->where('last_event_of_type1.timestamp' => { '>=', $cutoff1 },
          'last_event_of_type2.timestamp' => { '<', $cutoff2 });