

```python
def latest_approved(rows):
    found = {}
    for row in rows:
        if not row.get('approved'):
            continue
        rid = row['id']
        if rid not in found or row['revision'] >= found[rid]['revision']:
            found[rid] = row
    return [
        {'id': row['id'], 'revision': row['revision'], 'value': row.get('value')}
        for row in sorted(found.values(), key=lambda r: r['id'])
    ]
```