Hibernate:
    select
        organizati0_.id as id1_9_0_,
        organizati0_.registration_date_time as registra2_9_0_,
        organizati0_.registration_member_id as registra4_9_0_,
        organizati0_.title as title3_9_0_,
        member1_.id as id1_8_1_,
        member1_.email as email2_8_1_,
        member1_.first_name as first_na3_8_1_,
        member1_.last_name as last_nam4_8_1_,
        member1_.password as password5_8_1_,
        member1_.role as role6_8_1_,
        advertiser2_.id as id1_0_2_,
        advertiser2_.organization_id as organiza2_0_2_,
        site3_.id as id1_12_3_,
        site3_.organization_id as organiza2_12_3_
    from
        webserver.organization organizati0_
    inner join
        webserver.member member1_
            on organizati0_.registration_member_id=member1_.id
    left outer join
        webserver.advertiser advertiser2_
            on organizati0_.id=advertiser2_.organization_id
    left outer join
        webserver.site site3_
            on organizati0_.id=site3_.organization_id
    where
        organizati0_.id=?
Hibernate:
    select
        paidvideos0_.advertiser_id as advertis2_10_0_,
        paidvideos0_.id as id1_10_0_,
        paidvideos0_.id as id1_10_1_,
        paidvideos0_.advertiser_id as advertis2_10_1_,
        paidvideos0_.video_id as video_id3_10_1_,
        video1_.id as id1_14_2_,
        video1_.duration as duration2_14_2_,
        video1_.extension as extensio3_14_2_,
        video1_.md5sum as md4_14_2_,
        video1_.size as size5_14_2_,
        video1_.title as title6_14_2_,
        video1_.uploaded_date_time as uploaded7_14_2_,
        video1_.uploaded_member_id as uploaded8_14_2_,
        member2_.id as id1_8_3_,
        member2_.email as email2_8_3_,
        member2_.first_name as first_na3_8_3_,
        member2_.last_name as last_nam4_8_3_,
        member2_.password as password5_8_3_,
        member2_.role as role6_8_3_,
        freevideo3_.id as id1_6_4_,
        freevideo3_.video_id as video_id2_6_4_
    from
        webserver.paid_video paidvideos0_
    inner join
        webserver.video video1_
            on paidvideos0_.video_id=video1_.id
    inner join
        webserver.member member2_
            on video1_.uploaded_member_id=member2_.id
    left outer join
        webserver.free_video freevideo3_
            on video1_.id=freevideo3_.video_id
    where
        paidvideos0_.advertiser_id=?
Hibernate:
    select
        bookings0_.paid_video_id as paid_vid6_2_0_,
        bookings0_.id as id1_2_0_,
        bookings0_.id as id1_2_1_,
        bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
        bookings0_.end_date as end_date3_2_1_,
        bookings0_.paid_video_id as paid_vid6_2_1_,
        bookings0_.registration_date_time as registra4_2_1_,
        bookings0_.registration_member_id as registra7_2_1_,
        bookings0_.start_date as start_da5_2_1_,
        member1_.id as id1_8_2_,
        member1_.email as email2_8_2_,
        member1_.first_name as first_na3_8_2_,
        member1_.last_name as last_nam4_8_2_,
        member1_.password as password5_8_2_,
        member1_.role as role6_8_2_
    from
        webserver.booking bookings0_
    inner join
        webserver.member member1_
            on bookings0_.registration_member_id=member1_.id
    where
        bookings0_.paid_video_id=?
Hibernate:
    select
        shownvideo0_.booking_id as booking_3_11_0_,
        shownvideo0_.id as id1_11_0_,
        shownvideo0_.id as id1_11_1_,
        shownvideo0_.booking_id as booking_3_11_1_,
        shownvideo0_.datetime as datetime2_11_1_,
        shownvideo0_.device_id as device_i4_11_1_,
        device1_.id as id1_4_2_,
        device1_.location_id as location3_4_2_,
        device1_.uuid as uuid2_4_2_,
        location2_.id as id1_7_3_,
        location2_.max_device_count as max_devi2_7_3_,
        location2_.site_id as site_id4_7_3_,
        location2_.title as title3_7_3_,
        site3_.id as id1_12_4_,
        site3_.organization_id as organiza2_12_4_,
        organizati4_.id as id1_9_5_,
        organizati4_.registration_date_time as registra2_9_5_,
        organizati4_.registration_member_id as registra4_9_5_,
        organizati4_.title as title3_9_5_,
        member5_.id as id1_8_6_,
        member5_.email as email2_8_6_,
        member5_.first_name as first_na3_8_6_,
        member5_.last_name as last_nam4_8_6_,
        member5_.password as password5_8_6_,
        member5_.role as role6_8_6_,
        advertiser6_.id as id1_0_7_,
        advertiser6_.organization_id as organiza2_0_7_
    from
        webserver.shown_video shownvideo0_
    inner join
        webserver.device device1_
            on shownvideo0_.device_id=device1_.id
    inner join
        webserver.location location2_
            on device1_.location_id=location2_.id
    inner join
        webserver.site site3_
            on location2_.site_id=site3_.id
    inner join
        webserver.organization organizati4_
            on site3_.organization_id=organizati4_.id
    inner join
        webserver.member member5_
            on organizati4_.registration_member_id=member5_.id
    left outer join
        webserver.advertiser advertiser6_
            on organizati4_.id=advertiser6_.organization_id
    where
        shownvideo0_.booking_id=?
