my $page_size = 24;
my $page_num = 3;
my $offset = ($page_num - 1) * $page_size;

my $query = "select * from event where sid = 1 order by timestamp desc, event.sid desc, event.cid desc OFFSET $offset LIMIT $page_size";