Untitled query #60253

SQL

-- Scalar subquery to get the account ID of SchlurcherBot. THus, we
-- avoid having to use a JOIN statement afterwards between the tables
-- "revision" and "actor"
WITH
choosen_actor_id AS (
  SELECT actor_id FROM actor WHERE actor_name = 'SchlurcherBot'
),
-- Get the revisions made by that account
selected_revisions AS (
  SELECT rev_id, rev_comment_id
    FROM revision
   WHERE rev_actor = (SELECT actor_id FROM choosen_actor_id)
)
SELECT DISTINCT comment_text
  FROM comment_revision JOIN selected_revisions
    ON rev_comment_id = comment_id
LIMIT 100
SQL

Checking query status...
