select  [ImgID]
      ,[ImgTitle]
      ,[ImgDescription]
      ,[PublishDate]
      ,[UnpublishDate]
      ,[InternalNotes]
      ,[PrivateYesNo]
      ,[SortRank]
      ,[UploadDate]
      ,[FileSize]
      ,[FileWidth]
      ,[FileHeight]
      ,[FileSize_Disp]
      ,[FileWidth_Disp]
      ,[FileHeight_Disp]
      ,[FileSize_Thn]
      ,[FileWidth_Thn]
      ,[FileHeight_Thn]
      ,[FileSize_Mini]
      ,[FileWidth_Mini]
      ,[FileHeight_Mini]
      ,[FileExt]
      ,[KeyWords]
      ,[FullMemberAccess]
      ,[HighResCntID]
      ,[HRFileExt]
      ,[HRFileSize]
      ,[HRCmprsSize]
      ,[HRwidth]
      ,[HRheight]
      ,[HRnotes]
      ,[Orig_Mod]
      ,[Orig_Id]
	  ,c.ImgName doc_fileName
	  ,c.ImgExt doc_fileExt
	  ,c2.ImgName doc_hr_fileName
	  ,c2.ImgExt doc_hr_fileExt
from tbl_IMG_Images i
	inner join qry_ContentLookup c ON i.contentid = c.contentid
	left outer join qry_ContentLookup c2 ON i.HighResCntID = c2.contentid
where ownerid = 54
and fsl_tableCode = 'MFR'


	SELECT  d.imgid, d.imgtitle, cats.attrDescription
	FROM    tbl_ORG_AttributeLinks link
		INNER JOIN tbl_ORG_Attributes cats ON (link.child_attrID = cats.attrID)
		INNER JOIN tbl_Img_Images d ON (link.mstr_attrID = d.imgid)
	WHERE	link.mstr_attrTypeID = 33
	AND		link.child_attrTypeID = 32
	AND		cats.attrTypeID = 32
	AND		cats.OwnerID = 54
	AND		cats.FSL_TableCode = 'MFR'
	Order by  d.imgid, d.imgtitle, cats.attrDescription

		SELECT	d.imgid, d.imgtitle, c.filterlabel AS Category, fv.attrDescription as CategoryDescription
	FROM	tbl_Img_Images d, tbl_ORG_AttributeLinks k, tbl_ORG_AttributeLinks k2,
			tbl_CMM_Filters c, tbl_ORG_Attributes fv
	WHERE	d.imgid = k.child_attrID
	AND		k.child_attrTypeID = 33
	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.imgid, d.imgtitle, c.filterlabel, fv.attrDescription