}

    @Override
    public int getFetchPageNumber() {
        return getSqlClause().getFetchPageNumber();
    }

    @Override
    public int getPageStartIndex() {
        return getSqlClause().getPageStartIndex();
    }

    @Override
    public int getPageEndIndex() {
        return getSqlClause().getPageEndIndex();
    }

    @Override

    }

    @Override
    public int getFetchPageNumber() {
        return getSqlClause().getFetchPageNumber();
    }

    @Override
    public int getPageStartIndex() {
        return getSqlClause().getPageStartIndex();
    }

    @Override
    public int getPageEndIndex() {
        return getSqlClause().getPageEndIndex();
    }

    @Override

    }

    @Override
    public int getFetchPageNumber() {
        return getSqlClause().getFetchPageNumber();
    }

    @Override
    public int getPageStartIndex() {
        return getSqlClause().getPageStartIndex();
    }

    @Override
    public int getPageEndIndex() {
        return getSqlClause().getPageEndIndex();
    }

    @Override

        final SearchRequestBuilder builder = client.prepareSearch(asEsIndex());
        final int from;
        final int size;
        if (cb.isFetchScopeEffective()) {
            from = cb.getPageStartIndex();
            size = cb.getFetchSize();
        } else {
            from = 0;
            size = 10;
        }
        builder.setFrom(from);
        builder.setSize(size);

        final SearchRequestBuilder builder = client.prepareSearch(asEsIndex());
        final int from;
        final int size;
        if (cb.isFetchScopeEffective()) {
            from = cb.getPageStartIndex();
            size = cb.getFetchSize();
        } else {
            from = 0;
            size = 10;
        }
        builder.setFrom(from);
        builder.setSize(size);

        final SearchRequestBuilder builder = client.prepareSearch(asEsIndex());
        final int from;
        final int size;
        if (cb.isFetchScopeEffective()) {
            from = cb.getPageStartIndex();
            size = cb.getFetchSize();
        } else {
            from = 0;
            size = 10;
        }
        builder.setFrom(from);
        builder.setSize(size);