SELECT doc.docTitle, path.docPath, doc.docId
FROM tbl_DOC_Documents doc
, qryDocFullPathLookup path
WHERE doc.OwnerID =
AND doc.FSL_TableCode =
AND doc.ContentID = path.ContentID
AND getdate() <= doc.UnPublishDate
AND getdate() >= doc.PublishDate
AND doc.DocId IN ( )