D-Net

Hibernate: 

    select

        o.id as id,

        case 

            when o.shortname is not null then o.shortname 

            else o.name 

        end  as category,

        count(r.id) as count 

    from

        request r 

    join

        organization o 

            on o.id=r.organization 

    group by

        o.shortname,

        o.name,

        o.id 

    order by

        category

Hibernate: 

    select

        distinct p.scientificarea as id,

        p.scientificarea as category,

        count(r.id) as count 

    from

        request r 

    join

        project p 

            on r.project=p.id 

    group by

        p.scientificarea 

    order by

        category

Hibernate: 

    select

        p.id as id,

        p.name as category,

        count(r.id) as count 

    from

        (select

            r.id,

            r.status,

            j.publisher,

            'j' 

        from

            request r 

        join

            journal j 

                on r.journal=j.id 

        where

            j.publisher is not null 

        union

        select

            r.id,

            r.status,

            p.id,

            'p' 

        from

            request r 

        join

            publisher p 

                on r.publisher=p.id

        ) as r 

join

    publisher p 

        on r.publisher=p.id 

group by

    p.name,

    p.id 

order by

    category

Hibernate: 

    select

        c.id as id,

        c.name as category,

        count(r.id) as count 

    from

        request r 

    join

        organization o 

            on r.organization=o.id 

    join

        country c 

            on c.id=o.country 

    group by

        c.name,

        c.id 

    order by

        category

Hibernate: 

    select

        this_.id as id1_20_22_,

        this_.apc as apc2_20_22_,

        this_.apcPaid as apcPaid3_20_22_,

        this_.approvaldate as approval4_20_22_,

        this_.bankAccount as bankAcc16_20_22_,

        this_.bankTransferReceipt as bankTra17_20_22_,

        this_.budget as budget18_20_22_,

        this_.currency as currency5_20_22_,

        this_.date as date6_20_22_,

        this_.datePaid as datePaid7_20_22_,

        this_.discount as discount8_20_22_,

        this_.fundingrequested as fundingr9_20_22_,

        this_.invoice as invoice19_20_22_,

        this_.journal as journal20_20_22_,

        this_.organization as organiz21_20_22_,

        this_.otherCost as otherCo10_20_22_,

        this_.project as project22_20_22_,

        this_.projectparticipation as project11_20_22_,

        this_.publication as publica23_20_22_,

        this_.publisher as publish24_20_22_,

        this_.publisher_email as publish12_20_22_,

        this_.researcher as researc25_20_22_,

        this_.status as status13_20_22_,

        this_.submissiondate as submiss14_20_22_,

        this_.transferCost as transfe15_20_22_,

        this_."user" as user26_20_22_,

        bankaccoun2_.id as id1_2_0_,

        bankaccoun2_.accountHolder as accountH2_2_0_,

        bankaccoun2_.bankAddress as bankAddr3_2_0_,

        bankaccoun2_.bankCode as bankCode4_2_0_,

        bankaccoun2_.bankName as bankName5_2_0_,

        bankaccoun2_.iban as iban6_2_0_,

        banktransf3_.id as id1_3_1_,

        banktransf3_.content as content2_3_1_,

        banktransf3_.contentType as contentT3_3_1_,

        budget4_.id as id1_4_2_,

        budget4_.amountGranted as amountGr2_4_2_,

        budget4_.amountRequested as amountRe3_4_2_,

        budget4_.bankAccount as bankAcc13_4_2_,

        budget4_.bankReceipt as bankRec14_4_2_,

        budget4_.beneficiarysignedcontract as benefic15_4_2_,

        budget4_.currency as currency4_4_2_,

        budget4_.date as date5_4_2_,

        budget4_.datePaid as datePaid6_4_2_,

        budget4_.enddate as enddate7_4_2_,

        budget4_.initialcontractfile as initial16_4_2_,

        budget4_.invoice as invoice17_4_2_,

        budget4_.organization as organiz18_4_2_,

        budget4_.otherCost as otherCos8_4_2_,

        budget4_.publisher as publish19_4_2_,

        budget4_.remaining as remainin9_4_2_,

        budget4_.signedcontract as signedc20_4_2_,

        budget4_.startdate as startda10_4_2_,

        budget4_.status as status11_4_2_,

        budget4_.transferCost as transfe12_4_2_,

        budget4_."user" as user21_4_2_,

        organizati5_.id as id1_16_3_,

        organizati5_.country as country5_16_3_,

        organizati5_.name as name2_16_3_,

        organizati5_.shortname as shortnam3_16_3_,

        organizati5_.source as source4_16_3_,

        country6_.id as id1_9_4_,

        country6_.name as name2_9_4_,

        publisher7_.id as id1_19_5_,

        publisher7_.apc as apc2_19_5_,

        publisher7_.apcCurrency as apcCurre3_19_5_,

        publisher7_.bankAccount as bankAcco8_19_5_,

        publisher7_.contact as contact9_19_5_,

        publisher7_.discount as discount4_19_5_,

        publisher7_.email as email5_19_5_,

        publisher7_.name as name6_19_5_,

        publisher7_.source as source7_19_5_,

        bankaccoun8_.id as id1_2_6_,

        bankaccoun8_.accountHolder as accountH2_2_6_,

        bankaccoun8_.bankAddress as bankAddr3_2_6_,

        bankaccoun8_.bankCode as bankCode4_2_6_,

        bankaccoun8_.bankName as bankName5_2_6_,

        bankaccoun8_.iban as iban6_2_6_,

        user9_.email as email1_22_7_,

        user9_.active as active2_22_7_,

        user9_.firstname as firstnam3_22_7_,

        user9_.id as id4_22_7_,

        user9_.initials as initials5_22_7_,

        user9_.lastname as lastname6_22_7_,

        user9_.orcidid as orcidid7_22_7_,

        user9_.password as password8_22_7_,

        user9_.source as source9_22_7_,

        user9_.telephone as telepho10_22_7_,

        user10_.email as email1_22_8_,

        user10_.active as active2_22_8_,

        user10_.firstname as firstnam3_22_8_,

        user10_.id as id4_22_8_,

        user10_.initials as initials5_22_8_,

        user10_.lastname as lastname6_22_8_,

        user10_.orcidid as orcidid7_22_8_,

        user10_.password as password8_22_8_,

        user10_.source as source9_22_8_,

        user10_.telephone as telepho10_22_8_,

        invoice11_.id as id1_13_9_,

        invoice11_.alternativeid as alternat2_13_9_,

        invoice11_.date as date3_13_9_,

        invoice11_.file as file7_13_9_,

        invoice11_.number as number4_13_9_,

        invoice11_.source as source5_13_9_,

        invoice11_.status as status6_13_9_,

        file12_.id as id1_10_10_,

        file12_.file as file2_10_10_,

        file12_.mimetype as mimetype3_10_10_,

        journal13_.id as id1_14_11_,

        journal13_.alttitle as alttitle2_14_11_,

        journal13_.apc as apc3_14_11_,

        journal13_.apccurrency as apccurre4_14_11_,

        journal13_.country as country15_14_11_,

        journal13_.discount as discount5_14_11_,

        journal13_.issn as issn6_14_11_,

        journal13_.languages as language7_14_11_,

        journal13_.licence as licence8_14_11_,

        journal13_.publisher as publish16_14_11_,

        journal13_.source as source9_14_11_,

        journal13_.status as status10_14_11_,

        journal13_.subjects as subject11_14_11_,

        journal13_.title as title12_14_11_,

        journal13_.type as type13_14_11_,

        journal13_.url as url14_14_11_,

        country14_.id as id1_9_12_,

        country14_.name as name2_9_12_,

        publisher15_.id as id1_19_13_,

        publisher15_.apc as apc2_19_13_,

        publisher15_.apcCurrency as apcCurre3_19_13_,

        publisher15_.bankAccount as bankAcco8_19_13_,

        publisher15_.contact as contact9_19_13_,

        publisher15_.discount as discount4_19_13_,

        publisher15_.email as email5_19_13_,

        publisher15_.name as name6_19_13_,

        publisher15_.source as source7_19_13_,

        organizati16_.id as id1_16_14_,

        organizati16_.country as country5_16_14_,

        organizati16_.name as name2_16_14_,

        organizati16_.shortname as shortnam3_16_14_,

        organizati16_.source as source4_16_14_,

        project17_.id as id1_17_15_,

        project17_.acronym as acronym2_17_15_,

        project17_.call as call3_17_15_,

        project17_.enddate as enddate4_17_15_,

        project17_.funder as funder5_17_15_,

        project17_.fundingstream as fundings6_17_15_,

        project17_."grant" as grant7_17_15_,

        project17_.sc39 as sc8_17_15_,

        project17_.scientificarea as scientif9_17_15_,

        project17_.source as source10_17_15_,

        project17_.startdate as startda11_17_15_,

        project17_.title as title12_17_15_,

        project17_.url as url13_17_15_,

        publicatio18_.id as id1_18_16_,

        publicatio18_.acceptancedate as acceptan2_18_16_,

        publicatio18_.alternativedoi as alternat3_18_16_,

        publicatio18_.alternativetitle as alternat4_18_16_,

        publicatio18_.date as date5_18_16_,

        publicatio18_.doi as doi6_18_16_,

        publicatio18_.eventdetails as eventdet7_18_16_,

        publicatio18_.journal as journal15_18_16_,

        publicatio18_.languages as language8_18_16_,

        publicatio18_.license as license9_18_16_,

        publicatio18_.publisher as publish16_18_16_,

        publicatio18_.repository as reposit10_18_16_,

        publicatio18_.source as source11_18_16_,

        publicatio18_.subjects as subject12_18_16_,

        publicatio18_.title as title13_18_16_,

        publicatio18_.type as type14_18_16_,

        journal19_.id as id1_14_17_,

        journal19_.alttitle as alttitle2_14_17_,

        journal19_.apc as apc3_14_17_,

        journal19_.apccurrency as apccurre4_14_17_,

        journal19_.country as country15_14_17_,

        journal19_.discount as discount5_14_17_,

        journal19_.issn as issn6_14_17_,

        journal19_.languages as language7_14_17_,

        journal19_.licence as licence8_14_17_,

        journal19_.publisher as publish16_14_17_,

        journal19_.source as source9_14_17_,

        journal19_.status as status10_14_17_,

        journal19_.subjects as subject11_14_17_,

        journal19_.title as title12_14_17_,

        journal19_.type as type13_14_17_,

        journal19_.url as url14_14_17_,

        publisher20_.id as id1_19_18_,

        publisher20_.apc as apc2_19_18_,

        publisher20_.apcCurrency as apcCurre3_19_18_,

        publisher20_.bankAccount as bankAcco8_19_18_,

        publisher20_.contact as contact9_19_18_,

        publisher20_.discount as discount4_19_18_,

        publisher20_.email as email5_19_18_,

        publisher20_.name as name6_19_18_,

        publisher20_.source as source7_19_18_,

        publisher21_.id as id1_19_19_,

        publisher21_.apc as apc2_19_19_,

        publisher21_.apcCurrency as apcCurre3_19_19_,

        publisher21_.bankAccount as bankAcco8_19_19_,

        publisher21_.contact as contact9_19_19_,

        publisher21_.discount as discount4_19_19_,

        publisher21_.email as email5_19_19_,

        publisher21_.name as name6_19_19_,

        publisher21_.source as source7_19_19_,

        user22_.email as email1_22_20_,

        user22_.active as active2_22_20_,

        user22_.firstname as firstnam3_22_20_,

        user22_.id as id4_22_20_,

        user22_.initials as initials5_22_20_,

        user22_.lastname as lastname6_22_20_,

        user22_.orcidid as orcidid7_22_20_,

        user22_.password as password8_22_20_,

        user22_.source as source9_22_20_,

        user22_.telephone as telepho10_22_20_,

        user23_.email as email1_22_21_,

        user23_.active as active2_22_21_,

        user23_.firstname as firstnam3_22_21_,

        user23_.id as id4_22_21_,

        user23_.initials as initials5_22_21_,

        user23_.lastname as lastname6_22_21_,

        user23_.orcidid as orcidid7_22_21_,

        user23_.password as password8_22_21_,

        user23_.source as source9_22_21_,

        user23_.telephone as telepho10_22_21_ 

    from

        Request this_ 

    left outer join

        BankAccount bankaccoun2_ 

            on this_.bankAccount=bankaccoun2_.id 

    left outer join

        BankTransferReceipt banktransf3_ 

            on this_.bankTransferReceipt=banktransf3_.id 

    left outer join

        Budget budget4_ 

            on this_.budget=budget4_.id 

    left outer join

        Organization organizati5_ 

            on budget4_.organization=organizati5_.id 

    left outer join

        Country country6_ 

            on organizati5_.country=country6_.id 

    left outer join

        Publisher publisher7_ 

            on budget4_.publisher=publisher7_.id 

    left outer join

        BankAccount bankaccoun8_ 

            on publisher7_.bankAccount=bankaccoun8_.id 

    left outer join

        "user" user9_ 

            on publisher7_.contact=user9_.email 

    left outer join

        "user" user10_ 

            on budget4_."user"=user10_.email 

    left outer join

        Invoice invoice11_ 

            on this_.invoice=invoice11_.id 

    left outer join

        File file12_ 

            on invoice11_.file=file12_.id 

    left outer join

        Journal journal13_ 

            on this_.journal=journal13_.id 

    left outer join

        Country country14_ 

            on journal13_.country=country14_.id 

    left outer join

        Publisher publisher15_ 

            on journal13_.publisher=publisher15_.id 

    left outer join

        Organization organizati16_ 

            on this_.organization=organizati16_.id 

    left outer join

        Project project17_ 

            on this_.project=project17_.id 

    left outer join

        Publication publicatio18_ 

            on this_.publication=publicatio18_.id 

    left outer join

        Journal journal19_ 

            on publicatio18_.journal=journal19_.id 

    left outer join

        Publisher publisher20_ 

            on publicatio18_.publisher=publisher20_.id 

    left outer join

        Publisher publisher21_ 

            on this_.publisher=publisher21_.id 

    left outer join

        "user" user22_ 

            on this_.researcher=user22_.email 

    left outer join

        "user" user23_ 

            on this_."user"=user23_.email 

    where

        this_.status in (

            ?, ?, ?, ?, ?

        )