Hibernate:
    select
        bookings0_.paid_video_id as paid_vid6_2_0_,
        bookings0_.id as id1_2_0_,
        bookings0_.id as id1_2_1_,
        bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
        bookings0_.end_date as end_date3_2_1_,
        bookings0_.paid_video_id as paid_vid6_2_1_,
        bookings0_.registration_date_time as registra4_2_1_,
        bookings0_.registration_member_id as registra7_2_1_,
        bookings0_.start_date as start_da5_2_1_,
        member1_.id as id1_8_2_,
        member1_.email as email2_8_2_,
        member1_.first_name as first_na3_8_2_,
        member1_.last_name as last_nam4_8_2_,
        member1_.password as password5_8_2_,
        member1_.role as role6_8_2_
    from
        webserver.booking bookings0_
    inner join
        webserver.member member1_
            on bookings0_.registration_member_id=member1_.id
    where
        bookings0_.paid_video_id=?
Hibernate:
    select
        shownvideo0_.booking_id as booking_3_11_0_,
        shownvideo0_.id as id1_11_0_,
        shownvideo0_.id as id1_11_1_,
        shownvideo0_.booking_id as booking_3_11_1_,
        shownvideo0_.datetime as datetime2_11_1_,
        shownvideo0_.device_id as device_i4_11_1_,
        device1_.id as id1_4_2_,
        device1_.location_id as location3_4_2_,
        device1_.uuid as uuid2_4_2_,
        location2_.id as id1_7_3_,
        location2_.max_device_count as max_devi2_7_3_,
        location2_.site_id as site_id4_7_3_,
        location2_.title as title3_7_3_,
        site3_.id as id1_12_4_,
        site3_.organization_id as organiza2_12_4_,
        organizati4_.id as id1_9_5_,
        organizati4_.registration_date_time as registra2_9_5_,
        organizati4_.registration_member_id as registra4_9_5_,
        organizati4_.title as title3_9_5_,
        member5_.id as id1_8_6_,
        member5_.email as email2_8_6_,
        member5_.first_name as first_na3_8_6_,
        member5_.last_name as last_nam4_8_6_,
        member5_.password as password5_8_6_,
        member5_.role as role6_8_6_,
        advertiser6_.id as id1_0_7_,
        advertiser6_.organization_id as organiza2_0_7_
    from
        webserver.shown_video shownvideo0_
    inner join
        webserver.device device1_
            on shownvideo0_.device_id=device1_.id
    inner join
        webserver.location location2_
            on device1_.location_id=location2_.id
    inner join
        webserver.site site3_
            on location2_.site_id=site3_.id
    inner join
        webserver.organization organizati4_
            on site3_.organization_id=organizati4_.id
    inner join
        webserver.member member5_
            on organizati4_.registration_member_id=member5_.id
    left outer join
        webserver.advertiser advertiser6_
            on organizati4_.id=advertiser6_.organization_id
    where
        shownvideo0_.booking_id=?
Hibernate:
    select
        bookings0_.paid_video_id as paid_vid6_2_0_,
        bookings0_.id as id1_2_0_,
        bookings0_.id as id1_2_1_,
        bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
        bookings0_.end_date as end_date3_2_1_,
        bookings0_.paid_video_id as paid_vid6_2_1_,
        bookings0_.registration_date_time as registra4_2_1_,
        bookings0_.registration_member_id as registra7_2_1_,
        bookings0_.start_date as start_da5_2_1_,
        member1_.id as id1_8_2_,
        member1_.email as email2_8_2_,
        member1_.first_name as first_na3_8_2_,
        member1_.last_name as last_nam4_8_2_,
        member1_.password as password5_8_2_,
        member1_.role as role6_8_2_
    from
        webserver.booking bookings0_
    inner join
        webserver.member member1_
            on bookings0_.registration_member_id=member1_.id
    where
        bookings0_.paid_video_id=?
Hibernate:
    select
        shownvideo0_.booking_id as booking_3_11_0_,
        shownvideo0_.id as id1_11_0_,
        shownvideo0_.id as id1_11_1_,
        shownvideo0_.booking_id as booking_3_11_1_,
        shownvideo0_.datetime as datetime2_11_1_,
        shownvideo0_.device_id as device_i4_11_1_,
        device1_.id as id1_4_2_,
        device1_.location_id as location3_4_2_,
        device1_.uuid as uuid2_4_2_,
        location2_.id as id1_7_3_,
        location2_.max_device_count as max_devi2_7_3_,
        location2_.site_id as site_id4_7_3_,
        location2_.title as title3_7_3_,
        site3_.id as id1_12_4_,
        site3_.organization_id as organiza2_12_4_,
        organizati4_.id as id1_9_5_,
        organizati4_.registration_date_time as registra2_9_5_,
        organizati4_.registration_member_id as registra4_9_5_,
        organizati4_.title as title3_9_5_,
        member5_.id as id1_8_6_,
        member5_.email as email2_8_6_,
        member5_.first_name as first_na3_8_6_,
        member5_.last_name as last_nam4_8_6_,
        member5_.password as password5_8_6_,
        member5_.role as role6_8_6_,
        advertiser6_.id as id1_0_7_,
        advertiser6_.organization_id as organiza2_0_7_
    from
        webserver.shown_video shownvideo0_
    inner join
        webserver.device device1_
            on shownvideo0_.device_id=device1_.id
    inner join
        webserver.location location2_
            on device1_.location_id=location2_.id
    inner join
        webserver.site site3_
            on location2_.site_id=site3_.id
    inner join
        webserver.organization organizati4_
            on site3_.organization_id=organizati4_.id
    inner join
        webserver.member member5_
            on organizati4_.registration_member_id=member5_.id
    left outer join
        webserver.advertiser advertiser6_
            on organizati4_.id=advertiser6_.organization_id
    where
        shownvideo0_.booking_id=?
