An Error Was Encountered

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR f.id IN (SELECT r.id_film FROM registi r WHERE r.id_professionista = ) ORDE' at line 3

SELECT f.titolo, f.anno, f.pagina_html FROM (`film` f) WHERE f.id IN (SELECT c.id_film FROM cast c WHERE c.id_professionista = ) OR f.id IN (SELECT r.id_film FROM registi r WHERE r.id_professionista = ) ORDER BY f.anno asc