- 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