select film.film_id,film.title from film where film_id not in 
(select d.film_id from (film f join film_category fc  on f.film_id=fc.film_id
join category c on c.category_id=fc.category_id ) d )