Test Queries - Quarry

SQL

        SELECT
            recentchanges_userindex.*,
            actor.actor_name,
            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
        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 '%/%'
        LIMIT 100;
SQL

Checking query status...