Hibernate:
    select
        bookings0_.paid_video_id as paid_vid6_2_0_,
        bookings0_.id as id1_2_0_,
        bookings0_.id as id1_2_1_,
        bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
        bookings0_.end_date as end_date3_2_1_,
        bookings0_.paid_video_id as paid_vid6_2_1_,
        bookings0_.registration_date_time as registra4_2_1_,
        bookings0_.registration_member_id as registra7_2_1_,
        bookings0_.start_date as start_da5_2_1_,
        member1_.id as id1_8_2_,
        member1_.email as email2_8_2_,
        member1_.first_name as first_na3_8_2_,
        member1_.last_name as last_nam4_8_2_,
        member1_.password as password5_8_2_,
        member1_.role as role6_8_2_
    from
        webserver.booking bookings0_
    inner join
        webserver.member member1_
            on bookings0_.registration_member_id=member1_.id
    where
        bookings0_.paid_video_id=?
Hibernate:
    select
        shownvideo0_.booking_id as booking_3_11_0_,
        shownvideo0_.id as id1_11_0_,
        shownvideo0_.id as id1_11_1_,
        shownvideo0_.booking_id as booking_3_11_1_,
        shownvideo0_.datetime as datetime2_11_1_,
        shownvideo0_.device_id as device_i4_11_1_,
        device1_.id as id1_4_2_,
        device1_.location_id as location3_4_2_,
        device1_.uuid as uuid2_4_2_,
        location2_.id as id1_7_3_,
        location2_.max_device_count as max_devi2_7_3_,
        location2_.site_id as site_id4_7_3_,
        location2_.title as title3_7_3_,
        site3_.id as id1_12_4_,
        site3_.organization_id as organiza2_12_4_,
        organizati4_.id as id1_9_5_,
        organizati4_.registration_date_time as registra2_9_5_,
        organizati4_.registration_member_id as registra4_9_5_,
        organizati4_.title as title3_9_5_,
        member5_.id as id1_8_6_,
        member5_.email as email2_8_6_,
        member5_.first_name as first_na3_8_6_,
        member5_.last_name as last_nam4_8_6_,
        member5_.password as password5_8_6_,
        member5_.role as role6_8_6_,
        advertiser6_.id as id1_0_7_,
        advertiser6_.organization_id as organiza2_0_7_
    from
        webserver.shown_video shownvideo0_
    inner join
        webserver.device device1_
            on shownvideo0_.device_id=device1_.id
    inner join
        webserver.location location2_
            on device1_.location_id=location2_.id
    inner join
        webserver.site site3_
            on location2_.site_id=site3_.id
    inner join
        webserver.organization organizati4_
            on site3_.organization_id=organizati4_.id
    inner join
        webserver.member member5_
            on organizati4_.registration_member_id=member5_.id
    left outer join
        webserver.advertiser advertiser6_
            on organizati4_.id=advertiser6_.organization_id
    where
        shownvideo0_.booking_id=?
Hibernate:
    select
        bookings0_.paid_video_id as paid_vid6_2_0_,
        bookings0_.id as id1_2_0_,
        bookings0_.id as id1_2_1_,
        bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
        bookings0_.end_date as end_date3_2_1_,
        bookings0_.paid_video_id as paid_vid6_2_1_,
        bookings0_.registration_date_time as registra4_2_1_,
        bookings0_.registration_member_id as registra7_2_1_,
        bookings0_.start_date as start_da5_2_1_,
        member1_.id as id1_8_2_,
        member1_.email as email2_8_2_,
        member1_.first_name as first_na3_8_2_,
        member1_.last_name as last_nam4_8_2_,
        member1_.password as password5_8_2_,
        member1_.role as role6_8_2_
    from
        webserver.booking bookings0_
    inner join
        webserver.member member1_
            on bookings0_.registration_member_id=member1_.id
    where
        bookings0_.paid_video_id=?
