}

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

    @Override
    public boolean isFetchScopeEffective() {
        return getSqlClause().isFetchScopeEffective();
    }

    @Override
    public int getFetchNarrowingSkipStartIndex() {
        return getPageStartIndex();
    }

    @Override

    }

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

    @Override
    public boolean isFetchScopeEffective() {
        return getSqlClause().isFetchScopeEffective();
    }

    @Override
    public int getFetchNarrowingSkipStartIndex() {
        return getPageStartIndex();
    }

    @Override

    }

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

    @Override
    public boolean isFetchScopeEffective() {
        return getSqlClause().isFetchScopeEffective();
    }

    @Override
    public int getFetchNarrowingSkipStartIndex() {
        return getPageStartIndex();
    }

    @Override

        // #pending check response
        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);

        // #pending check response
        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);

        // #pending check response
        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);