Select Code to Download

select topic, category, date
  from alarms
 order by topic, date

my $data = $dbh->ct_sql($query);
my $previous_row;
...
if($previous_row) {
    print "$previous_row->[0] $previous_row->[1] $previous\n";
}

select id = max(id), topic, category, date = max(date)
  into #tmp
...
   and t2.category = "OK NOW"
   and t1.topic = t2.topic
   and t1.date > t2.date