Hibernate:
    select
        shownvideo0_.booking_id as booking_3_11_0_,
        shownvideo0_.id as id1_11_0_,
        shownvideo0_.id as id1_11_1_,
        shownvideo0_.booking_id as booking_3_11_1_,
        shownvideo0_.datetime as datetime2_11_1_,
        shownvideo0_.device_id as device_i4_11_1_,
        device1_.id as id1_4_2_,
        device1_.location_id as location3_4_2_,
        device1_.uuid as uuid2_4_2_,
        location2_.id as id1_7_3_,
        location2_.max_device_count as max_devi2_7_3_,
        location2_.site_id as site_id4_7_3_,
        location2_.title as title3_7_3_,
        site3_.id as id1_12_4_,
        site3_.organization_id as organiza2_12_4_,
        organizati4_.id as id1_9_5_,
        organizati4_.registration_date_time as registra2_9_5_,
        organizati4_.registration_member_id as registra4_9_5_,
        organizati4_.title as title3_9_5_,
        member5_.id as id1_8_6_,
        member5_.email as email2_8_6_,
        member5_.first_name as first_na3_8_6_,
        member5_.last_name as last_nam4_8_6_,
        member5_.password as password5_8_6_,
        member5_.role as role6_8_6_,
        advertiser6_.id as id1_0_7_,
        advertiser6_.organization_id as organiza2_0_7_
    from
        webserver.shown_video shownvideo0_
    inner join
        webserver.device device1_
            on shownvideo0_.device_id=device1_.id
    inner join
        webserver.location location2_
            on device1_.location_id=location2_.id
    inner join
        webserver.site site3_
            on location2_.site_id=site3_.id
    inner join
        webserver.organization organizati4_
            on site3_.organization_id=organizati4_.id
    inner join
        webserver.member member5_
            on organizati4_.registration_member_id=member5_.id
    left outer join
        webserver.advertiser advertiser6_
            on organizati4_.id=advertiser6_.organization_id
    where
        shownvideo0_.booking_id=?
Hibernate:
    select
        bookings0_.paid_video_id as paid_vid6_2_0_,
        bookings0_.id as id1_2_0_,
        bookings0_.id as id1_2_1_,
        bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
        bookings0_.end_date as end_date3_2_1_,
        bookings0_.paid_video_id as paid_vid6_2_1_,
        bookings0_.registration_date_time as registra4_2_1_,
        bookings0_.registration_member_id as registra7_2_1_,
        bookings0_.start_date as start_da5_2_1_,
        member1_.id as id1_8_2_,
        member1_.email as email2_8_2_,
        member1_.first_name as first_na3_8_2_,
        member1_.last_name as last_nam4_8_2_,
        member1_.password as password5_8_2_,
        member1_.role as role6_8_2_
    from
        webserver.booking bookings0_
    inner join
        webserver.member member1_
            on bookings0_.registration_member_id=member1_.id
    where
        bookings0_.paid_video_id=?
Hibernate:
    select
        shownvideo0_.booking_id as booking_3_11_0_,
        shownvideo0_.id as id1_11_0_,
        shownvideo0_.id as id1_11_1_,
        shownvideo0_.booking_id as booking_3_11_1_,
        shownvideo0_.datetime as datetime2_11_1_,
        shownvideo0_.device_id as device_i4_11_1_,
        device1_.id as id1_4_2_,
        device1_.location_id as location3_4_2_,
        device1_.uuid as uuid2_4_2_,
        location2_.id as id1_7_3_,
        location2_.max_device_count as max_devi2_7_3_,
        location2_.site_id as site_id4_7_3_,
        location2_.title as title3_7_3_,
        site3_.id as id1_12_4_,
        site3_.organization_id as organiza2_12_4_,
        organizati4_.id as id1_9_5_,
        organizati4_.registration_date_time as registra2_9_5_,
        organizati4_.registration_member_id as registra4_9_5_,
        organizati4_.title as title3_9_5_,
        member5_.id as id1_8_6_,
        member5_.email as email2_8_6_,
        member5_.first_name as first_na3_8_6_,
        member5_.last_name as last_nam4_8_6_,
        member5_.password as password5_8_6_,
        member5_.role as role6_8_6_,
        advertiser6_.id as id1_0_7_,
        advertiser6_.organization_id as organiza2_0_7_
    from
        webserver.shown_video shownvideo0_
    inner join
        webserver.device device1_
            on shownvideo0_.device_id=device1_.id
    inner join
        webserver.location location2_
            on device1_.location_id=location2_.id
    inner join
        webserver.site site3_
            on location2_.site_id=site3_.id
    inner join
        webserver.organization organizati4_
            on site3_.organization_id=organizati4_.id
    inner join
        webserver.member member5_
            on organizati4_.registration_member_id=member5_.id
    left outer join
        webserver.advertiser advertiser6_
            on organizati4_.id=advertiser6_.organization_id
    where
        shownvideo0_.booking_id=?
Hibernate:
    select
        bookings0_.paid_video_id as paid_vid6_2_0_,
        bookings0_.id as id1_2_0_,
        bookings0_.id as id1_2_1_,
        bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
        bookings0_.end_date as end_date3_2_1_,
        bookings0_.paid_video_id as paid_vid6_2_1_,
        bookings0_.registration_date_time as registra4_2_1_,
        bookings0_.registration_member_id as registra7_2_1_,
        bookings0_.start_date as start_da5_2_1_,
        member1_.id as id1_8_2_,
        member1_.email as email2_8_2_,
        member1_.first_name as first_na3_8_2_,
        member1_.last_name as last_nam4_8_2_,
        member1_.password as password5_8_2_,
        member1_.role as role6_8_2_
    from
        webserver.booking bookings0_
    inner join
        webserver.member member1_
            on bookings0_.registration_member_id=member1_.id
    where
        bookings0_.paid_video_id=?
