SELECT * FROM film f WHERE film_id IN ( SELECT film_id FROM film_category fc WHERE fc.film_category IN (6,11) );