Finder 1 - Quarry

SQL

SET STATEMENT max_statement_time = 30 FOR
WITH ref_user (ref_user_name) AS (
    SELECT
      @sock_master := 'AnoushkaWatson'
  ),
ref_comment (ref_comment_id) AS (
SELECT DISTINCT
 rev_comment_id
FROM
  ref_user
  INNER JOIN actor_revision AS actor ON ref_user.ref_user_name = actor.actor_name
  INNER JOIN revision_userindex AS revision ON actor.actor_id = revision.rev_actor
WHERE
  rev_comment_id NOT IN (SELECT comment_id FROM comment_revision WHERE comment_text = '')
)
SELECT
COUNT(*)
-- , COUNT(DISTINCT rev_comment_id)
FROM ref_comment
INNER JOIN revision_userindex AS revision ON ref_comment.ref_comment_id = revision.rev_comment_id
INNER JOIN actor_revision AS actor ON revision.rev_actor = actor.actor_id
INNER JOIN user ON actor.actor_user = user.user_id
WHERE
  TRUE
  AND rev_timestamp >= '20220101000000'
  AND actor_user IS NOT NULL
  AND user_registration >= '20190101000000'
  AND user_id IS NOT NULL
-- GROUP BY actor_id
LIMIT 1
SQL

Checking query status...
