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	824	July 2, 2018
Has anything changed on what qualifies for the "Nice share" badge? Bug badges	36	1330	December 22, 2025
Badge based on link stats? Data & reporting sql-query	5	1333	August 27, 2015
Grant Badge when user visits link Data & reporting sql-triggered-badge	26	1634	August 30, 2023
Custom badge query is not targeting posts Product Support	1	801	January 2, 2019

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

Related topics