SQL
x
SELECT
page_namespace,
page_title,
(SELECT DATE_FORMAT(MAX(rc_timestamp), '%Y-%m-%d %H:%i') FROM recentchanges_userindex
JOIN actor_recentchanges ON rc_actor = actor_id AND actor_name = 'SDZeroBot'
WHERE rc_namespace = page_namespace AND rc_title = page_title
) AS last_edit
FROM page
JOIN categorylinks ON cl_from = page_id AND cl_to = 'SDZeroBot_database_report_subscriptions'
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.