diff options
| -rw-r--r-- | ishtar_common/views_item.py | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/ishtar_common/views_item.py b/ishtar_common/views_item.py index 405920dd9..11d7a5345 100644 --- a/ishtar_common/views_item.py +++ b/ishtar_common/views_item.py @@ -41,6 +41,7 @@ from django.db.models import ( F, Q, Count, + Subquery, Sum, ImageField, ExpressionWrapper, @@ -2887,11 +2888,11 @@ def get_item( if split_type == "OR": items |= sub_items else: - # in Django m2m queries use the same JOIN... + # in Django m2m queries use the same JOIN # items &= sub_items do not work - items &= model.objects.filter(Q( - pk__in=list(sub_items.values_list("pk", flat=True)) - )) + items &= model.objects.filter( + id__in=Subquery(sub_items.values("id")) + ) if return_query: return items |