Untitled query #59647

SQL

SELECT user_name, up_value
FROM
	user_properties
    JOIN `user` ON user_id = up_user
WHERE
	RIGHT(up_user, 2) = 00 AND
    up_property = "nickname" AND
    user_name IN (
        SELECT actor_name
        FROM revision_userindex
        JOIN actor_revision ON rev_actor = actor_id
        JOIN page ON rev_page = page_id
        WHERE 
          rev_timestamp > 20201101000000
          AND (
            page_namespace = 4
            OR (page_namespace % 2) = 1
          )
    ) AND
    up_user IN (SELECT up_user
        FROM user_properties
        WHERE up_property = "fancysig" AND up_value = 1) AND
    up_value != user_name
ORDER BY up_user ASC
SQL

Checking query status...
