[#2053] `Notification.for_user_query/2` timeout fix

Closes #2053 (closed) & #2437 (closed).

Changed Notification.for_user_query/2 to use join to filter out inactive actors instead of subselect of all inactive AP ids from users.

Per #2437 (comment 82554), this implementation is significantly faster than previous one.