SELECT film.film_id,film.title FROM film where film.film_id not in (
SELECT fc.film_id id FROM `film` f RIGHT join film_category fc on f.film_id = fc.film_id)