SQL WHERE über mehrere Einträge

[omata]

SQL-Code:

SELECT * 
FROM posts p
WHERE EXISTS (SELECT *
                FROM post_topics 
                WHERE post_id = p.post_id 
                  AND topic_id = 1)
  AND EXISTS (SELECT *
                FROM post_topics 
                WHERE post_id = p.post_id 
                  AND topic_id = 4)