Hi, this is follow up my previous question from Copy-Paste Locked Badge Query (SQL) For More Than Champion or Invitation
So, I want to give a badge to a member who has successful invited 25 people.
Just like the existing badge, the Campaigner (3 people) or Champion (5 people).
The reward is only a badge without raising the Trust Level.
The concept is similar with the SQL Badge Query in “A badge for 10 accepted answers” Discourse Solved (Accepted answer plugin) Only need changes the number.
I have see this "Promoter" Badge broken? and this discourse/badge_queries.rb at master · discourse/discourse · GitHub , but still afraid and confuse to found the correct sql.
Maybe someone can help me.
Thank you very much.