XF 1.4 Total Members in a certain usergroup

[Davey-UK]

Can anyone point me in the right direction please. I am trying to display the total number of users in an upograded usergroup, and possibly the last few members to join that group to be listed maybe in a widget in the sidebar. Just cannot work out the query to find the total.
Thanks
Maybe in the wrong section.

 

[Paul B]

The data is not exposed on the front end.

It requires an SQL query to fetch it.

 

[Davey-UK]

Thanks. Thats what i was asking. I just cannot work out the query. Still looking.