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