Error 1064.You have an error in your sql syntax,

I have the following syntax

DELIMITER $

CREATE TRIGGER TabelaInterm_BI BEFORE INSERT
ON Tabela_Intermediara FOR EACH ROW BEGIN
INSERT INTO Vizite
    (Data_Ora, Id_Medic, Id_Pacient, Id_Cabinet) VALUES 
    (NEW.Data_Ora, New.Id_Medic, New.Id_Pacient, New.Id_Cabinet,
    (SELECT 
    STR_TO_DATE(CONCAT(DataVizita,' ', OraIntrare), '%Y-%m-%d %H:%i:%s'),
(SELECT Id FROM Medici WHERE Nume=NumeMedic AND Prenume=PrenumeMedic),
(SELECT Id FROM Pacienti WHERE Nume=NumePacient AND Prenume=PrenumePacient),
(SELECT Id FROM Cabinete WHERE Denumire=Cabinet)

END $
DELIMITER ;

It gives me the error

#1064, and at line 12 where END $ is, it says 'Syntax error:missing 'closing paranthesis'! enter image description here