CREATE TABLE `archive` (
      `id` bigint(20) NOT NULL AUTO_INCREMENT,
      `version` bigint(20) NOT NULL,
      `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
      `employee_id` bigint(20) NOT NULL,
      `subcategory_id` bigint(20) NOT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `UK_pnk12l4936a21pst3p696mgt6` (`name`),
      KEY `fk_archive_employee` (`employee_id`),
      KEY `fk_archive_subcategory` (`subcategory_id`)
    )
       
    CREATE TABLE `archive_file` (
      `id` bigint(20) NOT NULL AUTO_INCREMENT,
      `version` bigint(20) NOT NULL,
      `created` datetime NOT NULL,
      `edition` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
      `expire` date NOT NULL,
      `history` text COLLATE utf8_unicode_ci NOT NULL,
      `mime_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
      `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
      `archive_id` bigint(20) NOT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `UK_lgh85dj5mtjkevbkmgl8q0rso` (`name`),
      KEY `fk_archive_file_archive` (`archive_id`)
    )

@Entity
@Table(name = "archive")
public class Archive extends AbstractEntity {

   @NotEmpty
   @Size(max = ConstantNumeric.TWO_HUNDRED)
   @Column(name = "name", length = ConstantNumeric.TWO_HUNDRED, unique = true)
   private String name;

   @NotEmpty
   @ManyToOne
   @JoinColumn(name = "subcategory_id")
   @ForeignKey(name = FK + "subcategory")
   private ArchiveCategory subcategory;

   @NotEmpty
   @OneToMany(mappedBy = "archive", cascade = { CascadeType.PERSIST, CascadeType.MERGE })
   private List<ArchiveFile> files;

   @NotEmpty
   @ManyToOne
   @JoinColumn(name = "employee_id")
   @ForeignKey(name = FK + "employee")
   private Employee responsible;

   @NotEmpty
   @AuditJoinTable(inverseJoinColumns = @JoinColumn(name = "department_id"))
   @ManyToMany
   @JoinTable(name = "archive_has_department", joinColumns = @JoinColumn(name = "archive_id"),
            inverseJoinColumns = @JoinColumn(name = "department_id"))
   @ForeignKey(name = FK + "has_department", inverseName = FK + "department")
   private List<Department> departments;

...Getters/Settters

@Entity
@Table(name = "archive_file")
public class ArchiveFile extends AbstractEntity {

   @NotEmpty
   @Size(max = ConstantNumeric.TWO_HUNDRED)
   @Column(name = "name", unique = true, length = ConstantNumeric.TWO_HUNDRED, updatable = false)
   private String name;

   @NotEmpty
   @Size(max = ConstantNumeric.FOUR)
   @Column(name = "edition", length = ConstantNumeric.FOUR, updatable = false)
   private String edition;

   @NotEmpty
   @Temporal(TemporalType.DATE)
   @Column(name = "expire", updatable = false)
   private Date expire;

   @NotEmpty
   @Temporal(TemporalType.TIMESTAMP)
   @Column(name = "created", updatable = false)
   private Date created;

   @NotEmpty
   @Column(columnDefinition = "text", updatable = false)
   private String history;

   @NotEmpty
   @ManyToOne(cascade = CascadeType.ALL, optional = false)
   @JoinColumn(name = "archive_id", referencedColumnName = "id")
   @ForeignKey(name = "fk_archive_file_archive")
   private Archive archive;

   @NotEmpty
   @Column(name = "mime_type", updatable = false)
   private String mimeType;

...Getters/Settters

    SELECT * FROM archive AS a
    INNER JOIN archive_file as af
    WHERE af.id IN(SELECT a.id FROM
    (SELECT * FROM archive_file AS af WHERE  af.created > '2012-05-30'
    ORDER BY af.created DESC) AS a GROUP BY a.archive_id) AND a.id = af.archive_id 

    +----+---------+--------------------------+-------------+----------------+----+---------+---------------------+---------+------------+-----------------------+--------------+-----------------+------------+
    | id | version | name                     | employee_id | subcategory_id | id | version | created             | edition | expire     | history               | mime_type    | name            | archive_id |
    +----+---------+--------------------------+-------------+----------------+----+---------+---------------------+---------+------------+-----------------------+--------------+-----------------+------------+
    |  1 |       1 | Archive shouldUpdateDAO  |           1 |              4 |  1 |       0 | 2014-05-31 14:41:27 | 1       | 2014-06-04 | history sholdSaveDAO  | document/pdf | SHOULDSAVEDAO   |          1 |
    |  2 |       0 | Archive ShouldGetByIdDAO |           1 |              2 |  3 |       0 | 2014-05-30 14:41:27 | 1       | 2014-05-30 | history shouldGetById | document/pdf | SHOUDGETBYIDDAO |          2 |
    +----+---------+--------------------------+-------------+----------------+----+---------+---------------------+---------+------------+-----------------------+--------------+-----------------+------------+
    2 rows in set (0.00 sec)

   
   final String sql = "SELECT archive FROM archive AS a INNER JOIN archive_file as af " +
                  "WHERE af.id in (SELECT a.id FROM (SELECT archive_file FROM archive_file AS af " +
                  "WHERE  af.created > '2012-05-30' ORDER BY af.created DESC) AS a " +
                  "GROUP BY a.archive_id) AND a.id = af.archive_id";

    TypedQuery<Archive> query = getEm().createQuery(sql, Archive.class);