select doc.DocTitle title, doc.FileSize, doc.FileExt, docURL.DocPath, doc.DocDescription description, thumbURL.DocPath as thumbPath, #_ownerId# as assetOwnerId, '#_ownerType#' as assetOwnerType, #url.docid# as assetItemId, doc.ContentID as assetContentId, 'tbl_doc_documents' as assetTableName from tbl_doc_documents doc inner join qryDocFullPathLookup docURL on doc.ContentID = docURL.ContentID left outer join qryDocFullPathLookup thumbURL on doc.thumbNailId = thumbURL.contentId and doc.thumbNailId <> 755 where doc.ownerid = and doc.fsl_tablecode = and doc.docid = select img.imgTitle title, img.FileSize, img.FileExt, docURL.ContentPath DocPath, ImgDescription description, '' as thumbPath, #_ownerId# as assetOwnerId, '#_ownerType#' as assetOwnerType, #url.docid# as assetItemId, img.ContentID as assetContentId, 'tbl_img_images' as assetTableName from tbl_img_images img inner join qryContentFullPathLookup docURL on img.ContentID = docURL.ContentID where img.ownerid = and img.fsl_tablecode = and img.imgid = select rep.docTitle title, rep.FileSize, rep.FileExt, docURL.ContentPath DocPath, rep.DocDescription description, '' as thumbPath, #_ownerId# as assetOwnerId, '#_ownerType#' as assetOwnerType, #url.docid# as assetItemId, rep.ContentID as assetContentId, 'tbl_#_containerType#_repository' as assetTableName from tbl_#_containerType#_repository rep inner join qryContentFullPathLookup docURL on rep.ContentID = docURL.ContentID where rep.ownerid = and rep.ownertype = and rep.fileid = select doc.DocTitle title, doc.FileSize, doc.FileExt, docURL.DocPath, doc.DocDescription description, '' as thumbPath, #_ownerId# as assetOwnerId, '#_ownerType#' as assetOwnerType, #url.docid# as assetItemId, doc.ContentID as assetContentId, 'tbl_doc_documents' as assetTableName from tbl_doc_documents doc inner join qryDocFullPathLookup docURL on doc.ContentID = docURL.ContentID where doc.ownerid = and doc.fsl_tablecode = and doc.docid = select img.imgTitle title, img.FileSize, img.FileExt, docURL.ContentPath DocPath, ImgDescription description, '' as thumbPath, #_ownerId# as assetOwnerId, '#_ownerType#' as assetOwnerType, #url.docid# as assetItemId, img.ContentID as assetContentId, 'tbl_img_images' as assetTableName from tbl_img_images img inner join qryContentFullPathLookup docURL on img.ContentID = docURL.ContentID where img.ownerid = and img.fsl_tablecode = and img.imgid = select rep.docTitle title, rep.FileSize, rep.FileExt, docURL.ContentPath DocPath, rep.DocDescription description, '' as thumbPath, #_ownerId# as assetOwnerId, '#_ownerType#' as assetOwnerType, #url.docid# as assetItemId, rep.ContentID as assetContentId, 'tbl_#_containerType#_repository' as assetTableName from tbl_#_containerType#_repository rep inner join qryContentFullPathLookup docURL on rep.ContentID = docURL.ContentID where rep.ownerid = and rep.ownertype = and rep.fileid =

#qryFileInfo.title#

#qryFileInfo.fileext# File size: #_filesize#

#htmleditformat(qryFileInfo.description)#

	favorite/unfavorite
	favorite/unfavorite
	open file
	email file
	add/remove from cart