def adjuster_all_unread():
    claims = Claim.objects.filter(
        adjuster='123'
    ).annotate(
        last_viewed_at=Subquery(History.objects.filter(
            history_type='VIEW',
            created_by='123',
            claim=OuterRef('pk')
        ).values('created').order_by('-id')[:1])
    )

    claims = claims.annotate(
        has_notes=Exists(
            Note.objects.filter(
                claim=OuterRef('pk'),
                created__gte=OuterRef('last_viewed_at')
            )
        )
    )

    return claims.exclude(has_notes=False)