select [DocID]
      ,[CategoryID]
      ,[DocTitle]
      ,[DocDescription]
      ,[PublishDate]
      ,[UnpublishDate]
      ,[PrivateYesNo]
      ,[SortRank]
      ,[UploadDate]
      ,[FileSize]
      ,[FileExt]
      ,[KeyWords]
      ,[PswrdProtect]
      ,[DocPassword]
      ,[FullMemberAccess]
      ,[InternalNotes]
	  ,[ImgName] doc_fileName
	  ,[ImgExt] doc_fileExt
from tbl_DOC_Documents d
	inner join qry_ContentLookup c ON d.contentid = c.contentid
where ownerid = 54
and fsl_tableCode = 'MFR'


select top 100 *
from qry_ContentLookup


	SELECT  d.docid, d.doctitle, cats.attrDescription
	FROM    tbl_ORG_AttributeLinks link
		INNER JOIN tbl_ORG_Attributes cats ON (link.child_attrID = cats.attrID)
		INNER JOIN tbl_DOC_Documents d ON (link.mstr_attrID = d.docid)
	WHERE	link.mstr_attrTypeID = 30
	AND		link.child_attrTypeID = 31
	AND		cats.attrTypeID = 31
	AND		cats.OwnerID = 54
	AND		cats.FSL_TableCode = 'MFR'
	Order by  d.docid, d.doctitle, cats.attrDescription

		SELECT	d.docid, d.doctitle, c.filterlabel AS Category, fv.attrDescription as CategoryDescription
	FROM	tbl_DOC_Documents d, tbl_ORG_AttributeLinks k, tbl_ORG_AttributeLinks k2,
			tbl_CMM_Filters c, tbl_ORG_Attributes fv
	WHERE	d.DocID = k.child_attrID
	AND		k.child_attrTypeID = 30
	AND		k.mstr_attrTypeID = 29
	AND		k.mstr_attrID = fv.attrID
	AND		k.mstr_attrID = k2.child_attrID
	AND		k2.child_attrTypeID = 29
	AND		k2.mstr_attrTypeID = 28
	AND		k2.mstr_attrID = c.filterid
	AND		c.OwnerID = 54
	AND		c.FSL_TableCode = 'MFR'
	ORDER	BY d.docid, d.doctitle, c.filterlabel, fv.attrDescription