SET @sName = 'bx_ocean'; -- ALERTS SET @iHandler := (SELECT `id` FROM `sys_alerts_handlers` WHERE `name` = @sName LIMIT 1); DELETE FROM `sys_alerts` WHERE `handler_id` = @iHandler; DELETE FROM `sys_alerts_handlers` WHERE `id` = @iHandler;