Untitled query #72289

SQL

select `log_id`,
       `log_timestamp`,
       `log_params`,
       (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,
       `actor_id`,
       `actor_name`,
       `comment_id`,
       `comment_text`
from `logging_userindex`
         left join `actor_logging` on `log_actor` = `actor_id`
         left join `comment_logging` on `log_comment_id` = `comment_id`
where `log_type` = 'delete'
  and `log_action` = 'revision'
  and `log_params` LIKE "%i:1167221635;%"
order by `log_timestamp` asc
SQL

Checking query status...
