Untitled query #61906

SQL

SELECT
  log_id,
  log_id,
  actor_name,
  CONCAT('{{ns:' , log_namespace, '}}:', log_title) AS link,
  comment_text,
  STR_TO_DATE(LEFT(log_timestamp, 8), '%Y%m%d'),
  'محافظت طولانی' AS issue
FROM (
  SELECT
    log_id,
    log_actor,
    actor_name,
    log_title,
    log_namespace,
    log_timestamp,
    log_comment_id,
    DATEDIFF(
      DATE(
        concat(
          SUBSTRING(log_params, locate('s:6:"expiry";', log_params) + 19, 4),
          SUBSTRING(log_params, locate('s:6:"expiry";', log_params) + 23, 2),
          SUBSTRING(log_params, locate('s:6:"expiry";', log_params) + 25, 2)
        )
      ),
      DATE(SUBSTRING(log_timestamp, 1, 8))
    ) AS duration_days,
    CASE
      WHEN log_params LIKE '%s:6:"expiry";s:8:"infinity"%'
      THEN 1
      ELSE 0
    END AS duration_infinity
  FROM logging_userindex
  JOIN actor
    ON log_actor = actor_id
  JOIN user_groups
    ON actor_user = ug_user
  WHERE
    log_type = 'protect'
    AND log_action = 'protect'
    AND ug_group = 'eliminator'
    AND log_timestamp >=
      DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 30 DAY), '%Y%m%d000000')
) AS block_logs
JOIN comment
  ON log_comment_id = comment_id
WHERE
  duration_days > 14
  OR duration_infinity = 1
ORDER BY log_id DESC
SQL

Checking query status...
