"‎Fixed temporal range"

Fork of In use creations (fr) by MarioGom

This query is marked as a draft This query has been published by GeneralNotability.

SQL

SET
  STATEMENT max_statement_time = 120 FOR
SELECT
  DISTINCT actor_name,
  comment_text
FROM
  revision_userindex AS revision
  INNER JOIN actor_revision AS actor ON revision.rev_actor = actor.actor_id
  INNER JOIN comment_revision AS comment ON revision.rev_comment_id = comment.comment_id
  INNER JOIN user ON actor.actor_user = user.user_id
WHERE
  rev_timestamp >= '20220101000000'
  AND user_registration >= '20220101000000'
  AND actor_user IS NOT NULL
  AND comment_text LIKE 'Fixed temporal range %'
ORDER BY
  rev_id DESC

SQL

Checking query status...