Requête de recherche des événements répétés qui se terminent

SELECT *, (SELECT nom FROM bars AS b WHERE b.id=e1.id_bar) AS nom_bar FROM evenements AS e1 WHERE horaire_fin>1430690400 AND horaire_deb<1431295200 AND (SELECT COUNT(*) FROM evenements AS e2 WHERE e2.repeat_id=e1.repeat_id)>1 AND repeat_id NOT IN (SELECT repeat_id FROM evenements WHERE horaire_fin>1431295200 AND horaire_deb<1431900000) GROUP BY repeat_id