My actor_id, actor_user, actor_name

SQL

#SELECT * FROM actor WHERE actor_user = 120801;

# my first edit
#SELECT 
#DENSE_RANK() OVER (
#  PARTITION BY actor_name ORDER BY rev_timestamp DESC
#) AS dense_rank, rev_timestamp, rev_actor
#FROM revision_userindex  JOIN actor ON rev_actor = actor_id
#WHERE actor_name = 'Vexations'

                         
#SELECT rev_timestamp
# FROM revision_userindex  JOIN actor ON rev_actor = actor_id
#WHERE actor_name = 'Vexations'
#AND rev_timestamp > 20200101120000
# LIMIT 10

# SELECT * FROM actor WHERE actor_name = 'Vexations'

SELECT DENSE_RANK() OVER (PARTITION BY rev_actor ORDER BY rev_timestamp) AS rank, rev_id, rev_timestamp, rev_actor 
FROM revision_userindex WHERE rev_actor = 42036 AND rev_timestamp > 20200201120000
ORDER BY rev_actor, rev_timestamp DESC;
SQL

Checking query status...
