Hibernate:
    SELECT
        building0_.building_id AS building1_7_,
        building0_.address AS address2_7_,
        building0_.city_cityId AS city_cit3_7_
    FROM
        building building0_
    LEFT OUTER JOIN
        appartment appartment1_
            ON building0_.building_id=appartment1_.building_id
    LEFT OUTER JOIN
        room roomlist2_
            ON appartment1_.appartment_id=roomlist2_.appartment_id
    WHERE
        roomlist2_.available=1

Hibernate:
    SELECT
        city0_.city_id AS city_id1_8_0_,
        city0_.city AS city2_8_0_
    FROM
        city city0_
    WHERE
        city0_.city_id=?
Hibernate:

    SELECT
        appartment0_.building_id AS building5_7_0_,
        appartment0_.appartment_id AS appartme1_1_0_,
        appartment0_.appartment_id AS appartme1_1_1_,
        appartment0_.active AS active2_1_1_,
        appartment0_.name AS name3_1_1_,
        appartment0_.support_two_person AS support_4_1_1_
    FROM
        appartment appartment0_
    WHERE
        appartment0_.building_id=?
Hibernate:

    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        appartment0_.building_id AS building5_7_0_,
        appartment0_.appartment_id AS appartme1_1_0_,
        appartment0_.appartment_id AS appartme1_1_1_,
        appartment0_.active AS active2_1_1_,
        appartment0_.name AS name3_1_1_,
        appartment0_.support_two_person AS support_4_1_1_
    FROM
        appartment appartment0_
    WHERE
        appartment0_.building_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        appartment0_.building_id AS building5_7_0_,
        appartment0_.appartment_id AS appartme1_1_0_,
        appartment0_.appartment_id AS appartme1_1_1_,
        appartment0_.active AS active2_1_1_,
        appartment0_.name AS name3_1_1_,
        appartment0_.support_two_person AS support_4_1_1_
    FROM
        appartment appartment0_
    WHERE
        appartment0_.building_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        appartment0_.building_id AS building5_7_0_,
        appartment0_.appartment_id AS appartme1_1_0_,
        appartment0_.appartment_id AS appartme1_1_1_,
        appartment0_.active AS active2_1_1_,
        appartment0_.name AS name3_1_1_,
        appartment0_.support_two_person AS support_4_1_1_
    FROM
        appartment appartment0_
    WHERE
        appartment0_.building_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        appartment0_.building_id AS building5_7_0_,
        appartment0_.appartment_id AS appartme1_1_0_,
        appartment0_.appartment_id AS appartme1_1_1_,
        appartment0_.active AS active2_1_1_,
        appartment0_.name AS name3_1_1_,
        appartment0_.support_two_person AS support_4_1_1_
    FROM
        appartment appartment0_
    WHERE
        appartment0_.building_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        appartment0_.building_id AS building5_7_0_,
        appartment0_.appartment_id AS appartme1_1_0_,
        appartment0_.appartment_id AS appartme1_1_1_,
        appartment0_.active AS active2_1_1_,
        appartment0_.name AS name3_1_1_,
        appartment0_.support_two_person AS support_4_1_1_
    FROM
        appartment appartment0_
    WHERE
        appartment0_.building_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        appartment0_.building_id AS building5_7_0_,
        appartment0_.appartment_id AS appartme1_1_0_,
        appartment0_.appartment_id AS appartme1_1_1_,
        appartment0_.active AS active2_1_1_,
        appartment0_.name AS name3_1_1_,
        appartment0_.support_two_person AS support_4_1_1_
    FROM
        appartment appartment0_
    WHERE
        appartment0_.building_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        appartment0_.building_id AS building5_7_0_,
        appartment0_.appartment_id AS appartme1_1_0_,
        appartment0_.appartment_id AS appartme1_1_1_,
        appartment0_.active AS active2_1_1_,
        appartment0_.name AS name3_1_1_,
        appartment0_.support_two_person AS support_4_1_1_
    FROM
        appartment appartment0_
    WHERE
        appartment0_.building_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?
Hibernate:
    SELECT
        roomlist0_.appartment_id AS appartme4_1_0_,
        roomlist0_.room_id AS room_id1_34_0_,
        roomlist0_.room_id AS room_id1_34_1_,
        roomlist0_.available AS availabl2_34_1_,
        roomlist0_.name AS name3_34_1_
    FROM
        room roomlist0_
    WHERE
        roomlist0_.appartment_id=?