Hibernate: 

    select

        distinct p1_.id as y0_ 

    from

        Request this_ 

    inner join

        Project p1_ 

            on this_.project=p1_.id 

    where

        this_.status in (

            ?, ?, ?, ?, ?

        )

Hibernate: 

    select

        sum(this_.apcPaid) as y0_ 

    from

        Request this_

Hibernate: 

    select

        avg(this_.apcPaid) as y0_ 

    from

        Request this_

Hibernate: 

    select

        this_.id as id1_20_22_,

        this_.apc as apc2_20_22_,

        this_.apcPaid as apcPaid3_20_22_,

        this_.approvaldate as approval4_20_22_,

        this_.bankAccount as bankAcc16_20_22_,

        this_.bankTransferReceipt as bankTra17_20_22_,

        this_.budget as budget18_20_22_,

        this_.currency as currency5_20_22_,

        this_.date as date6_20_22_,

        this_.datePaid as datePaid7_20_22_,

        this_.discount as discount8_20_22_,

        this_.fundingrequested as fundingr9_20_22_,

        this_.invoice as invoice19_20_22_,

        this_.journal as journal20_20_22_,

        this_.organization as organiz21_20_22_,

        this_.otherCost as otherCo10_20_22_,

        this_.project as project22_20_22_,

        this_.projectparticipation as project11_20_22_,

        this_.publication as publica23_20_22_,

        this_.publisher as publish24_20_22_,

        this_.publisher_email as publish12_20_22_,

        this_.researcher as researc25_20_22_,

        this_.status as status13_20_22_,

        this_.submissiondate as submiss14_20_22_,

        this_.transferCost as transfe15_20_22_,

        this_."user" as user26_20_22_,

        bankaccoun3_.id as id1_2_0_,

        bankaccoun3_.accountHolder as accountH2_2_0_,

        bankaccoun3_.bankAddress as bankAddr3_2_0_,

        bankaccoun3_.bankCode as bankCode4_2_0_,

        bankaccoun3_.bankName as bankName5_2_0_,

        bankaccoun3_.iban as iban6_2_0_,

        banktransf4_.id as id1_3_1_,

        banktransf4_.content as content2_3_1_,

        banktransf4_.contentType as contentT3_3_1_,

        budget5_.id as id1_4_2_,

        budget5_.amountGranted as amountGr2_4_2_,

        budget5_.amountRequested as amountRe3_4_2_,

        budget5_.bankAccount as bankAcc13_4_2_,

        budget5_.bankReceipt as bankRec14_4_2_,

        budget5_.beneficiarysignedcontract as benefic15_4_2_,

        budget5_.currency as currency4_4_2_,

        budget5_.date as date5_4_2_,

        budget5_.datePaid as datePaid6_4_2_,

        budget5_.enddate as enddate7_4_2_,

        budget5_.initialcontractfile as initial16_4_2_,

        budget5_.invoice as invoice17_4_2_,

        budget5_.organization as organiz18_4_2_,

        budget5_.otherCost as otherCos8_4_2_,

        budget5_.publisher as publish19_4_2_,

        budget5_.remaining as remainin9_4_2_,

        budget5_.signedcontract as signedc20_4_2_,

        budget5_.startdate as startda10_4_2_,

        budget5_.status as status11_4_2_,

        budget5_.transferCost as transfe12_4_2_,

        budget5_."user" as user21_4_2_,

        organizati6_.id as id1_16_3_,

        organizati6_.country as country5_16_3_,

        organizati6_.name as name2_16_3_,

        organizati6_.shortname as shortnam3_16_3_,

        organizati6_.source as source4_16_3_,

        country7_.id as id1_9_4_,

        country7_.name as name2_9_4_,

        publisher8_.id as id1_19_5_,

        publisher8_.apc as apc2_19_5_,

        publisher8_.apcCurrency as apcCurre3_19_5_,

        publisher8_.bankAccount as bankAcco8_19_5_,

        publisher8_.contact as contact9_19_5_,

        publisher8_.discount as discount4_19_5_,

        publisher8_.email as email5_19_5_,

        publisher8_.name as name6_19_5_,

        publisher8_.source as source7_19_5_,

        bankaccoun9_.id as id1_2_6_,

        bankaccoun9_.accountHolder as accountH2_2_6_,

        bankaccoun9_.bankAddress as bankAddr3_2_6_,

        bankaccoun9_.bankCode as bankCode4_2_6_,

        bankaccoun9_.bankName as bankName5_2_6_,

        bankaccoun9_.iban as iban6_2_6_,

        user10_.email as email1_22_7_,

        user10_.active as active2_22_7_,

        user10_.firstname as firstnam3_22_7_,

        user10_.id as id4_22_7_,

        user10_.initials as initials5_22_7_,

        user10_.lastname as lastname6_22_7_,

        user10_.orcidid as orcidid7_22_7_,

        user10_.password as password8_22_7_,

        user10_.source as source9_22_7_,

        user10_.telephone as telepho10_22_7_,

        user11_.email as email1_22_8_,

        user11_.active as active2_22_8_,

        user11_.firstname as firstnam3_22_8_,

        user11_.id as id4_22_8_,

        user11_.initials as initials5_22_8_,

        user11_.lastname as lastname6_22_8_,

        user11_.orcidid as orcidid7_22_8_,

        user11_.password as password8_22_8_,

        user11_.source as source9_22_8_,

        user11_.telephone as telepho10_22_8_,

        invoice12_.id as id1_13_9_,

        invoice12_.alternativeid as alternat2_13_9_,

        invoice12_.date as date3_13_9_,

        invoice12_.file as file7_13_9_,

        invoice12_.number as number4_13_9_,

        invoice12_.source as source5_13_9_,

        invoice12_.status as status6_13_9_,

        file13_.id as id1_10_10_,

        file13_.file as file2_10_10_,

        file13_.mimetype as mimetype3_10_10_,

        journal14_.id as id1_14_11_,

        journal14_.alttitle as alttitle2_14_11_,

        journal14_.apc as apc3_14_11_,

        journal14_.apccurrency as apccurre4_14_11_,

        journal14_.country as country15_14_11_,

        journal14_.discount as discount5_14_11_,

        journal14_.issn as issn6_14_11_,

        journal14_.languages as language7_14_11_,

        journal14_.licence as licence8_14_11_,

        journal14_.publisher as publish16_14_11_,

        journal14_.source as source9_14_11_,

        journal14_.status as status10_14_11_,

        journal14_.subjects as subject11_14_11_,

        journal14_.title as title12_14_11_,

        journal14_.type as type13_14_11_,

        journal14_.url as url14_14_11_,

        country15_.id as id1_9_12_,

        country15_.name as name2_9_12_,

        publisher16_.id as id1_19_13_,

        publisher16_.apc as apc2_19_13_,

        publisher16_.apcCurrency as apcCurre3_19_13_,

        publisher16_.bankAccount as bankAcco8_19_13_,

        publisher16_.contact as contact9_19_13_,

        publisher16_.discount as discount4_19_13_,

        publisher16_.email as email5_19_13_,

        publisher16_.name as name6_19_13_,

        publisher16_.source as source7_19_13_,

        organizati17_.id as id1_16_14_,

        organizati17_.country as country5_16_14_,

        organizati17_.name as name2_16_14_,

        organizati17_.shortname as shortnam3_16_14_,

        organizati17_.source as source4_16_14_,

        project18_.id as id1_17_15_,

        project18_.acronym as acronym2_17_15_,

        project18_.call as call3_17_15_,

        project18_.enddate as enddate4_17_15_,

        project18_.funder as funder5_17_15_,

        project18_.fundingstream as fundings6_17_15_,

        project18_."grant" as grant7_17_15_,

        project18_.sc39 as sc8_17_15_,

        project18_.scientificarea as scientif9_17_15_,

        project18_.source as source10_17_15_,

        project18_.startdate as startda11_17_15_,

        project18_.title as title12_17_15_,

        project18_.url as url13_17_15_,

        p1_.id as id1_18_16_,

        p1_.acceptancedate as acceptan2_18_16_,

        p1_.alternativedoi as alternat3_18_16_,

        p1_.alternativetitle as alternat4_18_16_,

        p1_.date as date5_18_16_,

        p1_.doi as doi6_18_16_,

        p1_.eventdetails as eventdet7_18_16_,

        p1_.journal as journal15_18_16_,

        p1_.languages as language8_18_16_,

        p1_.license as license9_18_16_,

        p1_.publisher as publish16_18_16_,

        p1_.repository as reposit10_18_16_,

        p1_.source as source11_18_16_,

        p1_.subjects as subject12_18_16_,

        p1_.title as title13_18_16_,

        p1_.type as type14_18_16_,

        journal20_.id as id1_14_17_,

        journal20_.alttitle as alttitle2_14_17_,

        journal20_.apc as apc3_14_17_,

        journal20_.apccurrency as apccurre4_14_17_,

        journal20_.country as country15_14_17_,

        journal20_.discount as discount5_14_17_,

        journal20_.issn as issn6_14_17_,

        journal20_.languages as language7_14_17_,

        journal20_.licence as licence8_14_17_,

        journal20_.publisher as publish16_14_17_,

        journal20_.source as source9_14_17_,

        journal20_.status as status10_14_17_,

        journal20_.subjects as subject11_14_17_,

        journal20_.title as title12_14_17_,

        journal20_.type as type13_14_17_,

        journal20_.url as url14_14_17_,

        publisher21_.id as id1_19_18_,

        publisher21_.apc as apc2_19_18_,

        publisher21_.apcCurrency as apcCurre3_19_18_,

        publisher21_.bankAccount as bankAcco8_19_18_,

        publisher21_.contact as contact9_19_18_,

        publisher21_.discount as discount4_19_18_,

        publisher21_.email as email5_19_18_,

        publisher21_.name as name6_19_18_,

        publisher21_.source as source7_19_18_,

        publisher22_.id as id1_19_19_,

        publisher22_.apc as apc2_19_19_,

        publisher22_.apcCurrency as apcCurre3_19_19_,

        publisher22_.bankAccount as bankAcco8_19_19_,

        publisher22_.contact as contact9_19_19_,

        publisher22_.discount as discount4_19_19_,

        publisher22_.email as email5_19_19_,

        publisher22_.name as name6_19_19_,

        publisher22_.source as source7_19_19_,

        user23_.email as email1_22_20_,

        user23_.active as active2_22_20_,

        user23_.firstname as firstnam3_22_20_,

        user23_.id as id4_22_20_,

        user23_.initials as initials5_22_20_,

        user23_.lastname as lastname6_22_20_,

        user23_.orcidid as orcidid7_22_20_,

        user23_.password as password8_22_20_,

        user23_.source as source9_22_20_,

        user23_.telephone as telepho10_22_20_,

        user24_.email as email1_22_21_,

        user24_.active as active2_22_21_,

        user24_.firstname as firstnam3_22_21_,

        user24_.id as id4_22_21_,

        user24_.initials as initials5_22_21_,

        user24_.lastname as lastname6_22_21_,

        user24_.orcidid as orcidid7_22_21_,

        user24_.password as password8_22_21_,

        user24_.source as source9_22_21_,

        user24_.telephone as telepho10_22_21_ 

    from

        Request this_ 

    left outer join

        BankAccount bankaccoun3_ 

            on this_.bankAccount=bankaccoun3_.id 

    left outer join

        BankTransferReceipt banktransf4_ 

            on this_.bankTransferReceipt=banktransf4_.id 

    left outer join

        Budget budget5_ 

            on this_.budget=budget5_.id 

    left outer join

        Organization organizati6_ 

            on budget5_.organization=organizati6_.id 

    left outer join

        Country country7_ 

            on organizati6_.country=country7_.id 

    left outer join

        Publisher publisher8_ 

            on budget5_.publisher=publisher8_.id 

    left outer join

        BankAccount bankaccoun9_ 

            on publisher8_.bankAccount=bankaccoun9_.id 

    left outer join

        "user" user10_ 

            on publisher8_.contact=user10_.email 

    left outer join

        "user" user11_ 

            on budget5_."user"=user11_.email 

    left outer join

        Invoice invoice12_ 

            on this_.invoice=invoice12_.id 

    left outer join

        File file13_ 

            on invoice12_.file=file13_.id 

    left outer join

        Journal journal14_ 

            on this_.journal=journal14_.id 

    left outer join

        Country country15_ 

            on journal14_.country=country15_.id 

    left outer join

        Publisher publisher16_ 

            on journal14_.publisher=publisher16_.id 

    left outer join

        Organization organizati17_ 

            on this_.organization=organizati17_.id 

    left outer join

        Project project18_ 

            on this_.project=project18_.id 

    inner join

        Publication p1_ 

            on this_.publication=p1_.id 

    left outer join

        Journal journal20_ 

            on p1_.journal=journal20_.id 

    left outer join

        Publisher publisher21_ 

            on p1_.publisher=publisher21_.id 

    left outer join

        Publisher publisher22_ 

            on this_.publisher=publisher22_.id 

    left outer join

        "user" user23_ 

            on this_.researcher=user23_.email 

    left outer join

        "user" user24_ 

            on this_."user"=user24_.email 

    where

        p1_.type=? 

        and this_.status=?

