I can’t help you with the query, but suggest you ask the Discourse AI bot for help - select the bot icon in the top
→ GPT-4 → SQL Helper.
I’ve found it very good in creating data explorer queries from just telling it what I need and guess it can help with badge queries.