Fork of In use creations (fr) by MarioGom
This query is marked as a draft This query has been published by GeneralNotability.

SQL

AخA
 
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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...