Untitled query #61907

SQL

SELECT
  log_id,
  log_id AS log_link_title,
  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_id AS log_id_title,
    actor_name,
    log_namespace,
    log_title,
    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
    AND ug_group = 'eliminator'
  WHERE
    log_type = 'protect'
    AND log_action = 'protect'
) AS block_logs
JOIN comment_logging
  ON comment_id = log_comment_id
WHERE
  duration_days > 14
  OR duration_infinity = 1
ORDER BY log_id DESC
SQL

Checking query status...
