select updateTimeStamp, updateUserId, updatorFirstName, updatorLastName from qmd_focusProductStatus where productStatusId > 0 order by updateTimeStamp desc

Purchasing Profile
Category / SubCategory	Purchasing Status	Avg. Vol. (Monthly)Annual Volume		Current Supplier
#mktCategory#
#mktSubCategory#	Unknown Buying from us Competitor No Application Unknown	#volumeQty#	#qmd_unitOfMeasure.unitOfMeasurePlural#	Unknown Competitor Other Scratch Unknown select companyName from qmd_competitors where competitorId = #val(sourceCompetitorId)# #getCompetitorName.companyName# #ClientName#
Last Updated: #LSDateFormat( qmd_focusProductLastUpdate.updateTimeStamp )# at #LSTimeFormat( qmd_focusProductLastUpdate.updateTimeStamp )# by #qmd_focusProductLastUpdate.updatorFirstName# #qmd_focusProductLastUpdate.updatorLastName#