Problemas al ejecutar query

[echo_]

Hola a todos de nuevo por aqui, intento ejecutar este query pero tarda mucho en ejecutar la consulta, alguien me podria decir si esta sentencia se puede acortar mas?

Código MySQL:

SELECT   idPerson, MAX(updatedDate) AS updatedDate
FROM  (SELECT t.idPerson, MAX(d.updatedDate) AS updatedDate
FROM transacciones AS t 
INNER JOIN detalle_de_las_transacciones AS d ON d.idTransaction = t.idTransaction
WHERE (d.active = 1) AND (t.active = 1)
GROUP BY t.idPerson
 
UNION
 
SELECT t.idPerson, MAX(d.updatedDate) AS updatedDate
FROM transacciones AS t
INNER JOIN detalle_de_las_transacciones AS d ON d.idTransaction = t.idTransaction
WHERE (t.active = 0)
GROUP BY idPerson
 
UNION
 
SELECT t.idPerson, MAX(d.updatedDate) AS updatedDate
FROM transacciones AS t
INNER JOIN detalle_de_las_transacciones AS d ON d.idTransaction = t.idTransaction
GROUP BY idPerson
 
UNION
 
SELECT tl.idPerson, tl.createdDate AS updatedDate
FROM todos_los_leads AS tl
 
UNION
 
SELECT n.idCreatorObject, MAX(n.noteDate) AS updatedDate
FROM  NOTE_notes AS n
WHERE (idCreatorObjectType = 6)
GROUP BY idCreatorObject
 
UNION
 
SELECT tl.idPerson, tl.infoLastUpdated AS updatedDate
FROM todos_los_leads AS tl
 
UNION
 
SELECT tl.idPerson, tl.lastAssignment AS updatedDate
FROM todos_los_leads AS tl) AS dates
GROUP BY idPerson