doctrine / orm

            $sql .= ' ORDER BY ' . $orderBySql;

        }

        if ($limit !== null || $offset !== null) {

            $sql = $this->platform->modifyLimitQuery($sql, $limit, $offset);

        }

        if ($lockMode === null || $lockMode === false || $lockMode === LockMode::NONE) {

            return $sql;

    {

        $limit  = $criteria->getMaxResults();

        $offset = $criteria->getFirstResult();

        if ($limit !== null || $offset !== null) {

            return $this->platform->modifyLimitQuery('', $limit, $offset);

        }

        return '';

    }

}