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'

​