List users by team and profiles

 This SQL report can be use as is from the SQL report module

SELECT table_user_0.user_id,

table_user_0.user_name, table_user_0.folder_id, table_user_0.user_local, table_user_0.user_email,  table_user_0.user_enabled,  table_user_0.country_id, table_usergroup_0.usergroup_id, table_usergroup_0.usergroup_name, table_userprofile_0.userprofile_name

FROM

xstudio_db.table_user table_user_0,

xstudio_db.table_usergroup table_usergroup_0,

xstudio_db.table_usergroup_user table_usergroup_user_0,

xstudio_db.table_userprofile table_userprofile_0

WHERE

table_usergroup_user_0.user_id = table_user_0.user_id

AND table_usergroup_user_0.usergroup_id = table_usergroup_0.usergroup_id

AND table_userprofile_0.userprofile_id = table_user_0.userprofile_id