SELECT f.film_id, f.title
FROM film f
LEFT JOIN film_category fc on f.film_id=fc.film_id
LEFT JOIN category c on fc.category_id = c.category_id
WHERE c.category_id is null