How to check the uniqueness of users in "hot link" badge?

zogstrip · July 5, 2018, 10:35am

Here’s the query for the Hot Link badge

lib/badge_queries.rb

5f64fd0a2


      
            SELECT tl.user_id, post_id, current_timestamp granted_at
              FROM topic_links tl
              JOIN posts p  ON p.id = post_id    AND p.deleted_at IS NULL
              JOIN topics t ON t.id = p.topic_id AND t.deleted_at IS NULL AND t.archetype <> 'private_message'
             WHERE NOT tl.internal
               AND tl.clicks >= #{count}
          GROUP BY tl.user_id, tl.post_id

Topic		Replies	Views
Count at "Others with this badge" includes current user UX	3	844	July 2, 2018
Has anything changed on what qualifies for the "Nice share" badge? Bug badges	36	1381	December 22, 2025
Badge based on link stats? Data & reporting sql-query	5	1349	August 27, 2015
Grant Badge when user visits link Data & reporting sql-triggered-badge	26	1714	August 30, 2023
Custom badge query is not targeting posts Product Support	1	819	January 2, 2019

How to check the uniqueness of users in "hot link" badge?

Related topics