SQL
AخA
SELECT
*
FROM `archive_userindex`
LEFT JOIN `logging_logindex` pd ON
pd.`log_type` = "delete"
AND pd.`log_title` = `ar_title`
AND pd.`log_namespace` = `ar_namespace`
AND pd.`log_timestamp` > `ar_timestamp`
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`
WHERE `ar_actor` = (
SELECT a.`actor_id` FROM `actor_logging` a WHERE a.`actor_name` = "Chlod"
) AND `ar_parent_id` = 0
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.