Hibernate: 

    select

        avg(this_.apcPaid) as y0_ 

    from

        Request this_ 

    inner join

        Publication p1_ 

            on this_.publication=p1_.id 

    where

        p1_.type=?

Hibernate: 

    select

        this_.id as id1_20_22_,

        this_.apc as apc2_20_22_,

        this_.apcPaid as apcPaid3_20_22_,

        this_.approvaldate as approval4_20_22_,

        this_.bankAccount as bankAcc16_20_22_,

        this_.bankTransferReceipt as bankTra17_20_22_,

        this_.budget as budget18_20_22_,

        this_.currency as currency5_20_22_,

        this_.date as date6_20_22_,

        this_.datePaid as datePaid7_20_22_,

        this_.discount as discount8_20_22_,

        this_.fundingrequested as fundingr9_20_22_,

        this_.invoice as invoice19_20_22_,

        this_.journal as journal20_20_22_,

        this_.organization as organiz21_20_22_,

        this_.otherCost as otherCo10_20_22_,

        this_.project as project22_20_22_,

        this_.projectparticipation as project11_20_22_,

        this_.publication as publica23_20_22_,

        this_.publisher as publish24_20_22_,

        this_.publisher_email as publish12_20_22_,

        this_.researcher as researc25_20_22_,

        this_.status as status13_20_22_,

        this_.submissiondate as submiss14_20_22_,

        this_.transferCost as transfe15_20_22_,

        this_."user" as user26_20_22_,

        bankaccoun3_.id as id1_2_0_,

        bankaccoun3_.accountHolder as accountH2_2_0_,

        bankaccoun3_.bankAddress as bankAddr3_2_0_,

        bankaccoun3_.bankCode as bankCode4_2_0_,

        bankaccoun3_.bankName as bankName5_2_0_,

        bankaccoun3_.iban as iban6_2_0_,

        banktransf4_.id as id1_3_1_,

        banktransf4_.content as content2_3_1_,

        banktransf4_.contentType as contentT3_3_1_,

        budget5_.id as id1_4_2_,

        budget5_.amountGranted as amountGr2_4_2_,

        budget5_.amountRequested as amountRe3_4_2_,

        budget5_.bankAccount as bankAcc13_4_2_,

        budget5_.bankReceipt as bankRec14_4_2_,

        budget5_.beneficiarysignedcontract as benefic15_4_2_,

        budget5_.currency as currency4_4_2_,

        budget5_.date as date5_4_2_,

        budget5_.datePaid as datePaid6_4_2_,

        budget5_.enddate as enddate7_4_2_,

        budget5_.initialcontractfile as initial16_4_2_,

        budget5_.invoice as invoice17_4_2_,

        budget5_.organization as organiz18_4_2_,

        budget5_.otherCost as otherCos8_4_2_,

        budget5_.publisher as publish19_4_2_,

        budget5_.remaining as remainin9_4_2_,

        budget5_.signedcontract as signedc20_4_2_,

        budget5_.startdate as startda10_4_2_,

        budget5_.status as status11_4_2_,

        budget5_.transferCost as transfe12_4_2_,

        budget5_."user" as user21_4_2_,

        organizati6_.id as id1_16_3_,

        organizati6_.country as country5_16_3_,

        organizati6_.name as name2_16_3_,

        organizati6_.shortname as shortnam3_16_3_,

        organizati6_.source as source4_16_3_,

        country7_.id as id1_9_4_,

        country7_.name as name2_9_4_,

        publisher8_.id as id1_19_5_,

        publisher8_.apc as apc2_19_5_,

        publisher8_.apcCurrency as apcCurre3_19_5_,

        publisher8_.bankAccount as bankAcco8_19_5_,

        publisher8_.contact as contact9_19_5_,

        publisher8_.discount as discount4_19_5_,

        publisher8_.email as email5_19_5_,

        publisher8_.name as name6_19_5_,

        publisher8_.source as source7_19_5_,

        bankaccoun9_.id as id1_2_6_,

        bankaccoun9_.accountHolder as accountH2_2_6_,

        bankaccoun9_.bankAddress as bankAddr3_2_6_,

        bankaccoun9_.bankCode as bankCode4_2_6_,

        bankaccoun9_.bankName as bankName5_2_6_,

        bankaccoun9_.iban as iban6_2_6_,

        user10_.email as email1_22_7_,

        user10_.active as active2_22_7_,

        user10_.firstname as firstnam3_22_7_,

        user10_.id as id4_22_7_,

        user10_.initials as initials5_22_7_,

        user10_.lastname as lastname6_22_7_,

        user10_.orcidid as orcidid7_22_7_,

        user10_.password as password8_22_7_,

        user10_.source as source9_22_7_,

        user10_.telephone as telepho10_22_7_,

        user11_.email as email1_22_8_,

        user11_.active as active2_22_8_,

        user11_.firstname as firstnam3_22_8_,

        user11_.id as id4_22_8_,

        user11_.initials as initials5_22_8_,

        user11_.lastname as lastname6_22_8_,

        user11_.orcidid as orcidid7_22_8_,

        user11_.password as password8_22_8_,

        user11_.source as source9_22_8_,

        user11_.telephone as telepho10_22_8_,

        invoice12_.id as id1_13_9_,

        invoice12_.alternativeid as alternat2_13_9_,

        invoice12_.date as date3_13_9_,

        invoice12_.file as file7_13_9_,

        invoice12_.number as number4_13_9_,

        invoice12_.source as source5_13_9_,

        invoice12_.status as status6_13_9_,

        file13_.id as id1_10_10_,

        file13_.file as file2_10_10_,

        file13_.mimetype as mimetype3_10_10_,

        journal14_.id as id1_14_11_,

        journal14_.alttitle as alttitle2_14_11_,

        journal14_.apc as apc3_14_11_,

        journal14_.apccurrency as apccurre4_14_11_,

        journal14_.country as country15_14_11_,

        journal14_.discount as discount5_14_11_,

        journal14_.issn as issn6_14_11_,

        journal14_.languages as language7_14_11_,

        journal14_.licence as licence8_14_11_,

        journal14_.publisher as publish16_14_11_,

        journal14_.source as source9_14_11_,

        journal14_.status as status10_14_11_,

        journal14_.subjects as subject11_14_11_,

        journal14_.title as title12_14_11_,

        journal14_.type as type13_14_11_,

        journal14_.url as url14_14_11_,

        country15_.id as id1_9_12_,

        country15_.name as name2_9_12_,

        publisher16_.id as id1_19_13_,

        publisher16_.apc as apc2_19_13_,

        publisher16_.apcCurrency as apcCurre3_19_13_,

        publisher16_.bankAccount as bankAcco8_19_13_,

        publisher16_.contact as contact9_19_13_,

        publisher16_.discount as discount4_19_13_,

        publisher16_.email as email5_19_13_,

        publisher16_.name as name6_19_13_,

        publisher16_.source as source7_19_13_,

        organizati17_.id as id1_16_14_,

        organizati17_.country as country5_16_14_,

        organizati17_.name as name2_16_14_,

        organizati17_.shortname as shortnam3_16_14_,

        organizati17_.source as source4_16_14_,

        project18_.id as id1_17_15_,

        project18_.acronym as acronym2_17_15_,

        project18_.call as call3_17_15_,

        project18_.enddate as enddate4_17_15_,

        project18_.funder as funder5_17_15_,

        project18_.fundingstream as fundings6_17_15_,

        project18_."grant" as grant7_17_15_,

        project18_.sc39 as sc8_17_15_,

        project18_.scientificarea as scientif9_17_15_,

        project18_.source as source10_17_15_,

        project18_.startdate as startda11_17_15_,

        project18_.title as title12_17_15_,

        project18_.url as url13_17_15_,

        p1_.id as id1_18_16_,

        p1_.acceptancedate as acceptan2_18_16_,

        p1_.alternativedoi as alternat3_18_16_,

        p1_.alternativetitle as alternat4_18_16_,

        p1_.date as date5_18_16_,

        p1_.doi as doi6_18_16_,

        p1_.eventdetails as eventdet7_18_16_,

        p1_.journal as journal15_18_16_,

        p1_.languages as language8_18_16_,

        p1_.license as license9_18_16_,

        p1_.publisher as publish16_18_16_,

        p1_.repository as reposit10_18_16_,

        p1_.source as source11_18_16_,

        p1_.subjects as subject12_18_16_,

        p1_.title as title13_18_16_,

        p1_.type as type14_18_16_,

        journal20_.id as id1_14_17_,

        journal20_.alttitle as alttitle2_14_17_,

        journal20_.apc as apc3_14_17_,

        journal20_.apccurrency as apccurre4_14_17_,

        journal20_.country as country15_14_17_,

        journal20_.discount as discount5_14_17_,

        journal20_.issn as issn6_14_17_,

        journal20_.languages as language7_14_17_,

        journal20_.licence as licence8_14_17_,

        journal20_.publisher as publish16_14_17_,

        journal20_.source as source9_14_17_,

        journal20_.status as status10_14_17_,

        journal20_.subjects as subject11_14_17_,

        journal20_.title as title12_14_17_,

        journal20_.type as type13_14_17_,

        journal20_.url as url14_14_17_,

        publisher21_.id as id1_19_18_,

        publisher21_.apc as apc2_19_18_,

        publisher21_.apcCurrency as apcCurre3_19_18_,

        publisher21_.bankAccount as bankAcco8_19_18_,

        publisher21_.contact as contact9_19_18_,

        publisher21_.discount as discount4_19_18_,

        publisher21_.email as email5_19_18_,

        publisher21_.name as name6_19_18_,

        publisher21_.source as source7_19_18_,

        publisher22_.id as id1_19_19_,

        publisher22_.apc as apc2_19_19_,

        publisher22_.apcCurrency as apcCurre3_19_19_,

        publisher22_.bankAccount as bankAcco8_19_19_,

        publisher22_.contact as contact9_19_19_,

        publisher22_.discount as discount4_19_19_,

        publisher22_.email as email5_19_19_,

        publisher22_.name as name6_19_19_,

        publisher22_.source as source7_19_19_,

        user23_.email as email1_22_20_,

        user23_.active as active2_22_20_,

        user23_.firstname as firstnam3_22_20_,

        user23_.id as id4_22_20_,

        user23_.initials as initials5_22_20_,

        user23_.lastname as lastname6_22_20_,

        user23_.orcidid as orcidid7_22_20_,

        user23_.password as password8_22_20_,

        user23_.source as source9_22_20_,

        user23_.telephone as telepho10_22_20_,

        user24_.email as email1_22_21_,

        user24_.active as active2_22_21_,

        user24_.firstname as firstnam3_22_21_,

        user24_.id as id4_22_21_,

        user24_.initials as initials5_22_21_,

        user24_.lastname as lastname6_22_21_,

        user24_.orcidid as orcidid7_22_21_,

        user24_.password as password8_22_21_,

        user24_.source as source9_22_21_,

        user24_.telephone as telepho10_22_21_ 

    from

        Request this_ 

    left outer join

        BankAccount bankaccoun3_ 

            on this_.bankAccount=bankaccoun3_.id 

    left outer join

        BankTransferReceipt banktransf4_ 

            on this_.bankTransferReceipt=banktransf4_.id 

    left outer join

        Budget budget5_ 

            on this_.budget=budget5_.id 

    left outer join

        Organization organizati6_ 

            on budget5_.organization=organizati6_.id 

    left outer join

        Country country7_ 

            on organizati6_.country=country7_.id 

    left outer join

        Publisher publisher8_ 

            on budget5_.publisher=publisher8_.id 

    left outer join

        BankAccount bankaccoun9_ 

            on publisher8_.bankAccount=bankaccoun9_.id 

    left outer join

        "user" user10_ 

            on publisher8_.contact=user10_.email 

    left outer join

        "user" user11_ 

            on budget5_."user"=user11_.email 

    left outer join

        Invoice invoice12_ 

            on this_.invoice=invoice12_.id 

    left outer join

        File file13_ 

            on invoice12_.file=file13_.id 

    left outer join

        Journal journal14_ 

            on this_.journal=journal14_.id 

    left outer join

        Country country15_ 

            on journal14_.country=country15_.id 

    left outer join

        Publisher publisher16_ 

            on journal14_.publisher=publisher16_.id 

    left outer join

        Organization organizati17_ 

            on this_.organization=organizati17_.id 

    left outer join

        Project project18_ 

            on this_.project=project18_.id 

    inner join

        Publication p1_ 

            on this_.publication=p1_.id 

    left outer join

        Journal journal20_ 

            on p1_.journal=journal20_.id 

    left outer join

        Publisher publisher21_ 

            on p1_.publisher=publisher21_.id 

    left outer join

        Publisher publisher22_ 

            on this_.publisher=publisher22_.id 

    left outer join

        "user" user23_ 

            on this_.researcher=user23_.email 

    left outer join

        "user" user24_ 

            on this_."user"=user24_.email 

    where

        p1_.type=? 

        and this_.status=?

