Test Queries - Quarry

SQL

        SELECT
            recentchanges_userindex.*,
            actor.actor_name
            CASE
            	'Mrbeastmodealldaysandbox' in (SELECT recentchanges.rc_title
                                               FROM recentchanges
                                               WHERE recentchanges_userindex.rc_type = 3
                                                 AND recentchanges_userindex.rc_log_action = 'block') THEN 1
                ELSE 0
            END AS condition_test
        FROM recentchanges_userindex
            JOIN actor ON recentchanges_userindex.rc_actor = actor.actor_id
        WHERE recentchanges_userindex.rc_type = 3
        	AND recentchanges_userindex.rc_log_action = 'block'
            AND recentchanges_userindex.rc_title LIKE 'Mrbeastmodealldaysandbox'
        LIMIT 100;
SQL

Checking query status...
