sub all {

    my ($app, $pager) = @_;

    my $LIMIT_CLAUSE;

    if ($pager) {
	$LIMIT_CLAUSE 
	  = sprintf "LIMIT %d, %d", $pager->skipped, $pager->entries_per_page;
    }


    my $query =<<"EOSQL";

SELECT * FROM table_name
$LIMIT_CLAUSE

EOSQL