SELECT Revisions.dID, dDocTitle, dDocType, dRevisionID, dSecurityGroup, dDocAuthor, dDocAccount, dRevLabel, dFormat, dOriginalName, dExtension, dWebExtension,
dInDate, dOutDate, dCreateDate, dPublishType, dRendition1, dRendition2, dFileSize AS VaultFileSize, DocMeta.*, RevClasses.*
FROM Revisions, DocMeta, Documents, RevClasses
WHERE Revisions.dID=DocMeta.dID And Revisions.dID=Documents.dID And Revisions.dDocName = RevClasses.dDocName And dIsPrimary = 1 And
dReleaseState IN (N'Y', N'U', N'I') AND ((dInDate >= {ts '2015-04-01 00:00:00.000'} AND dInDate < {ts '2015-05-28 00:00:00.000'})) ORDER BY dInDate Desc