Hibernate:
    select
        shownvideo0_.booking_id as booking_3_11_0_,
        shownvideo0_.id as id1_11_0_,
        shownvideo0_.id as id1_11_1_,
        shownvideo0_.booking_id as booking_3_11_1_,
        shownvideo0_.datetime as datetime2_11_1_,
        shownvideo0_.device_id as device_i4_11_1_,
        device1_.id as id1_4_2_,
        device1_.location_id as location3_4_2_,
        device1_.uuid as uuid2_4_2_,
        location2_.id as id1_7_3_,
        location2_.max_device_count as max_devi2_7_3_,
        location2_.site_id as site_id4_7_3_,
        location2_.title as title3_7_3_,
        site3_.id as id1_12_4_,
        site3_.organization_id as organiza2_12_4_,
        organizati4_.id as id1_9_5_,
        organizati4_.registration_date_time as registra2_9_5_,
        organizati4_.registration_member_id as registra4_9_5_,
        organizati4_.title as title3_9_5_,
        member5_.id as id1_8_6_,
        member5_.email as email2_8_6_,
        member5_.first_name as first_na3_8_6_,
        member5_.last_name as last_nam4_8_6_,
        member5_.password as password5_8_6_,
        member5_.role as role6_8_6_,
        advertiser6_.id as id1_0_7_,
        advertiser6_.organization_id as organiza2_0_7_
    from
        webserver.shown_video shownvideo0_
    inner join
        webserver.device device1_
            on shownvideo0_.device_id=device1_.id
    inner join
        webserver.location location2_
            on device1_.location_id=location2_.id
    inner join
        webserver.site site3_
            on location2_.site_id=site3_.id
    inner join
        webserver.organization organizati4_
            on site3_.organization_id=organizati4_.id
    inner join
        webserver.member member5_
            on organizati4_.registration_member_id=member5_.id
    left outer join
        webserver.advertiser advertiser6_
            on organizati4_.id=advertiser6_.organization_id
    where
        shownvideo0_.booking_id=?
Hibernate:
    select
        bookings0_.paid_video_id as paid_vid6_2_0_,
        bookings0_.id as id1_2_0_,
        bookings0_.id as id1_2_1_,
        bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
        bookings0_.end_date as end_date3_2_1_,
        bookings0_.paid_video_id as paid_vid6_2_1_,
        bookings0_.registration_date_time as registra4_2_1_,
        bookings0_.registration_member_id as registra7_2_1_,
        bookings0_.start_date as start_da5_2_1_,
        member1_.id as id1_8_2_,
        member1_.email as email2_8_2_,
        member1_.first_name as first_na3_8_2_,
        member1_.last_name as last_nam4_8_2_,
        member1_.password as password5_8_2_,
        member1_.role as role6_8_2_
    from
        webserver.booking bookings0_
    inner join
        webserver.member member1_
            on bookings0_.registration_member_id=member1_.id
    where
        bookings0_.paid_video_id=?
Hibernate:
    select
        shownvideo0_.booking_id as booking_3_11_0_,
        shownvideo0_.id as id1_11_0_,
        shownvideo0_.id as id1_11_1_,
        shownvideo0_.booking_id as booking_3_11_1_,
        shownvideo0_.datetime as datetime2_11_1_,
        shownvideo0_.device_id as device_i4_11_1_,
        device1_.id as id1_4_2_,
        device1_.location_id as location3_4_2_,
        device1_.uuid as uuid2_4_2_,
        location2_.id as id1_7_3_,
        location2_.max_device_count as max_devi2_7_3_,
        location2_.site_id as site_id4_7_3_,
        location2_.title as title3_7_3_,
        site3_.id as id1_12_4_,
        site3_.organization_id as organiza2_12_4_,
        organizati4_.id as id1_9_5_,
        organizati4_.registration_date_time as registra2_9_5_,
        organizati4_.registration_member_id as registra4_9_5_,
        organizati4_.title as title3_9_5_,
        member5_.id as id1_8_6_,
        member5_.email as email2_8_6_,
        member5_.first_name as first_na3_8_6_,
        member5_.last_name as last_nam4_8_6_,
        member5_.password as password5_8_6_,
        member5_.role as role6_8_6_,
        advertiser6_.id as id1_0_7_,
        advertiser6_.organization_id as organiza2_0_7_
    from
        webserver.shown_video shownvideo0_
    inner join
        webserver.device device1_
            on shownvideo0_.device_id=device1_.id
    inner join
        webserver.location location2_
            on device1_.location_id=location2_.id
    inner join
        webserver.site site3_
            on location2_.site_id=site3_.id
    inner join
        webserver.organization organizati4_
            on site3_.organization_id=organizati4_.id
    inner join
        webserver.member member5_
            on organizati4_.registration_member_id=member5_.id
    left outer join
        webserver.advertiser advertiser6_
            on organizati4_.id=advertiser6_.organization_id
    where
        shownvideo0_.booking_id=?
Hibernate:
    select
        bookings0_.paid_video_id as paid_vid6_2_0_,
        bookings0_.id as id1_2_0_,
        bookings0_.id as id1_2_1_,
        bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
        bookings0_.end_date as end_date3_2_1_,
        bookings0_.paid_video_id as paid_vid6_2_1_,
        bookings0_.registration_date_time as registra4_2_1_,
        bookings0_.registration_member_id as registra7_2_1_,
        bookings0_.start_date as start_da5_2_1_,
        member1_.id as id1_8_2_,
        member1_.email as email2_8_2_,
        member1_.first_name as first_na3_8_2_,
        member1_.last_name as last_nam4_8_2_,
        member1_.password as password5_8_2_,
        member1_.role as role6_8_2_
    from
        webserver.booking bookings0_
    inner join
        webserver.member member1_
            on bookings0_.registration_member_id=member1_.id
    where
        bookings0_.paid_video_id=?
