select distinct docs.DocID as aid, docs.DocTitle as title, docs.UploadDate, docs.PublishDate, docs.UnpublishDate, docs.LastUpdatedDate, docs.LastUpdatedBy, docs.FileSize, docs.FileExt, docs.SortRank, docs.UnpublishToDo, dfp.DocPath, docs.DocDescription as aDescription, docs.PrivateYesNo, docs.categoryID, docs.repCategoryId, c.ImgPath, c.ImgName, c.ImgExt from tbl_DOC_Documents docs inner join qryDocFullPathLookup dfp on dfp.contentID = docs.contentID inner join qry_ContentLookup c on c.contentid = docs.contentid where docs.DocID = SELECT link.child_attrID FROM tbl_ORG_AttributeLinks link with (nolock) inner join tbl_DOC_Documents docs with (nolock) on docs.DocID = link.mstr_attrID WHERE link.child_attrTypeID = AND link.mstr_attrTypeID = AND docs.DocID = AND docs.OwnerID = AND docs.FSL_TableCode = ORDER by docs.docId