Encontrar usuários que leram tópicos específicos

Comunidade Dados e relatórios
4

For Topic Participants you could use something like this

-- [params]
-- null string_list :topic_id
WITH user_data AS (
  SELECT u.username, ue.email, tu.topic_id FROM users u
    LEFT JOIN topic_users tu ON u.id = tu.user_id AND tu.posted = true
    LEFT JOIN user_emails ue on u.id = ue.user_id
)
SELECT * FROM user_data WHERE topic_id = :topic_id

You would then just need to enter the relevant topic id in the box that is required.