select fsp.ownerid, fsp.fsl_tablecode, fsp.fspro_userid, fsp.firstname, fsp.lastname, fsp.fspro_password from tbl_fspro_members fsp where fsp.email = and ( fsp.fsl_tablecode = 'bro' or fsp.fsl_tablecode = 'mfr' ) and fsp.fspro_password = and nullif(FSPro_Password,'') is not null and fsp.staffmember = 1 and loginenabled = 1 and ownerid > 0