Test Queries - Quarry

SQL

        SELECT
        	recentchanges_userindex.rc_title,
            recentchanges_userindex.rc_actor,
            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 recentchanges_userindex.rc_type IN (0,1)
            AND recentchanges_userindex.rc_bot = 0
      		# Limit to root pages only
      		AND NOT recentchanges_userindex.rc_title LIKE '%/%'
      		# Filter Wikipedia Adventure
      		AND recentchanges_userindex.rc_namespace = 2
#      		AND NOT recentchanges_userindex.rc_title LIKE '%TWA/Earth%'
      		# Filter "recently" blocked
      		AND actor.actor_name NOT IN (SELECT recentchanges.rc_title
                                         FROM recentchanges
                                         WHERE recentchanges.rc_type = 3
                                         AND recentchanges.rc_log_action = 'block')
       LIMIT 500;
SQL

Checking query status...
