SELECT @RNUM := @RNUM + 1 AS ROWNUM, EVENT_SCHEMA, EVENT_NAME, INTERVAL_FIELD, EVENT_DEFINITION, LAST_EXECUTED FROM information_schema.EVENTS, (SELECT @RNUM := 0) R ORDER BY LAST_EXECUTED DESC