Hibernate:
    select
        shownvideo0_.booking_id as booking_3_11_0_,
        shownvideo0_.id as id1_11_0_,
        shownvideo0_.id as id1_11_1_,
        shownvideo0_.booking_id as booking_3_11_1_,
        shownvideo0_.datetime as datetime2_11_1_,
        shownvideo0_.device_id as device_i4_11_1_,
        device1_.id as id1_4_2_,
        device1_.location_id as location3_4_2_,
        device1_.uuid as uuid2_4_2_,
        location2_.id as id1_7_3_,
        location2_.max_device_count as max_devi2_7_3_,
        location2_.site_id as site_id4_7_3_,
        location2_.title as title3_7_3_,
        site3_.id as id1_12_4_,
        site3_.organization_id as organiza2_12_4_,
        organizati4_.id as id1_9_5_,
        organizati4_.registration_date_time as registra2_9_5_,
        organizati4_.registration_member_id as registra4_9_5_,
        organizati4_.title as title3_9_5_,
        member5_.id as id1_8_6_,
        member5_.email as email2_8_6_,
        member5_.first_name as first_na3_8_6_,
        member5_.last_name as last_nam4_8_6_,
        member5_.password as password5_8_6_,
        member5_.role as role6_8_6_,
        advertiser6_.id as id1_0_7_,
        advertiser6_.organization_id as organiza2_0_7_
    from
        webserver.shown_video shownvideo0_
    inner join
        webserver.device device1_
            on shownvideo0_.device_id=device1_.id
    inner join
        webserver.location location2_
            on device1_.location_id=location2_.id
    inner join
        webserver.site site3_
            on location2_.site_id=site3_.id
    inner join
        webserver.organization organizati4_
            on site3_.organization_id=organizati4_.id
    inner join
        webserver.member member5_
            on organizati4_.registration_member_id=member5_.id
    left outer join
        webserver.advertiser advertiser6_
            on organizati4_.id=advertiser6_.organization_id
    where
        shownvideo0_.booking_id=?
Hibernate:
    select
        bookings0_.paid_video_id as paid_vid6_2_0_,
        bookings0_.id as id1_2_0_,
        bookings0_.id as id1_2_1_,
        bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
        bookings0_.end_date as end_date3_2_1_,
        bookings0_.paid_video_id as paid_vid6_2_1_,
        bookings0_.registration_date_time as registra4_2_1_,
        bookings0_.registration_member_id as registra7_2_1_,
        bookings0_.start_date as start_da5_2_1_,
        member1_.id as id1_8_2_,
        member1_.email as email2_8_2_,
        member1_.first_name as first_na3_8_2_,
        member1_.last_name as last_nam4_8_2_,
        member1_.password as password5_8_2_,
        member1_.role as role6_8_2_
    from
        webserver.booking bookings0_
    inner join
        webserver.member member1_
            on bookings0_.registration_member_id=member1_.id
    where
        bookings0_.paid_video_id=?
Hibernate:
    select
        shownvideo0_.booking_id as booking_3_11_0_,
        shownvideo0_.id as id1_11_0_,
        shownvideo0_.id as id1_11_1_,
        shownvideo0_.booking_id as booking_3_11_1_,
        shownvideo0_.datetime as datetime2_11_1_,
        shownvideo0_.device_id as device_i4_11_1_,
        device1_.id as id1_4_2_,
        device1_.location_id as location3_4_2_,
        device1_.uuid as uuid2_4_2_,
        location2_.id as id1_7_3_,
        location2_.max_device_count as max_devi2_7_3_,
        location2_.site_id as site_id4_7_3_,
        location2_.title as title3_7_3_,
        site3_.id as id1_12_4_,
        site3_.organization_id as organiza2_12_4_,
        organizati4_.id as id1_9_5_,
        organizati4_.registration_date_time as registra2_9_5_,
        organizati4_.registration_member_id as registra4_9_5_,
        organizati4_.title as title3_9_5_,
        member5_.id as id1_8_6_,
        member5_.email as email2_8_6_,
        member5_.first_name as first_na3_8_6_,
        member5_.last_name as last_nam4_8_6_,
        member5_.password as password5_8_6_,
        member5_.role as role6_8_6_,
        advertiser6_.id as id1_0_7_,
        advertiser6_.organization_id as organiza2_0_7_
    from
        webserver.shown_video shownvideo0_
    inner join
        webserver.device device1_
            on shownvideo0_.device_id=device1_.id
    inner join
        webserver.location location2_
            on device1_.location_id=location2_.id
    inner join
        webserver.site site3_
            on location2_.site_id=site3_.id
    inner join
        webserver.organization organizati4_
            on site3_.organization_id=organizati4_.id
    inner join
        webserver.member member5_
            on organizati4_.registration_member_id=member5_.id
    left outer join
        webserver.advertiser advertiser6_
            on organizati4_.id=advertiser6_.organization_id
    where
        shownvideo0_.booking_id=?
