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

mikechristopher · July 5, 2018, 12:43pm

lib/badge_queries.rb

5f64fd0a2


      
          SELECT views.user_id, i2.post_id, current_timestamp granted_at
          FROM
          (
            SELECT i.user_id, MIN(i.id) i_id
            FROM incoming_links i
            JOIN badge_posts p on p.id = i.post_id
            WHERE i.user_id IS NOT NULL
            GROUP BY i.user_id,i.post_id
            HAVING COUNT(*) > #{count}
          ) as views
          JOIN incoming_links i2 ON i2.id = views.i_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	1632	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