select temp.film_id,temp.title from
(select f.film_id,f.title,fc.category_id from
film f left join film_category fc
on f.film_id = fc.film_id) as temp where temp.category_id is null