sub epoch_to_iso {
my $t = shift || return;
+ $t += 60 * 60 * +2; # FIXME add TZ
my $dt = DateTime->from_epoch( epoch => $t ) || return;
print STDERR "BUG: $t != " . $dt->epoch . "\n" unless ($t == $dt->epoch);
return $dt->ymd . ' ' . $dt->hms;
$sql_where = " WHERE ". $where if ($where);
my $sql_order = qq{
- ORDER BY files.id
+ ORDER BY files.date
LIMIT $on_page
OFFSET ?
};