select * from techinfo left join techcategories on techinfo.techcategoryid = techcategories.techcategoryid where file = file and techinfo.techcategoryid = '#techcategoryid#' and (title like '%#keyword#%') order by techinfo.techcategoryid, techinfo.title We found #getti.recordcount# results to your search.

	File Name	Type of File	Size (KB)
	#title#	#techcategory#	#size#