my ($timestamp) = $dbh->selectrow_array(q{SELECT MAX(modified)::timestamp AS modified
FROM raid_targets WHERE raid = $1},undef,$raid->{id});
$c->stash(timestamp => $timestamp);
my ($timestamp) = $dbh->selectrow_array(q{SELECT MAX(modified)::timestamp AS modified
FROM raid_targets WHERE raid = $1},undef,$raid->{id});
$c->stash(timestamp => $timestamp);
WHERE r.raid = ? AND modified > ?
});
$targets->execute($raid->{id},$from);
}elsif($target){
WHERE r.raid = ? AND modified > ?
});
$targets->execute($raid->{id},$from);
}elsif($target){
WHERE r.raid = $1 AND r.id = $2
});
$targets->execute($raid->{id},$target);
WHERE r.raid = $1 AND r.id = $2
});
$targets->execute($raid->{id},$target);
WHERE target = ? AND wave = ?
});
$query->execute($joinable,$target,$wave);
WHERE target = ? AND wave = ?
});
$query->execute($joinable,$target,$wave);