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
 WHERE comment_id IN (SELECT rev_comment_id FROM selected_revisions)
SQL

Checking query status...
