CUSTOM ALERT - DEADLOCK MySQL Aurora Version


in reference to the CUSTOM-ALERT DEADLOCK 
written for repository SQL SERVER
This is for anyone needing it fixed for MySQL Aurora

code:

SELECT char(13) + char(10) +

'URL: SRVEFEVMDPA:8123/.../deadlockDetails.iwc' + CAST(DB_ID as CHAR) + '&dl_id=' + CAST(DB_ID as CHAR) + char(13) + char(10)

, 1

FROM (

SELECT #DBID# AS DB_ID, dl.*, dlo.name
FROM `smartx-dpa`.CON_DEADLOCK_#DBID# dl
LEFT OUTER JOIN `smartx-dpa`.CON_DEADLOCK_OBJ_#DBID# dlo ON (dl.ID = dlo.ID)

) dl

WHERE D > DATE_ADD(NOW(),INTERVAL -5 MINUTE);