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.