Hibernate:
    select
        bookings0_.paid_video_id as paid_vid6_2_0_,
        bookings0_.id as id1_2_0_,
        bookings0_.id as id1_2_1_,
        bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
        bookings0_.end_date as end_date3_2_1_,
        bookings0_.paid_video_id as paid_vid6_2_1_,
        bookings0_.registration_date_time as registra4_2_1_,
        bookings0_.registration_member_id as registra7_2_1_,
        bookings0_.start_date as start_da5_2_1_,
        member1_.id as id1_8_2_,
        member1_.email as email2_8_2_,
        member1_.first_name as first_na3_8_2_,
        member1_.last_name as last_nam4_8_2_,
        member1_.password as password5_8_2_,
        member1_.role as role6_8_2_
    from
        webserver.booking bookings0_
    inner join
        webserver.member member1_
            on bookings0_.registration_member_id=member1_.id
    where
        bookings0_.paid_video_id=?
Hibernate:
    select
        shownvideo0_.booking_id as booking_3_11_0_,
        shownvideo0_.id as id1_11_0_,
        shownvideo0_.id as id1_11_1_,
        shownvideo0_.booking_id as booking_3_11_1_,
        shownvideo0_.datetime as datetime2_11_1_,
        shownvideo0_.device_id as device_i4_11_1_,
        device1_.id as id1_4_2_,
        device1_.location_id as location3_4_2_,
        device1_.uuid as uuid2_4_2_,
        location2_.id as id1_7_3_,
        location2_.max_device_count as max_devi2_7_3_,
        location2_.site_id as site_id4_7_3_,
        location2_.title as title3_7_3_,
        site3_.id as id1_12_4_,
        site3_.organization_id as organiza2_12_4_,
        organizati4_.id as id1_9_5_,
        organizati4_.registration_date_time as registra2_9_5_,
        organizati4_.registration_member_id as registra4_9_5_,
        organizati4_.title as title3_9_5_,
        member5_.id as id1_8_6_,
        member5_.email as email2_8_6_,
        member5_.first_name as first_na3_8_6_,
        member5_.last_name as last_nam4_8_6_,
        member5_.password as password5_8_6_,
        member5_.role as role6_8_6_,
        advertiser6_.id as id1_0_7_,
        advertiser6_.organization_id as organiza2_0_7_
    from
        webserver.shown_video shownvideo0_
    inner join
        webserver.device device1_
            on shownvideo0_.device_id=device1_.id
    inner join
        webserver.location location2_
            on device1_.location_id=location2_.id
    inner join
        webserver.site site3_
            on location2_.site_id=site3_.id
    inner join
        webserver.organization organizati4_
            on site3_.organization_id=organizati4_.id
    inner join
        webserver.member member5_
            on organizati4_.registration_member_id=member5_.id
    left outer join
        webserver.advertiser advertiser6_
            on organizati4_.id=advertiser6_.organization_id
    where
        shownvideo0_.booking_id=?
Hibernate:
    select
        bookings0_.paid_video_id as paid_vid6_2_0_,
        bookings0_.id as id1_2_0_,
        bookings0_.id as id1_2_1_,
        bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
        bookings0_.end_date as end_date3_2_1_,
        bookings0_.paid_video_id as paid_vid6_2_1_,
        bookings0_.registration_date_time as registra4_2_1_,
        bookings0_.registration_member_id as registra7_2_1_,
        bookings0_.start_date as start_da5_2_1_,
        member1_.id as id1_8_2_,
        member1_.email as email2_8_2_,
        member1_.first_name as first_na3_8_2_,
        member1_.last_name as last_nam4_8_2_,
        member1_.password as password5_8_2_,
        member1_.role as role6_8_2_
    from
        webserver.booking bookings0_
    inner join
        webserver.member member1_
            on bookings0_.registration_member_id=member1_.id
    where
        bookings0_.paid_video_id=?
Hibernate:
    select
        shownvideo0_.booking_id as booking_3_11_0_,
        shownvideo0_.id as id1_11_0_,
        shownvideo0_.id as id1_11_1_,
        shownvideo0_.booking_id as booking_3_11_1_,
        shownvideo0_.datetime as datetime2_11_1_,
        shownvideo0_.device_id as device_i4_11_1_,
        device1_.id as id1_4_2_,
        device1_.location_id as location3_4_2_,
        device1_.uuid as uuid2_4_2_,
        location2_.id as id1_7_3_,
        location2_.max_device_count as max_devi2_7_3_,
        location2_.site_id as site_id4_7_3_,
        location2_.title as title3_7_3_,
        site3_.id as id1_12_4_,
        site3_.organization_id as organiza2_12_4_,
        organizati4_.id as id1_9_5_,
        organizati4_.registration_date_time as registra2_9_5_,
        organizati4_.registration_member_id as registra4_9_5_,
        organizati4_.title as title3_9_5_,
        member5_.id as id1_8_6_,
        member5_.email as email2_8_6_,
        member5_.first_name as first_na3_8_6_,
        member5_.last_name as last_nam4_8_6_,
        member5_.password as password5_8_6_,
        member5_.role as role6_8_6_,
        advertiser6_.id as id1_0_7_,
        advertiser6_.organization_id as organiza2_0_7_
    from
        webserver.shown_video shownvideo0_
    inner join
        webserver.device device1_
            on shownvideo0_.device_id=device1_.id
    inner join
        webserver.location location2_
            on device1_.location_id=location2_.id
    inner join
        webserver.site site3_
            on location2_.site_id=site3_.id
    inner join
        webserver.organization organizati4_
            on site3_.organization_id=organizati4_.id
    inner join
        webserver.member member5_
            on organizati4_.registration_member_id=member5_.id
    left outer join
        webserver.advertiser advertiser6_
            on organizati4_.id=advertiser6_.organization_id
    where
        shownvideo0_.booking_id=?
