SELECT Distinct(CompanyType) FROM Tenants WHERE CompanyType != '' ORDER BY CompanyType SELECT * FROM Tenants WHERE CompanyType = '#URL.TYPE#'

	#CompanyType#
	#Tenant#