Mysterious entries in topic_users table

Contribute Bug
21

I was thinking something like

DELETE FROM topic_users
      USING topic_users tu
  LEFT JOIN users u ON u.id = tu.user_id
      WHERE u.id IS NULL
        AND topic_users.id = tu.id

EDIT: it’s pushed now :wink:

https://github.com/discourse/discourse/commit/aebb15337b2ecfa8611b7dd7616eb3528dc75e3c

5 Likes