SELECT R.reasonName, R.email, R.sortRank, R.ReasonId FROM tbl_STP_ContactUsReasons R with (nolock) WHERE R.OwnerId = AND R.ownerType = AND R.reasonId = SELECT name from tbl_TER_Territories with (nolock) WHERE fsl_tablecode = and ownerID = and territoryId = ---> ">

Contact Us Message
From:
Name	#client.user# <#client.email#>
Company	#htmleditformat(variables.CompanyName)#
Primary Local Market	#htmleditformat(variables.primaryLocalMarket)#N/A
Email	#htmleditformat(client.Email)#
Detail:
Reason	#htmleditformat(_reason)#
Message	#htmleditformat(form.message)#