my $items = $self->db->resultset('Item')->search({},{
    '+select' => ...
    'join' => ...
    where => {
      -or => ...
      'start_datetime' => {'<=' => \'NOW()'},
      'end_datetime' => {'>=' => \'NOW()'},
    },
    group_by => ...
    order_by => ...
  });