Hibernate: 

    select

        avg(this_.apcPaid) as y0_ 

    from

        Request this_ 

    inner join

        Publication p1_ 

            on this_.publication=p1_.id 

    where

        p1_.type=?

Hibernate: 

    select

        avg(this_.apcPaid) as y0_ 

    from

        Request this_ 

    inner join

        Publication p1_ 

            on this_.publication=p1_.id 

    where

        p1_.type=?

Hibernate: 

    select

        this_.id as id1_20_22_,

        this_.apc as apc2_20_22_,

        this_.apcPaid as apcPaid3_20_22_,

        this_.approvaldate as approval4_20_22_,

        this_.bankAccount as bankAcc16_20_22_,

        this_.bankTransferReceipt as bankTra17_20_22_,

        this_.budget as budget18_20_22_,

        this_.currency as currency5_20_22_,

        this_.date as date6_20_22_,

        this_.datePaid as datePaid7_20_22_,

        this_.discount as discount8_20_22_,

        this_.fundingrequested as fundingr9_20_22_,

        this_.invoice as invoice19_20_22_,

        this_.journal as journal20_20_22_,

        this_.organization as organiz21_20_22_,

        this_.otherCost as otherCo10_20_22_,

        this_.project as project22_20_22_,

        this_.projectparticipation as project11_20_22_,

        this_.publication as publica23_20_22_,

        this_.publisher as publish24_20_22_,

        this_.publisher_email as publish12_20_22_,

        this_.researcher as researc25_20_22_,

        this_.status as status13_20_22_,

        this_.submissiondate as submiss14_20_22_,

        this_.transferCost as transfe15_20_22_,

        this_."user" as user26_20_22_,

        bankaccoun2_.id as id1_2_0_,

        bankaccoun2_.accountHolder as accountH2_2_0_,

        bankaccoun2_.bankAddress as bankAddr3_2_0_,

        bankaccoun2_.bankCode as bankCode4_2_0_,

        bankaccoun2_.bankName as bankName5_2_0_,

        bankaccoun2_.iban as iban6_2_0_,

        banktransf3_.id as id1_3_1_,

        banktransf3_.content as content2_3_1_,

        banktransf3_.contentType as contentT3_3_1_,

        budget4_.id as id1_4_2_,

        budget4_.amountGranted as amountGr2_4_2_,

        budget4_.amountRequested as amountRe3_4_2_,

        budget4_.bankAccount as bankAcc13_4_2_,

        budget4_.bankReceipt as bankRec14_4_2_,

        budget4_.beneficiarysignedcontract as benefic15_4_2_,

        budget4_.currency as currency4_4_2_,

        budget4_.date as date5_4_2_,

        budget4_.datePaid as datePaid6_4_2_,

        budget4_.enddate as enddate7_4_2_,

        budget4_.initialcontractfile as initial16_4_2_,

        budget4_.invoice as invoice17_4_2_,

        budget4_.organization as organiz18_4_2_,

        budget4_.otherCost as otherCos8_4_2_,

        budget4_.publisher as publish19_4_2_,

        budget4_.remaining as remainin9_4_2_,

        budget4_.signedcontract as signedc20_4_2_,

        budget4_.startdate as startda10_4_2_,

        budget4_.status as status11_4_2_,

        budget4_.transferCost as transfe12_4_2_,

        budget4_."user" as user21_4_2_,

        organizati5_.id as id1_16_3_,

        organizati5_.country as country5_16_3_,

        organizati5_.name as name2_16_3_,

        organizati5_.shortname as shortnam3_16_3_,

        organizati5_.source as source4_16_3_,

        country6_.id as id1_9_4_,

        country6_.name as name2_9_4_,

        publisher7_.id as id1_19_5_,

        publisher7_.apc as apc2_19_5_,

        publisher7_.apcCurrency as apcCurre3_19_5_,

        publisher7_.bankAccount as bankAcco8_19_5_,

        publisher7_.contact as contact9_19_5_,

        publisher7_.discount as discount4_19_5_,

        publisher7_.email as email5_19_5_,

        publisher7_.name as name6_19_5_,

        publisher7_.source as source7_19_5_,

        bankaccoun8_.id as id1_2_6_,

        bankaccoun8_.accountHolder as accountH2_2_6_,

        bankaccoun8_.bankAddress as bankAddr3_2_6_,

        bankaccoun8_.bankCode as bankCode4_2_6_,

        bankaccoun8_.bankName as bankName5_2_6_,

        bankaccoun8_.iban as iban6_2_6_,

        user9_.email as email1_22_7_,

        user9_.active as active2_22_7_,

        user9_.firstname as firstnam3_22_7_,

        user9_.id as id4_22_7_,

        user9_.initials as initials5_22_7_,

        user9_.lastname as lastname6_22_7_,

        user9_.orcidid as orcidid7_22_7_,

        user9_.password as password8_22_7_,

        user9_.source as source9_22_7_,

        user9_.telephone as telepho10_22_7_,

        user10_.email as email1_22_8_,

        user10_.active as active2_22_8_,

        user10_.firstname as firstnam3_22_8_,

        user10_.id as id4_22_8_,

        user10_.initials as initials5_22_8_,

        user10_.lastname as lastname6_22_8_,

        user10_.orcidid as orcidid7_22_8_,

        user10_.password as password8_22_8_,

        user10_.source as source9_22_8_,

        user10_.telephone as telepho10_22_8_,

        invoice11_.id as id1_13_9_,

        invoice11_.alternativeid as alternat2_13_9_,

        invoice11_.date as date3_13_9_,

        invoice11_.file as file7_13_9_,

        invoice11_.number as number4_13_9_,

        invoice11_.source as source5_13_9_,

        invoice11_.status as status6_13_9_,

        file12_.id as id1_10_10_,

        file12_.file as file2_10_10_,

        file12_.mimetype as mimetype3_10_10_,

        journal13_.id as id1_14_11_,

        journal13_.alttitle as alttitle2_14_11_,

        journal13_.apc as apc3_14_11_,

        journal13_.apccurrency as apccurre4_14_11_,

        journal13_.country as country15_14_11_,

        journal13_.discount as discount5_14_11_,

        journal13_.issn as issn6_14_11_,

        journal13_.languages as language7_14_11_,

        journal13_.licence as licence8_14_11_,

        journal13_.publisher as publish16_14_11_,

        journal13_.source as source9_14_11_,

        journal13_.status as status10_14_11_,

        journal13_.subjects as subject11_14_11_,

        journal13_.title as title12_14_11_,

        journal13_.type as type13_14_11_,

        journal13_.url as url14_14_11_,

        country14_.id as id1_9_12_,

        country14_.name as name2_9_12_,

        publisher15_.id as id1_19_13_,

        publisher15_.apc as apc2_19_13_,

        publisher15_.apcCurrency as apcCurre3_19_13_,

        publisher15_.bankAccount as bankAcco8_19_13_,

        publisher15_.contact as contact9_19_13_,

        publisher15_.discount as discount4_19_13_,

        publisher15_.email as email5_19_13_,

        publisher15_.name as name6_19_13_,

        publisher15_.source as source7_19_13_,

        organizati16_.id as id1_16_14_,

        organizati16_.country as country5_16_14_,

        organizati16_.name as name2_16_14_,

        organizati16_.shortname as shortnam3_16_14_,

        organizati16_.source as source4_16_14_,

        project17_.id as id1_17_15_,

        project17_.acronym as acronym2_17_15_,

        project17_.call as call3_17_15_,

        project17_.enddate as enddate4_17_15_,

        project17_.funder as funder5_17_15_,

        project17_.fundingstream as fundings6_17_15_,

        project17_."grant" as grant7_17_15_,

        project17_.sc39 as sc8_17_15_,

        project17_.scientificarea as scientif9_17_15_,

        project17_.source as source10_17_15_,

        project17_.startdate as startda11_17_15_,

        project17_.title as title12_17_15_,

        project17_.url as url13_17_15_,

        publicatio18_.id as id1_18_16_,

        publicatio18_.acceptancedate as acceptan2_18_16_,

        publicatio18_.alternativedoi as alternat3_18_16_,

        publicatio18_.alternativetitle as alternat4_18_16_,

        publicatio18_.date as date5_18_16_,

        publicatio18_.doi as doi6_18_16_,

        publicatio18_.eventdetails as eventdet7_18_16_,

        publicatio18_.journal as journal15_18_16_,

        publicatio18_.languages as language8_18_16_,

        publicatio18_.license as license9_18_16_,

        publicatio18_.publisher as publish16_18_16_,

        publicatio18_.repository as reposit10_18_16_,

        publicatio18_.source as source11_18_16_,

        publicatio18_.subjects as subject12_18_16_,

        publicatio18_.title as title13_18_16_,

        publicatio18_.type as type14_18_16_,

        journal19_.id as id1_14_17_,

        journal19_.alttitle as alttitle2_14_17_,

        journal19_.apc as apc3_14_17_,

        journal19_.apccurrency as apccurre4_14_17_,

        journal19_.country as country15_14_17_,

        journal19_.discount as discount5_14_17_,

        journal19_.issn as issn6_14_17_,

        journal19_.languages as language7_14_17_,

        journal19_.licence as licence8_14_17_,

        journal19_.publisher as publish16_14_17_,

        journal19_.source as source9_14_17_,

        journal19_.status as status10_14_17_,

        journal19_.subjects as subject11_14_17_,

        journal19_.title as title12_14_17_,

        journal19_.type as type13_14_17_,

        journal19_.url as url14_14_17_,

        publisher20_.id as id1_19_18_,

        publisher20_.apc as apc2_19_18_,

        publisher20_.apcCurrency as apcCurre3_19_18_,

        publisher20_.bankAccount as bankAcco8_19_18_,

        publisher20_.contact as contact9_19_18_,

        publisher20_.discount as discount4_19_18_,

        publisher20_.email as email5_19_18_,

        publisher20_.name as name6_19_18_,

        publisher20_.source as source7_19_18_,

        publisher21_.id as id1_19_19_,

        publisher21_.apc as apc2_19_19_,

        publisher21_.apcCurrency as apcCurre3_19_19_,

        publisher21_.bankAccount as bankAcco8_19_19_,

        publisher21_.contact as contact9_19_19_,

        publisher21_.discount as discount4_19_19_,

        publisher21_.email as email5_19_19_,

        publisher21_.name as name6_19_19_,

        publisher21_.source as source7_19_19_,

        user22_.email as email1_22_20_,

        user22_.active as active2_22_20_,

        user22_.firstname as firstnam3_22_20_,

        user22_.id as id4_22_20_,

        user22_.initials as initials5_22_20_,

        user22_.lastname as lastname6_22_20_,

        user22_.orcidid as orcidid7_22_20_,

        user22_.password as password8_22_20_,

        user22_.source as source9_22_20_,

        user22_.telephone as telepho10_22_20_,

        user23_.email as email1_22_21_,

        user23_.active as active2_22_21_,

        user23_.firstname as firstnam3_22_21_,

        user23_.id as id4_22_21_,

        user23_.initials as initials5_22_21_,

        user23_.lastname as lastname6_22_21_,

        user23_.orcidid as orcidid7_22_21_,

        user23_.password as password8_22_21_,

        user23_.source as source9_22_21_,

        user23_.telephone as telepho10_22_21_ 

    from

        Request this_ 

    left outer join

        BankAccount bankaccoun2_ 

            on this_.bankAccount=bankaccoun2_.id 

    left outer join

        BankTransferReceipt banktransf3_ 

            on this_.bankTransferReceipt=banktransf3_.id 

    left outer join

        Budget budget4_ 

            on this_.budget=budget4_.id 

    left outer join

        Organization organizati5_ 

            on budget4_.organization=organizati5_.id 

    left outer join

        Country country6_ 

            on organizati5_.country=country6_.id 

    left outer join

        Publisher publisher7_ 

            on budget4_.publisher=publisher7_.id 

    left outer join

        BankAccount bankaccoun8_ 

            on publisher7_.bankAccount=bankaccoun8_.id 

    left outer join

        "user" user9_ 

            on publisher7_.contact=user9_.email 

    left outer join

        "user" user10_ 

            on budget4_."user"=user10_.email 

    left outer join

        Invoice invoice11_ 

            on this_.invoice=invoice11_.id 

    left outer join

        File file12_ 

            on invoice11_.file=file12_.id 

    left outer join

        Journal journal13_ 

            on this_.journal=journal13_.id 

    left outer join

        Country country14_ 

            on journal13_.country=country14_.id 

    left outer join

        Publisher publisher15_ 

            on journal13_.publisher=publisher15_.id 

    left outer join

        Organization organizati16_ 

            on this_.organization=organizati16_.id 

    left outer join

        Project project17_ 

            on this_.project=project17_.id 

    left outer join

        Publication publicatio18_ 

            on this_.publication=publicatio18_.id 

    left outer join

        Journal journal19_ 

            on publicatio18_.journal=journal19_.id 

    left outer join

        Publisher publisher20_ 

            on publicatio18_.publisher=publisher20_.id 

    left outer join

        Publisher publisher21_ 

            on this_.publisher=publisher21_.id 

    left outer join

        "user" user22_ 

            on this_.researcher=user22_.email 

    left outer join

        "user" user23_ 

            on this_."user"=user23_.email 

    where

        this_.status in (

            ?, ?, ?, ?, ?

        )

