Get deleted page creations of user

Used to get the pages created by a user that have since been deleted.

Note that this query requires post-processing. Due to the way the `archive` table works, multiple log entries may be returned, causing the same ar_id to appear twice here. The receiving end must use post-processing to (1) match the correct `log_page` to `ar_page_id`, if the latter is not null, or (2) find the first logged deletion since after the page was created. The `` pd.`log_timestamp` > `ar_timestamp` `` clause here discards unlikely data to make this a tad faster.

SQL

SELECT
	*, (
      SELECT GROUP_CONCAT(ctd_name SEPARATOR ",")
      FROM change_tag
      JOIN change_tag_def ON ctd_id = ct_tag_id
      WHERE ct_log_id = log_id
    ) as ts_tags
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

SQL

Checking query status...