Revert "DEV: Remove an unnecessary join in `TopicTrackingState.report`." (PR #14054)

This reverts commit 06ee0e5a51e90d98efffd446c8f088cf74663188.

This clause is still used by new_filter_sql

GitHub