Hibernate: 

    select

        this_.id as id1_20_22_,

        this_.apc as apc2_20_22_,

        this_.apcPaid as apcPaid3_20_22_,

        this_.approvaldate as approval4_20_22_,

        this_.bankAccount as bankAcc16_20_22_,

        this_.bankTransferReceipt as bankTra17_20_22_,

        this_.budget as budget18_20_22_,

        this_.currency as currency5_20_22_,

        this_.date as date6_20_22_,

        this_.datePaid as datePaid7_20_22_,

        this_.discount as discount8_20_22_,

        this_.fundingrequested as fundingr9_20_22_,

        this_.invoice as invoice19_20_22_,

        this_.journal as journal20_20_22_,

        this_.organization as organiz21_20_22_,

        this_.otherCost as otherCo10_20_22_,

        this_.project as project22_20_22_,

        this_.projectparticipation as project11_20_22_,

        this_.publication as publica23_20_22_,

        this_.publisher as publish24_20_22_,

        this_.publisher_email as publish12_20_22_,

        this_.researcher as researc25_20_22_,

        this_.status as status13_20_22_,

        this_.submissiondate as submiss14_20_22_,

        this_.transferCost as transfe15_20_22_,

        this_."user" as user26_20_22_,

        bankaccoun3_.id as id1_2_0_,

        bankaccoun3_.accountHolder as accountH2_2_0_,

        bankaccoun3_.bankAddress as bankAddr3_2_0_,

        bankaccoun3_.bankCode as bankCode4_2_0_,

        bankaccoun3_.bankName as bankName5_2_0_,

        bankaccoun3_.iban as iban6_2_0_,

        banktransf4_.id as id1_3_1_,

        banktransf4_.content as content2_3_1_,

        banktransf4_.contentType as contentT3_3_1_,

        budget5_.id as id1_4_2_,

        budget5_.amountGranted as amountGr2_4_2_,

        budget5_.amountRequested as amountRe3_4_2_,

        budget5_.bankAccount as bankAcc13_4_2_,

        budget5_.bankReceipt as bankRec14_4_2_,

        budget5_.beneficiarysignedcontract as benefic15_4_2_,

        budget5_.currency as currency4_4_2_,

        budget5_.date as date5_4_2_,

        budget5_.datePaid as datePaid6_4_2_,

        budget5_.enddate as enddate7_4_2_,

        budget5_.initialcontractfile as initial16_4_2_,

        budget5_.invoice as invoice17_4_2_,

        budget5_.organization as organiz18_4_2_,

        budget5_.otherCost as otherCos8_4_2_,

        budget5_.publisher as publish19_4_2_,

        budget5_.remaining as remainin9_4_2_,

        budget5_.signedcontract as signedc20_4_2_,

        budget5_.startdate as startda10_4_2_,

        budget5_.status as status11_4_2_,

        budget5_.transferCost as transfe12_4_2_,

        budget5_."user" as user21_4_2_,

        organizati6_.id as id1_16_3_,

        organizati6_.country as country5_16_3_,

        organizati6_.name as name2_16_3_,

        organizati6_.shortname as shortnam3_16_3_,

        organizati6_.source as source4_16_3_,

        country7_.id as id1_9_4_,

        country7_.name as name2_9_4_,

        publisher8_.id as id1_19_5_,

        publisher8_.apc as apc2_19_5_,

        publisher8_.apcCurrency as apcCurre3_19_5_,

        publisher8_.bankAccount as bankAcco8_19_5_,

        publisher8_.contact as contact9_19_5_,

        publisher8_.discount as discount4_19_5_,

        publisher8_.email as email5_19_5_,

        publisher8_.name as name6_19_5_,

        publisher8_.source as source7_19_5_,

        bankaccoun9_.id as id1_2_6_,

        bankaccoun9_.accountHolder as accountH2_2_6_,

        bankaccoun9_.bankAddress as bankAddr3_2_6_,

        bankaccoun9_.bankCode as bankCode4_2_6_,

        bankaccoun9_.bankName as bankName5_2_6_,

        bankaccoun9_.iban as iban6_2_6_,

        user10_.email as email1_22_7_,

        user10_.active as active2_22_7_,

        user10_.firstname as firstnam3_22_7_,

        user10_.id as id4_22_7_,

        user10_.initials as initials5_22_7_,

        user10_.lastname as lastname6_22_7_,

        user10_.orcidid as orcidid7_22_7_,

        user10_.password as password8_22_7_,

        user10_.source as source9_22_7_,

        user10_.telephone as telepho10_22_7_,

        user11_.email as email1_22_8_,

        user11_.active as active2_22_8_,

        user11_.firstname as firstnam3_22_8_,

        user11_.id as id4_22_8_,

        user11_.initials as initials5_22_8_,

        user11_.lastname as lastname6_22_8_,

        user11_.orcidid as orcidid7_22_8_,

        user11_.password as password8_22_8_,

        user11_.source as source9_22_8_,

        user11_.telephone as telepho10_22_8_,

        invoice12_.id as id1_13_9_,

        invoice12_.alternativeid as alternat2_13_9_,

        invoice12_.date as date3_13_9_,

        invoice12_.file as file7_13_9_,

        invoice12_.number as number4_13_9_,

        invoice12_.source as source5_13_9_,

        invoice12_.status as status6_13_9_,

        file13_.id as id1_10_10_,

        file13_.file as file2_10_10_,

        file13_.mimetype as mimetype3_10_10_,

        journal14_.id as id1_14_11_,

        journal14_.alttitle as alttitle2_14_11_,

        journal14_.apc as apc3_14_11_,

        journal14_.apccurrency as apccurre4_14_11_,

        journal14_.country as country15_14_11_,

        journal14_.discount as discount5_14_11_,

        journal14_.issn as issn6_14_11_,

        journal14_.languages as language7_14_11_,

        journal14_.licence as licence8_14_11_,

        journal14_.publisher as publish16_14_11_,

        journal14_.source as source9_14_11_,

        journal14_.status as status10_14_11_,

        journal14_.subjects as subject11_14_11_,

        journal14_.title as title12_14_11_,

        journal14_.type as type13_14_11_,

        journal14_.url as url14_14_11_,

        country15_.id as id1_9_12_,

        country15_.name as name2_9_12_,

        publisher16_.id as id1_19_13_,

        publisher16_.apc as apc2_19_13_,

        publisher16_.apcCurrency as apcCurre3_19_13_,

        publisher16_.bankAccount as bankAcco8_19_13_,

        publisher16_.contact as contact9_19_13_,

        publisher16_.discount as discount4_19_13_,

        publisher16_.email as email5_19_13_,

        publisher16_.name as name6_19_13_,

        publisher16_.source as source7_19_13_,

        organizati17_.id as id1_16_14_,

        organizati17_.country as country5_16_14_,

        organizati17_.name as name2_16_14_,

        organizati17_.shortname as shortnam3_16_14_,

        organizati17_.source as source4_16_14_,

        project18_.id as id1_17_15_,

        project18_.acronym as acronym2_17_15_,

        project18_.call as call3_17_15_,

        project18_.enddate as enddate4_17_15_,

        project18_.funder as funder5_17_15_,

        project18_.fundingstream as fundings6_17_15_,

        project18_."grant" as grant7_17_15_,

        project18_.sc39 as sc8_17_15_,

        project18_.scientificarea as scientif9_17_15_,

        project18_.source as source10_17_15_,

        project18_.startdate as startda11_17_15_,

        project18_.title as title12_17_15_,

        project18_.url as url13_17_15_,

        p1_.id as id1_18_16_,

        p1_.acceptancedate as acceptan2_18_16_,

        p1_.alternativedoi as alternat3_18_16_,

        p1_.alternativetitle as alternat4_18_16_,

        p1_.date as date5_18_16_,

        p1_.doi as doi6_18_16_,

        p1_.eventdetails as eventdet7_18_16_,

        p1_.journal as journal15_18_16_,

        p1_.languages as language8_18_16_,

        p1_.license as license9_18_16_,

        p1_.publisher as publish16_18_16_,

        p1_.repository as reposit10_18_16_,

        p1_.source as source11_18_16_,

        p1_.subjects as subject12_18_16_,

        p1_.title as title13_18_16_,

        p1_.type as type14_18_16_,

        journal20_.id as id1_14_17_,

        journal20_.alttitle as alttitle2_14_17_,

        journal20_.apc as apc3_14_17_,

        journal20_.apccurrency as apccurre4_14_17_,

        journal20_.country as country15_14_17_,

        journal20_.discount as discount5_14_17_,

        journal20_.issn as issn6_14_17_,

        journal20_.languages as language7_14_17_,

        journal20_.licence as licence8_14_17_,

        journal20_.publisher as publish16_14_17_,

        journal20_.source as source9_14_17_,

        journal20_.status as status10_14_17_,

        journal20_.subjects as subject11_14_17_,

        journal20_.title as title12_14_17_,

        journal20_.type as type13_14_17_,

        journal20_.url as url14_14_17_,

        publisher21_.id as id1_19_18_,

        publisher21_.apc as apc2_19_18_,

        publisher21_.apcCurrency as apcCurre3_19_18_,

        publisher21_.bankAccount as bankAcco8_19_18_,

        publisher21_.contact as contact9_19_18_,

        publisher21_.discount as discount4_19_18_,

        publisher21_.email as email5_19_18_,

        publisher21_.name as name6_19_18_,

        publisher21_.source as source7_19_18_,

        publisher22_.id as id1_19_19_,

        publisher22_.apc as apc2_19_19_,

        publisher22_.apcCurrency as apcCurre3_19_19_,

        publisher22_.bankAccount as bankAcco8_19_19_,

        publisher22_.contact as contact9_19_19_,

        publisher22_.discount as discount4_19_19_,

        publisher22_.email as email5_19_19_,

        publisher22_.name as name6_19_19_,

        publisher22_.source as source7_19_19_,

        user23_.email as email1_22_20_,

        user23_.active as active2_22_20_,

        user23_.firstname as firstnam3_22_20_,

        user23_.id as id4_22_20_,

        user23_.initials as initials5_22_20_,

        user23_.lastname as lastname6_22_20_,

        user23_.orcidid as orcidid7_22_20_,

        user23_.password as password8_22_20_,

        user23_.source as source9_22_20_,

        user23_.telephone as telepho10_22_20_,

        user24_.email as email1_22_21_,

        user24_.active as active2_22_21_,

        user24_.firstname as firstnam3_22_21_,

        user24_.id as id4_22_21_,

        user24_.initials as initials5_22_21_,

        user24_.lastname as lastname6_22_21_,

        user24_.orcidid as orcidid7_22_21_,

        user24_.password as password8_22_21_,

        user24_.source as source9_22_21_,

        user24_.telephone as telepho10_22_21_ 

    from

        Request this_ 

    left outer join

        BankAccount bankaccoun3_ 

            on this_.bankAccount=bankaccoun3_.id 

    left outer join

        BankTransferReceipt banktransf4_ 

            on this_.bankTransferReceipt=banktransf4_.id 

    left outer join

        Budget budget5_ 

            on this_.budget=budget5_.id 

    left outer join

        Organization organizati6_ 

            on budget5_.organization=organizati6_.id 

    left outer join

        Country country7_ 

            on organizati6_.country=country7_.id 

    left outer join

        Publisher publisher8_ 

            on budget5_.publisher=publisher8_.id 

    left outer join

        BankAccount bankaccoun9_ 

            on publisher8_.bankAccount=bankaccoun9_.id 

    left outer join

        "user" user10_