select a.film_id,a.title
from film a
left join film_category b on a.film_id=b.film_id
left join category c on b.category_id=c.category_id
where c.category_id is null