Test Queries - Quarry

SQL

        SELECT
            recentchanges_userindex.*,
            actor.actor_name,
      		ABS(recentchanges_userindex.rc_new_len - recentchanges_userindex.rc_old_len) AS abs_diff_size,
            CASE
                WHEN recentchanges_userindex.rc_namespace IN (2,3) THEN 1
                ELSE 0
            END AS in_userspace,
      		CASE
      			WHEN recentchanges_userindex.rc_title LIKE '%/sandbox%' THEN 1
      			ELSE 0
      		END AS in_sandbox
        FROM recentchanges_userindex
            JOIN actor ON recentchanges_userindex.rc_actor = actor.actor_id
      		JOIN comment ON comment.comment_id = recentchanges_userindex.rc_comment_id
        WHERE actor.actor_name LIKE 'Nikthymakis'
        LIMIT 100
SQL

Checking query status...
