Howto find registered users in groups in eZ p. with sql?

Monday 11 July 2005 5:52:53 am

I have some questions about listing registered users in mysql. What is the sql-syntax?

I have problems with finding these users through the admin interface. We have 30 different user groups, and when I'm going to search for a user, I don't know where these users are located.

The admin-interface don't have the option to search for users like many other CMS either, which makes the administration difficult to manage.

So I need to have a sql-query which lists all users in a spesific role.

Anyone who knows?