Is there a badge query that gives the badge if any one of a users topic has over 1,000 views?

I found this badge query. SELECT p.user_id, min(p.created_at) granted_at, MIN(p.id) post_id FROM badge_posts p JOIN topics t ON t.id = p.topic_id WHERE category_id = ( SELECT id FROM categories WHERE name ilike 'Technology' ) AND p.post_number = 1 AND views >= 10 and (:backfill OR ( p.id IN (:pos…

How To Program: SELECT p.user_id, min(p.created_at) granted_at, MIN(p.id) post_id FROM badge_posts p JOIN topics t ON t.id = p.topic_id WHERE category_id = ( SELECT id FROM categories WHERE name ilike 'Technology' ) AND p.post_number = 1 AND views >= 10 and (:backfill OR ( p.id IN (:post_ids)…

Wait nvm, it works, i had a nother badge wih the same name

토픽 조회 배지 쿼리

커뮤니티 구축 데이터 및 보고

codergautam (gautam) 5월 26, 2022, 5:36오후 4

잠깐, 그냥 잘 되네. 같은 이름의 다른 배지가 있었어.

글		댓글	조회수
Total views across multiple topics Data & reporting sql-triggered-badge	2	244	5월 5, 2021
Some common badge queries Data & reporting sql-triggered-badge	0	9002	8월 7, 2015
Badge ideas for Topic Voting Feature badges , topic-voting , sql-triggered-badge	0	1902	6월 24, 2016
Badge for popular topic Data & reporting sql-triggered-badge	5	414	6월 1, 2024
Badges for posting Data & reporting sql-triggered-badge	4	538	8월 27, 2024

토픽 조회 배지 쿼리

Related topics