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 (:post_ids) )) GROUP BY p.user_id Note this is not mine. Here is the OP.

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) )) GROUP BY p.user_id It doesn’t work sadly, works on the preview, but when i save it says “Sorry, an error has occurred.”

שאלה על תג צפיות בנושא

קהילה נתונים ודיווח

codergautam (gautam) 26 במאי,‏ 2022,‏ 5:36pm 4

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

נושא		תגובות	צפיות
Total views across multiple topics Data & reporting sql-triggered-badge	2	260	5 במאי,‏ 2021
Some common badge queries Data & reporting sql-triggered-badge	0	9166	7 באוגוסט,‏ 2015
Badge ideas for Topic Voting Feature badges , topic-voting , sql-triggered-badge	0	1912	24 ביוני,‏ 2016
Badge for popular topic Data & reporting sql-triggered-badge	5	490	1 ביוני,‏ 2024
Badges for posting Data & reporting sql-triggered-badge	4	600	27 באוגוסט,‏ 2024

שאלה על תג צפיות בנושא

נושאים קשורים