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 DISTINCT ON (rev_actor)
revision.* 
FROM revision
WHERE rev_actor = 42036
ORDER BY rev_actor, rev_timestamp DESC;
SQL

Checking query status...
