SELECT tm.id as id, t.uid as team_uid, t.id as team_id, u.uid as user_uid, u.id as user_id, u.name, u.email, u.login, tm.external, tm.created, tm.updated, tm.permission FROM {{ .Ident .TeamMemberTable }} tm INNER JOIN {{ .Ident .TeamTable }} t ON tm.team_id = t.id INNER JOIN {{ .Ident .UserTable }} u ON tm.user_id = u.id WHERE t.uid = {{ .Arg .Query.UID }} {{- if .Query.Pagination.Continue }} AND tm.id >= {{ .Arg .Query.Pagination.Continue }} {{- end }} AND tm.org_id = {{ .Arg .Query.OrgID }} ORDER BY t.id ASC LIMIT {{ .Arg .Query.Pagination.Limit }};