SELECT up_user
        FROM user_properties
        JOIN user ON user_id=up_user
        WHERE
            -- Is mentor property
            up_property="growthexperiments-mentor-id" AND
            -- Is relevant to the mentor in question
            up_value=(SELECT user_id FROM user WHERE user_name="{mentor}") AND
            
            -- User is not a bot
            up_user NOT IN (
                SELECT ug_user
                FROM user_groups
                WHERE ug_group="bot"
            ) AND
            
            -- User is not indefinitely blocked
            up_user NOT IN(
                SELECT ipb_user
                FROM ipblocks
                WHERE
                    -- Is an indefinite block
                    ipb_expiry="infinity" AND
                    -- Blocks an user
                    ipb_user!=0
            ) AND
            
            -- User either registered less than 2 weeks ago, or made an edit
            (
                user_editcount > 0 OR
                -- User tenure is less than 2*168 hours (=two weeks)
                (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(user_registration)) < 3600*168*2
            )
            
            -- TODO: User's last edit was made less than 6 months ago