Cleanup DB state after #7171

[geropl]

Original issue: #7171

It seems we still have some users with a bad DB state. We should cleanup those duplicates.

Identify users by counting subscriptions per user, and display those with more than 10 should turn up the one in bad state.

select count(distinct userId) users
from (
     select
        userId,
        count(*) as subscriptions
     from src_db_prod.subscriptions
     group by 1
     having subscriptions >= 1000
         )

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[easyCZ]

@geropl This got auto-closed. Should we re-open?