select operatorID , ter.territoryId, ter.name territoryName, companyName, mfr_bsr_id, c.OwnerID cOwnerId, c.fsl_tablecode cfsl_tablecode, c.email cemail, c.firstName cFirstName, c.lastName cLastName, opr.customfld_1, p.OwnerID, p.fsl_tablecode, p.firstName, p.lastName, p.email from tbl_OPR_ClientOperators opr left outer join tbl_TER_Territories ter on ter.territoryId = opr.territoryId left outer join tbl_FSPro_Members c on c.FSPro_UserID = opr.mfr_bsr_id left outer join tbl_FSPro_Members p on p.FSPro_UserID = CONVERT( int, opr.customFld_1 ) where opr.OwnerID = 2004 and opr.FSLTableCode = 'mfr' and nullif( nullif( opr.CustomFld_1, 0 ), '' ) is not null and mfr_BSR_id <> opr.CustomFld_1 order by operatorId select * from qmd_operatorAssignmentChanges where not operatorId in ( )

Sending Alert

#qmd_filter.recordCount# Changes
				From						To
Territory		Operator		OwnerId	OwnerType	UserId	FirstName	LastName	Email	OwnerId	OwnerType	UserId	FirstName	LastName	Email
#htmleditformat( territoryName )#	#territoryId#	#htmleditformat( companyName )#	#operatorId#	#OwnerId#&##160;	#fsl_tablecode#&##160;	#customfld_1#&##160;	#htmleditformat( firstName )#&##160;	#htmleditformat( lastName )#&##160;	#htmleditformat( Email )#&##160;	#cOwnerId#&##160;	#cfsl_tablecode#&##160;	#mfr_bsr_id#&##160;	#htmleditformat( cFirstName )#&##160;	#htmleditformat( cLastName )#&##160;	#htmleditformat( cEmail )#&##160;

#reportHTML#

#now()#

#reportHTML#