SQL
AخA
SELECT
*
FROM `archive_userindex`
RIGHT JOIN `logging_logindex` pd ON pd.`log_title` = (
SELECT pds.`log_title` FROM `logging_logindex` pds
WHERE pds.`log_page` = `ar_page_id` AND pds.`log_type` = "delete" AND pds.`log_action` = "delete"
AND pds.`log_timestamp` > `ar_timestamp`
ORDER BY pds.`log_timestamp` DESC
LIMIT 1
)
LEFT JOIN `actor_logging` ad ON ad.`actor_id` = pd.`log_actor`
LEFT JOIN `comment_logging` cd ON cd.`comment_id` = pd.`log_comment_id`
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.