SQL
AخA
SELECT log.log_timestamp AS "timestamp", log.log_namespace AS "namespace", log.log_title AS "page", cmt.comment_text AS "comment"
FROM logging AS log
LEFT JOIN comment AS cmt ON log.log_comment_id = cmt.comment_id
/* WHERE log.log_type = "delete"
AND (log.log_action = "delete" OR log.log_action = "revision") */
WHERE log.log_action = "delete"
AND log.log_actor = 54890
ORDER BY log.log_timestamp DESC
LIMIT 1
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.