Finder 1 - Quarry

SQL

SET STATEMENT max_statement_time = 30 FOR
WITH ref_user (ref_user_name) AS (
    SELECT
      @sock_master := 'Yoodaba'
  ),
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
  INNER JOIN comment_revision AS comment ON revision.rev_comment_id = comment.comment_id
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
-- GROUP BY actor_id
SQL

Checking query status...
