SELECT
  Attachment.ID AS AttachmentId
  , Attachment.name AS name
  , Attachment.ObjID AS ObjID
  , Attachment.TYPE AS TYPE
  , MAX(dbo.ToMS(History.DATE)) AS DATE
  , History.creator AS creator
FROM
  T_ATTACHMENT AS Attachment
  LEFT OUTER JOIN T_HISTORY AS History ON History.ObjID = Attachment.ObjID
WHERE
  Attachment.ObjID = #{entityId}
  AND History.info LIKE ('%added file ' + Attachment.name + '%')
GROUP BY
  Attachment.name
  , Attachment.ID
  , Attachment.ObjID
  , Attachment.TYPE
  , History.creator