SQL
AخA
SELECT page_title, DATE_FORMAT(rev_timestamp,'%Y%m%d%H%i%s')
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 YEAR)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.