I am curious - did you touch the problem with the http://www.class-dbi.com/cgi-bin/wiki/index.cgi?CdbiPager not having a method for LIMITing the output from the database? There seems to be a solution on the linked page - but I personally would be scary to use it.