SELECT CONCAT(
    "# [[User talk:", page_title, "]]: ",
    DATE_FORMAT(log_time, "%M %e, %Y at %H:%i:%s UTC")
)
FROM
    (SELECT page_title, MAX(log_timestamp) AS log_time
    FROM revision
    JOIN page ON page_id = rev_page
    JOIN logging_ts_alternative ON page_title = log_title
    WHERE rev_user = 15644871
    AND page_namespace = 3
    AND page_title NOT LIKE "%/%"
    AND log_type = "block"
    AND log_action = "block"
    AND log_namespace = 2
    GROUP BY page_title)
AS temp
ORDER BY log_time DESC;