

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