Hibernate:
    select
        bookings0_.paid_video_id as paid_vid6_2_0_,
        bookings0_.id as id1_2_0_,
        bookings0_.id as id1_2_1_,
        bookings0_.demonstration_count_per_hour as demonstr2_2_1_,
        bookings0_.end_date as end_date3_2_1_,
        bookings0_.paid_video_id as paid_vid6_2_1_,
        bookings0_.registration_date_time as registra4_2_1_,
        bookings0_.registration_member_id as registra7_2_1_,
        bookings0_.start_date as start_da5_2_1_,
        member1_.id as id1_8_2_,
        member1_.email as email2_8_2_,
        member1_.first_name as first_na3_8_2_,
        member1_.last_name as last_nam4_8_2_,
        member1_.password as password5_8_2_,
        member1_.role as role6_8_2_
    from
        webserver.booking bookings0_
    inner join
        webserver.member member1_
            on bookings0_.registration_member_id=member1_.id
    where
        bookings0_.paid_video_id=?
Hibernate:
    select
        shownvideo0_.booking_id as booking_3_11_0_,
        shownvideo0_.id as id1_11_0_,
        shownvideo0_.id as id1_11_1_,
        shownvideo0_.booking_id as booking_3_11_1_,
        shownvideo0_.datetime as datetime2_11_1_,
        shownvideo0_.device_id as device_i4_11_1_,
        device1_.id as id1_4_2_,
        device1_.location_id as location3_4_2_,
        device1_.uuid as uuid2_4_2_,
        location2_.id as id1_7_3_,
        location2_.max_device_count as max_devi2_7_3_,
        location2_.site_id as site_id4_7_3_,
        location2_.title as title3_7_3_,
        site3_.id as id1_12_4_,
        site3_.organization_id as organiza2_12_4_,
        organizati4_.id as id1_9_5_,
        organizati4_.registration_date_time as registra2_9_5_,
        organizati4_.registration_member_id as registra4_9_5_,
        organizati4_.title as title3_9_5_,
        member5_.id as id1_8_6_,
        member5_.email as email2_8_6_,
        member5_.first_name as first_na3_8_6_,
        member5_.last_name as last_nam4_8_6_,
        member5_.password as password5_8_6_,
        member5_.role as role6_8_6_,
        advertiser6_.id as id1_0_7_,
        advertiser6_.organization_id as organiza2_0_7_
    from
        webserver.shown_video shownvideo0_
    inner join
        webserver.device device1_
            on shownvideo0_.device_id=device1_.id
    inner join
        webserver.location location2_
            on device1_.location_id=location2_.id
    inner join
        webserver.site site3_
            on location2_.site_id=site3_.id
    inner join
        webserver.organization organizati4_
            on site3_.organization_id=organizati4_.id
    inner join
        webserver.member member5_
            on organizati4_.registration_member_id=member5_.id
    left outer join
        webserver.advertiser advertiser6_
            on organizati4_.id=advertiser6_.organization_id
    where
        shownvideo0_.booking_id=?
Hibernate:
    delete
    from
        webserver.advertiser
    where
        id=?
2019-03-02 12:39:32.966  WARN 13202 --- [nio-8080-exec-3] o.h.e.j.s.SqlExceptionHelper             : SQL Error: 0, SQLState: 23503
2019-03-02 12:39:32.966 ERROR 13202 --- [nio-8080-exec-3] o.h.e.j.s.SqlExceptionHelper             : ОШИБКА: UPDATE или DELETE в таблице "advertiser" нарушает ограничение внешнего ключа "fk9u3reoihx4kwps8efgdfhc0af" таблицы "paid_video"
  Подробности: На ключ (id)=(1) всё ещё есть ссылки в таблице "paid_video".
2019-03-02 12:39:32.967  INFO 13202 --- [nio-8080-exec-3] o.h.e.j.b.i.AbstractBatchImpl            : HHH000010: On release of batch it still contained JDBC statements
2019-03-02 12:39:32.968 ERROR 13202 --- [nio-8080-exec-3] o.h.i.ExceptionMapperStandardImpl        : HHH000346: Error during managed flush [org.hibernate.exception.ConstraintViolationException: could not execute statement]
2019-03-02 12:39:32.974 ERROR 13202 --- [nio-8080-exec-3] o.a.c.c.C.[.[.[.[dispatcherServlet]      : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement] with root cause

org.postgresql.util.PSQLException: ОШИБКА: UPDATE или DELETE в таблице "advertiser" нарушает ограничение внешнего ключа "fk9u3reoihx4kwps8efgdfhc0af" таблицы "paid_video"
  Подробности: На ключ (id)=(1) всё ещё есть ссылки в таблице "paid_video".