select opr.operatorId from tbl_OPR_ClientOperators opr with (nolock) where opr.ownerId = and opr.fsltablecode = --and opr.crmActive = 'Y' --and opr.territoryId in ( ) and opr.mfr_bsr_id = select cdr_recordid from tbl_cdr_distributors with (nolock) where ownerId = and fsl_tablecode = and crmActive = 'Y' and cdr_territoryId in ( ) and cdr_dstcompanytype <> 'O' -- direct ship other --and mfr_bsr_id = ---> select top #_maxItems# fspro_userid, email, firstname, lastname order by fsp.lastname select * from qryResults union select * from qcf_dispMFRBrokerStaff order by lastname #_email#'),de(''))#"},'> #_data#