$role_manager = ROLE_MANAGER;
$sql = "select t.name as team_name, u.id as manager_id, u.name as manager_name, u.login as manager_login, u.email as manager_email
from tt_teams t
- inner join tt_users u on (u.team_id = t.id and u.role = $role_manager)
+ inner join tt_users u on (u.team_id = t.id)
+ inner join tt_roles r on (r.id = u.role_id and r.rank = 512)
where t.id = $team_id";
$res = $mdb2->query($sql);