Fork of
Untitled query #41130
by SoWhy
This query is marked as a draft
This query has been published
by SoWhy.
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 actor AS act ON log.log_actor = act.actor_id 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") AND act.actor_user = 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.