How to convert such request to ORM?

Question

Django

Hello, I want to make such selections

SELECT * FROM posts WHERE category.id = id AND tag.id IN (1, 2, 3)

How to do it right?

Answer 1

`Post.objects.filter(category=category_id, tag__in=(1, 2, 3))`

Answer 2

Engine repair through the exhaust pipe. Models to see. I suspect something like this

Post.objects.filter(category_id=cat_id, tag_id__in=[1, 2, 3])

Answer 3

Posts.objects.filter(category=category.name, tags__in=(tag1, tag2, tag3))