Context Navigation

Changes between Version 4 and Version 5 of Ticket #33973, comment 2

-              v4
+              v5
 {{{
 Content.objects.all().annotate(
+        unread=Greatest(
+            Exists(
+                # a thread has no user entry (0.03s on 3.1.14 vs 0.30s on 3.2.15)
+                Thread.objects.filter(
+                    content=OuterRef('pk'),
+                ).exclude(threadentry__user=user)
+            ),
+            False,
+        )
+    unread=Exists(
+            Thread.objects.filter(
+                content=OuterRef('pk'),
+            ).exclude(threadentry__user=user)
     ).filter(
         unread=True,