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) 2022 年5 月 26 日 17:36 4

等等，不用了，它能用了，我有一个同名的徽章

话题		回复	浏览量
Total views across multiple topics Data & reporting sql-triggered-badge	2	244	2021 年5 月 5 日
Some common badge queries Data & reporting sql-triggered-badge	0	9009	2015 年8 月 7 日
Badge ideas for Topic Voting Feature badges , topic-voting , sql-triggered-badge	0	1902	2016 年6 月 24 日
Badge for popular topic Data & reporting sql-triggered-badge	5	417	2024 年6 月 1 日
Badges for posting Data & reporting sql-triggered-badge	4	539	2024 年8 月 27 日

主题浏览量徽章查询

相关话题