users in a security group
select u.Username from security_users u left join security_profiles_users p ON u.UserID = p.UserID where ProfileCode like '%production manager%' select Username, Location from security_users u where u.IDCard='123455326'