Contao\Database\Statement::limit PHP Method

    public function limit($intRows, $intOffset = 0)
    {
        if ($intRows <= 0) {
            $intRows = 30;
        }
        if ($intOffset < 0) {
            $intOffset = 0;
        }
        if (strncasecmp($this->strQuery, 'SELECT', 6) === 0) {
            $this->strQuery .= ' LIMIT ' . $intOffset . ',' . $intRows;
        } else {
            $this->strQuery .= ' LIMIT ' . $intRows;
        }
        return $this;
    }