my lastest edit

SQL

#SELECT page_title, DATE_FORMAT(rev_timestamp,'%Y-%m-%d')
#FROM actor 
#JOIN revision_userindex ON  `actor_id` = `rev_actor`
#JOIN page on rev_page = page_id
#WHERE actor_name = 'Vexations'
#AND rev_timestamp > (NOW() - INTERVAL 1 DAY)


#SELECT rev_timestamp
#FROM revision r1
#WHERE rev_timestamp = (
#  SELECT MAX(rev_timestamp) FROM revision 
#  WHERE rev_actor = 42036
#  )
#  
#ORDER BY rev_actor, rev_timestamp;

SELECT rev_timestamp, page_title
FROM revision_userindex JOIN page ON rev_page=page_id
JOIN actor ON `actor_id` = `rev_actor`
WHERE actor_name = 'Vexations'
ORDER BY rev_actor, rev_timestamp DESC
LIMIT 1;
SQL

Checking query status...
