Untitled query #89513

SQL

SELECT 
    user.user_name AS target_user_name, 
    actor_user.user_name AS actor_user_name,
    logging.log_timestamp, 
    logging.log_title,
    comment.comment_text,
    SUBSTRING_INDEX(SUBSTRING_INDEX(logging.log_params, '"', 7), '"', -2) AS group_changed
FROM 
    user AS target_user
JOIN 
    logging ON logging.log_actor = target_user.user_id
JOIN 
    comment ON logging.log_comment_id = comment.comment_id
JOIN 
    user AS actor_user ON logging.log_actor = actor_user.user_id
WHERE 
    logging.log_type = 'rights'
    AND logging.log_action = 'rights'
    AND logging.log_timestamp >= DATE_SUB(NOW(), INTERVAL 1 MONTH)
GROUP BY 
    target_user.user_id, actor_user.user_id, logging.log_timestamp, logging.log_title, comment.comment_text, group_changed
ORDER BY 
    logging.log_timestamp DESC
LIMIT 200;
SQL

Checking query status...
