Test Queries - Quarry

SQL

        SELECT
        	recentchanges_userindex.rc_namespace,
      		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 '%/%' THEN 1
      			ELSE 0
      		END AS in_subpage,
      		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
      		# Filter Wikipedia Adventure
      		AND NOT (recentchanges_userindex.rc_namespace = 2 AND comment.comment_text LIKE '%automatically%')
#      		AND NOT recentchanges_userindex.rc_title LIKE '%TWA/Earth%'
      		# Filter "recently" blocked
      		AND actor.actor_name LIKE 'DeAna Fai'
            LIMIT 100
SQL

Checking query status...
