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 ') AND CINEMAS.STATUS = 0 GROUP BY NOMECINEMA' at line 1-SELECT DISTINCT(HORA_CINE.COD_FILME) as NOMECINEMA FROM CINEMAS, HORA_CINE WHERE HORA_CINE.COD_CINEMA = CINEMAS.CODIGO AND DATA_I <= '2026-06-08' AND DATA_F >= '2026-06-08' AND CINEMAS.CODIGO IN ( ) AND CINEMAS.STATUS = 0 GROUP BY NOMECINEMA;