Next ##

##

  $sth = $self->param('dbh_shopping')->prepare(qq{
    SELECT
      ... a somewhat large query ...
    WHERE catalogId = ?
    LIMIT ?, ?
  });
  my $start_item = ($self->query->param('startitem') > 0)
    ? $self->query->param('startitem') - 1 : 0;

##

##

  $sth->execute(
    $self->param('catalog_id'),
    $start_item,
    20
  );

##

##

$start_item + 0
int($start_item)
my $start_item2 = $start_item;

##

##

  my $this_stupid_counter = 0;
  for (my $x=0; $x<$self->query->param('startitem'); $x++) {
    $this_stupid_counter++;
  }


  $sth->execute(
    $self->param('catalog_id'),
    $this_stupid_counter,
    20
  );