select territoryid from tbl_opr_clientoperators where ownerid = and fsltablecode = and operatorid = select cdr_territoryid as territoryid from tbl_cdr_distributors where ownerid = and fsl_tablecode = and cdr_recordid = select territoryid from tbl_ter_teammembers with (nolock) where teammemberuserid = and ownerid = and ownertype = and ( teammemberrole = 'PrimaryManager' or teammemberrole = 'SecondaryManager' or teammemberrole = 'TeamManager' )

#_shareText#