zhwiki: check-sign

SQL

SELECT rc_actor, actor_name, actor_user,
            up_value AS `nickname`
        FROM (
            SELECT rc_actor, actor_name, actor_user,
                up_value AS `fancysig`
            FROM (
                SELECT rc_actor, actor_name, actor_user
                FROM (
                    SELECT DISTINCT rc_actor
                    FROM recentchanges
                    WHERE (rc_namespace = 4 OR rc_namespace % 2 = 1)
                        AND rc_timestamp > '20220623000000'
                    ORDER BY rc_timestamp DESC
                ) temp1
                LEFT JOIN actor ON rc_actor = actor_id
                WHERE actor_user IS NOT NULL
            ) temp2
            LEFT JOIN user_properties  ON actor_user = up_user AND up_property = 'fancysig'
            WHERE up_value IS NOT NULL
        ) temp3
        LEFT JOIN user_properties ON actor_user = up_user AND up_property = 'nickname'
        WHERE up_value IS NOT NULL AND up_value != ''
SQL

Checking query status...
