select aa.film_id,aa.title from  film aa
left join film_category bb
on aa.film_id=bb.film_id
left join category cc
on cc.category_id=bb.category_id
where cc.category_id is null