- my $query = $DBH->prepare(q{SELECT x,y,z,tick FROM planet_stats WHERE id = ?});
- my $scan = q{
+ $query = $DBH->prepare(q{SELECT x,y,z,tick FROM planet_stats WHERE id = ?});
+ $scan = q{
- my $query = $DBH->prepare(q{SELECT DISTINCT ON (type) type,scan_id, tick, scan FROM scans WHERE planet = ?
+ $query = $DBH->prepare(q{SELECT DISTINCT ON (type) type,scan_id, tick, scan FROM scans WHERE planet = ?
GROUP BY type,scan_id, tick, scan ORDER BY type,tick DESC});
$query->execute($planet_id);
my %scans;
GROUP BY type,scan_id, tick, scan ORDER BY type,tick DESC});
$query->execute($planet_id);
my %scans;