SQL query help. Number of users using a style?

[philmckrackon]

I have several styles on the forum. What would be the best way to determine the user count of each?

Ideas?

 

[Jeremy P]

SELECT style_id, COUNT(*) AS users
FROM xf_user
GROUP BY style_id

 

[philmckrackon]

Thanks, worked perfectly.

 

[AndyB]

You might like this add-on:

https://xenforo.com/community/resources/style-info.6399/