Erro em:
SELECT DISTINCTROW Obra.id AS idObra, Obra.nome, Obra.instrumentos, Obra.tonalidade, Compositor.id AS idCompositor, Compositor.nome AS compositor, Compositor.prenomeAbreviado AS prenome
FROM Temporada
LEFT JOIN Evento ON Temporada.id = Evento.idTemporada
LEFT JOIN Evento_Programa ON Evento.id = Evento_Programa.idEvento
LEFT JOIN Programa_Obra ON Programa_Obra.idPrograma = Evento_Programa.idPrograma
LEFT JOIN Obra ON Programa_Obra.idObra = Obra.id
LEFT JOIN Compositor ON Obra.idCompositor = Compositor.id
WHERE Temporada.id
IN ()
AND Programa_Obra.idObra > 0
AND MID(Compositor.nome,1,1) <> '-'
ORDER BY Compositor.nome, Obra.nome
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 Programa_Obra.idObra > 0
AND MID(Compositor.nome,1,1) <> '-'
ORDER BY Comp' at line 9(1064)
