Select Code to Download

        my $query = 'select event.* from event where sid = 1 order by 
+timestamp desc, event.sid desc, event.cid desc';

...
            ## whatever ....

        }

package MyClass;

...
__PACKAGE__->has_many(events => 'MyClass::Event' => signature);

# ....

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";