Need database help

[MagicalMidge]

Please dont immediately delete this post, I understand this isnt the support section but at the moment I cannot access it as I am required to link the customer number ect, I dont have access to that information and this is quite urgent.

I am currently working on my companies vBulletin forum and I just need a little advice on the database structure and how to pull a certain bit of information...

I do not have access to the customer number or anything like that which is why I am posting here. I had originally sent support an email, however that was a week ago and i still havent heard anything.

Here is my email, any help is massively appreciated:

"I require assistance on how I can pull the user group/s that a particular user is attached to, or better still list all users in a particular user group... I need to do this through the database as I am trying to populate another database using the information and we have over 100,000 users so doing it by hand isnt going to be fun.

Now that the client I am using should make any difference, but I am using MySQL Workbench.

I would really appreciate any help you can offer on this matter."

Regards,
Matt

[Mark.B]

This query will return a simple list of users that exist in a usergroup:

SELECT username FROM user WHERE usergroupid = xx

Replace 'xx' with the relevant usergroupid, these can be found in the usergroup manager section of the admincp.

[Mark.B]

The original question has been answered. This was done as a goodwill gesture to help someone out. We don't normally provide any support for unlicensed users.