Two SQL queries for badges

[quimgil]

What would you like done?

These two queries for badges:

Some common badge queries idea

I’m trying to create a badge for users that have posted or commented in at least one topic in a category or any of its subcategories. If it would be 2 categories I guess the OR condition could be used, but with three or more I’m lost. For this query the notion of “subcategory” could be irrelevant, and the category IDs could be listed as in an array, or something equivalent. Any ideas about how to do this?

Question Answer Plugin

Has anyone tried to create an SQL query to grant a badge to anyone who has submitted at least one answer that received at least one upvote on a specific category? Examples of queries with more answers and/or more upvotes would be very useful to create silver and gold types of badges around this great plugin.

When do you need it done?

No rush, but it would be great to distribute these badges by the end of this month.

What is your budget, in $ USD that you can offer for this task?

Happy to pay a reasonable rate to someone delivering the queries that Just Work.

[Ahmed_Gagan]

I am interested to take this up, sending you a PM