1 |
46308
|
panagiotis
|
Hibernate:
|
2 |
|
|
select
|
3 |
|
|
o.id as id,
|
4 |
|
|
case
|
5 |
|
|
when o.shortname is not null then o.shortname
|
6 |
|
|
else o.name
|
7 |
|
|
end as category,
|
8 |
|
|
count(r.id) as count
|
9 |
|
|
from
|
10 |
|
|
request r
|
11 |
|
|
join
|
12 |
|
|
organization o
|
13 |
|
|
on o.id=r.organization
|
14 |
|
|
group by
|
15 |
|
|
o.shortname,
|
16 |
|
|
o.name,
|
17 |
|
|
o.id
|
18 |
|
|
order by
|
19 |
|
|
category
|
20 |
|
|
Hibernate:
|
21 |
|
|
select
|
22 |
|
|
distinct p.scientificarea as id,
|
23 |
|
|
p.scientificarea as category,
|
24 |
|
|
count(r.id) as count
|
25 |
|
|
from
|
26 |
|
|
request r
|
27 |
|
|
join
|
28 |
|
|
project p
|
29 |
|
|
on r.project=p.id
|
30 |
|
|
group by
|
31 |
|
|
p.scientificarea
|
32 |
|
|
order by
|
33 |
|
|
category
|
34 |
|
|
Hibernate:
|
35 |
|
|
select
|
36 |
|
|
p.id as id,
|
37 |
|
|
p.name as category,
|
38 |
|
|
count(r.id) as count
|
39 |
|
|
from
|
40 |
|
|
(select
|
41 |
|
|
r.id,
|
42 |
|
|
r.status,
|
43 |
|
|
j.publisher,
|
44 |
|
|
'j'
|
45 |
|
|
from
|
46 |
|
|
request r
|
47 |
|
|
join
|
48 |
|
|
journal j
|
49 |
|
|
on r.journal=j.id
|
50 |
|
|
where
|
51 |
|
|
j.publisher is not null
|
52 |
|
|
union
|
53 |
|
|
select
|
54 |
|
|
r.id,
|
55 |
|
|
r.status,
|
56 |
|
|
p.id,
|
57 |
|
|
'p'
|
58 |
|
|
from
|
59 |
|
|
request r
|
60 |
|
|
join
|
61 |
|
|
publisher p
|
62 |
|
|
on r.publisher=p.id
|
63 |
|
|
) as r
|
64 |
|
|
join
|
65 |
|
|
publisher p
|
66 |
|
|
on r.publisher=p.id
|
67 |
|
|
group by
|
68 |
|
|
p.name,
|
69 |
|
|
p.id
|
70 |
|
|
order by
|
71 |
|
|
category
|
72 |
|
|
Hibernate:
|
73 |
|
|
select
|
74 |
|
|
c.id as id,
|
75 |
|
|
c.name as category,
|
76 |
|
|
count(r.id) as count
|
77 |
|
|
from
|
78 |
|
|
request r
|
79 |
|
|
join
|
80 |
|
|
organization o
|
81 |
|
|
on r.organization=o.id
|
82 |
|
|
join
|
83 |
|
|
country c
|
84 |
|
|
on c.id=o.country
|
85 |
|
|
group by
|
86 |
|
|
c.name,
|
87 |
|
|
c.id
|
88 |
|
|
order by
|
89 |
|
|
category
|
90 |
|
|
Hibernate:
|
91 |
|
|
select
|
92 |
46350
|
panagiotis
|
this_.id as id1_20_22_,
|
93 |
|
|
this_.apc as apc2_20_22_,
|
94 |
|
|
this_.apcPaid as apcPaid3_20_22_,
|
95 |
|
|
this_.approvaldate as approval4_20_22_,
|
96 |
|
|
this_.bankAccount as bankAcc16_20_22_,
|
97 |
|
|
this_.bankTransferReceipt as bankTra17_20_22_,
|
98 |
|
|
this_.budget as budget18_20_22_,
|
99 |
|
|
this_.currency as currency5_20_22_,
|
100 |
|
|
this_.date as date6_20_22_,
|
101 |
|
|
this_.datePaid as datePaid7_20_22_,
|
102 |
|
|
this_.discount as discount8_20_22_,
|
103 |
|
|
this_.fundingrequested as fundingr9_20_22_,
|
104 |
|
|
this_.invoice as invoice19_20_22_,
|
105 |
|
|
this_.journal as journal20_20_22_,
|
106 |
|
|
this_.organization as organiz21_20_22_,
|
107 |
|
|
this_.otherCost as otherCo10_20_22_,
|
108 |
|
|
this_.project as project22_20_22_,
|
109 |
|
|
this_.projectparticipation as project11_20_22_,
|
110 |
|
|
this_.publication as publica23_20_22_,
|
111 |
|
|
this_.publisher as publish24_20_22_,
|
112 |
|
|
this_.publisher_email as publish12_20_22_,
|
113 |
|
|
this_.researcher as researc25_20_22_,
|
114 |
|
|
this_.status as status13_20_22_,
|
115 |
|
|
this_.submissiondate as submiss14_20_22_,
|
116 |
|
|
this_.transferCost as transfe15_20_22_,
|
117 |
|
|
this_."user" as user26_20_22_,
|
118 |
46308
|
panagiotis
|
bankaccoun2_.id as id1_2_0_,
|
119 |
|
|
bankaccoun2_.accountHolder as accountH2_2_0_,
|
120 |
|
|
bankaccoun2_.bankAddress as bankAddr3_2_0_,
|
121 |
|
|
bankaccoun2_.bankCode as bankCode4_2_0_,
|
122 |
|
|
bankaccoun2_.bankName as bankName5_2_0_,
|
123 |
|
|
bankaccoun2_.iban as iban6_2_0_,
|
124 |
|
|
banktransf3_.id as id1_3_1_,
|
125 |
|
|
banktransf3_.content as content2_3_1_,
|
126 |
|
|
banktransf3_.contentType as contentT3_3_1_,
|
127 |
|
|
budget4_.id as id1_4_2_,
|
128 |
|
|
budget4_.amountGranted as amountGr2_4_2_,
|
129 |
|
|
budget4_.amountRequested as amountRe3_4_2_,
|
130 |
|
|
budget4_.bankAccount as bankAcc13_4_2_,
|
131 |
|
|
budget4_.bankReceipt as bankRec14_4_2_,
|
132 |
|
|
budget4_.beneficiarysignedcontract as benefic15_4_2_,
|
133 |
|
|
budget4_.currency as currency4_4_2_,
|
134 |
|
|
budget4_.date as date5_4_2_,
|
135 |
|
|
budget4_.datePaid as datePaid6_4_2_,
|
136 |
|
|
budget4_.enddate as enddate7_4_2_,
|
137 |
|
|
budget4_.initialcontractfile as initial16_4_2_,
|
138 |
|
|
budget4_.invoice as invoice17_4_2_,
|
139 |
|
|
budget4_.organization as organiz18_4_2_,
|
140 |
|
|
budget4_.otherCost as otherCos8_4_2_,
|
141 |
|
|
budget4_.publisher as publish19_4_2_,
|
142 |
|
|
budget4_.remaining as remainin9_4_2_,
|
143 |
|
|
budget4_.signedcontract as signedc20_4_2_,
|
144 |
|
|
budget4_.startdate as startda10_4_2_,
|
145 |
|
|
budget4_.status as status11_4_2_,
|
146 |
|
|
budget4_.transferCost as transfe12_4_2_,
|
147 |
|
|
budget4_."user" as user21_4_2_,
|
148 |
46350
|
panagiotis
|
organizati5_.id as id1_16_3_,
|
149 |
|
|
organizati5_.country as country5_16_3_,
|
150 |
|
|
organizati5_.name as name2_16_3_,
|
151 |
|
|
organizati5_.shortname as shortnam3_16_3_,
|
152 |
|
|
organizati5_.source as source4_16_3_,
|
153 |
|
|
country6_.id as id1_9_4_,
|
154 |
|
|
country6_.name as name2_9_4_,
|
155 |
|
|
publisher7_.id as id1_19_5_,
|
156 |
|
|
publisher7_.apc as apc2_19_5_,
|
157 |
|
|
publisher7_.apcCurrency as apcCurre3_19_5_,
|
158 |
|
|
publisher7_.bankAccount as bankAcco8_19_5_,
|
159 |
|
|
publisher7_.contact as contact9_19_5_,
|
160 |
|
|
publisher7_.discount as discount4_19_5_,
|
161 |
|
|
publisher7_.email as email5_19_5_,
|
162 |
|
|
publisher7_.name as name6_19_5_,
|
163 |
|
|
publisher7_.source as source7_19_5_,
|
164 |
|
|
bankaccoun8_.id as id1_2_6_,
|
165 |
|
|
bankaccoun8_.accountHolder as accountH2_2_6_,
|
166 |
|
|
bankaccoun8_.bankAddress as bankAddr3_2_6_,
|
167 |
|
|
bankaccoun8_.bankCode as bankCode4_2_6_,
|
168 |
|
|
bankaccoun8_.bankName as bankName5_2_6_,
|
169 |
|
|
bankaccoun8_.iban as iban6_2_6_,
|
170 |
|
|
user9_.email as email1_22_7_,
|
171 |
|
|
user9_.active as active2_22_7_,
|
172 |
|
|
user9_.firstname as firstnam3_22_7_,
|
173 |
|
|
user9_.id as id4_22_7_,
|
174 |
|
|
user9_.initials as initials5_22_7_,
|
175 |
|
|
user9_.lastname as lastname6_22_7_,
|
176 |
|
|
user9_.orcidid as orcidid7_22_7_,
|
177 |
|
|
user9_.password as password8_22_7_,
|
178 |
|
|
user9_.source as source9_22_7_,
|
179 |
|
|
user9_.telephone as telepho10_22_7_,
|
180 |
|
|
user10_.email as email1_22_8_,
|
181 |
|
|
user10_.active as active2_22_8_,
|
182 |
|
|
user10_.firstname as firstnam3_22_8_,
|
183 |
|
|
user10_.id as id4_22_8_,
|
184 |
|
|
user10_.initials as initials5_22_8_,
|
185 |
|
|
user10_.lastname as lastname6_22_8_,
|
186 |
|
|
user10_.orcidid as orcidid7_22_8_,
|
187 |
|
|
user10_.password as password8_22_8_,
|
188 |
|
|
user10_.source as source9_22_8_,
|
189 |
|
|
user10_.telephone as telepho10_22_8_,
|
190 |
|
|
invoice11_.id as id1_13_9_,
|
191 |
|
|
invoice11_.alternativeid as alternat2_13_9_,
|
192 |
|
|
invoice11_.date as date3_13_9_,
|
193 |
|
|
invoice11_.file as file7_13_9_,
|
194 |
|
|
invoice11_.number as number4_13_9_,
|
195 |
|
|
invoice11_.source as source5_13_9_,
|
196 |
|
|
invoice11_.status as status6_13_9_,
|
197 |
|
|
file12_.id as id1_10_10_,
|
198 |
|
|
file12_.file as file2_10_10_,
|
199 |
|
|
file12_.mimetype as mimetype3_10_10_,
|
200 |
|
|
journal13_.id as id1_14_11_,
|
201 |
|
|
journal13_.alttitle as alttitle2_14_11_,
|
202 |
|
|
journal13_.apc as apc3_14_11_,
|
203 |
|
|
journal13_.apccurrency as apccurre4_14_11_,
|
204 |
|
|
journal13_.country as country15_14_11_,
|
205 |
|
|
journal13_.discount as discount5_14_11_,
|
206 |
|
|
journal13_.issn as issn6_14_11_,
|
207 |
|
|
journal13_.languages as language7_14_11_,
|
208 |
|
|
journal13_.licence as licence8_14_11_,
|
209 |
|
|
journal13_.publisher as publish16_14_11_,
|
210 |
|
|
journal13_.source as source9_14_11_,
|
211 |
|
|
journal13_.status as status10_14_11_,
|
212 |
|
|
journal13_.subjects as subject11_14_11_,
|
213 |
|
|
journal13_.title as title12_14_11_,
|
214 |
|
|
journal13_.type as type13_14_11_,
|
215 |
|
|
journal13_.url as url14_14_11_,
|
216 |
|
|
country14_.id as id1_9_12_,
|
217 |
|
|
country14_.name as name2_9_12_,
|
218 |
|
|
publisher15_.id as id1_19_13_,
|
219 |
|
|
publisher15_.apc as apc2_19_13_,
|
220 |
|
|
publisher15_.apcCurrency as apcCurre3_19_13_,
|
221 |
|
|
publisher15_.bankAccount as bankAcco8_19_13_,
|
222 |
|
|
publisher15_.contact as contact9_19_13_,
|
223 |
|
|
publisher15_.discount as discount4_19_13_,
|
224 |
|
|
publisher15_.email as email5_19_13_,
|
225 |
|
|
publisher15_.name as name6_19_13_,
|
226 |
|
|
publisher15_.source as source7_19_13_,
|
227 |
|
|
organizati16_.id as id1_16_14_,
|
228 |
|
|
organizati16_.country as country5_16_14_,
|
229 |
|
|
organizati16_.name as name2_16_14_,
|
230 |
|
|
organizati16_.shortname as shortnam3_16_14_,
|
231 |
|
|
organizati16_.source as source4_16_14_,
|
232 |
|
|
project17_.id as id1_17_15_,
|
233 |
|
|
project17_.acronym as acronym2_17_15_,
|
234 |
|
|
project17_.call as call3_17_15_,
|
235 |
|
|
project17_.enddate as enddate4_17_15_,
|
236 |
|
|
project17_.funder as funder5_17_15_,
|
237 |
|
|
project17_.fundingstream as fundings6_17_15_,
|
238 |
|
|
project17_."grant" as grant7_17_15_,
|
239 |
|
|
project17_.sc39 as sc8_17_15_,
|
240 |
|
|
project17_.scientificarea as scientif9_17_15_,
|
241 |
|
|
project17_.source as source10_17_15_,
|
242 |
|
|
project17_.startdate as startda11_17_15_,
|
243 |
|
|
project17_.title as title12_17_15_,
|
244 |
|
|
project17_.url as url13_17_15_,
|
245 |
|
|
publicatio18_.id as id1_18_16_,
|
246 |
|
|
publicatio18_.acceptancedate as acceptan2_18_16_,
|
247 |
|
|
publicatio18_.alternativedoi as alternat3_18_16_,
|
248 |
|
|
publicatio18_.alternativetitle as alternat4_18_16_,
|
249 |
|
|
publicatio18_.date as date5_18_16_,
|
250 |
|
|
publicatio18_.doi as doi6_18_16_,
|
251 |
|
|
publicatio18_.eventdetails as eventdet7_18_16_,
|
252 |
|
|
publicatio18_.journal as journal15_18_16_,
|
253 |
|
|
publicatio18_.languages as language8_18_16_,
|
254 |
|
|
publicatio18_.license as license9_18_16_,
|
255 |
|
|
publicatio18_.publisher as publish16_18_16_,
|
256 |
|
|
publicatio18_.repository as reposit10_18_16_,
|
257 |
|
|
publicatio18_.source as source11_18_16_,
|
258 |
|
|
publicatio18_.subjects as subject12_18_16_,
|
259 |
|
|
publicatio18_.title as title13_18_16_,
|
260 |
|
|
publicatio18_.type as type14_18_16_,
|
261 |
46308
|
panagiotis
|
journal19_.id as id1_14_17_,
|
262 |
|
|
journal19_.alttitle as alttitle2_14_17_,
|
263 |
|
|
journal19_.apc as apc3_14_17_,
|
264 |
|
|
journal19_.apccurrency as apccurre4_14_17_,
|
265 |
|
|
journal19_.country as country15_14_17_,
|
266 |
|
|
journal19_.discount as discount5_14_17_,
|
267 |
|
|
journal19_.issn as issn6_14_17_,
|
268 |
|
|
journal19_.languages as language7_14_17_,
|
269 |
|
|
journal19_.licence as licence8_14_17_,
|
270 |
|
|
journal19_.publisher as publish16_14_17_,
|
271 |
|
|
journal19_.source as source9_14_17_,
|
272 |
|
|
journal19_.status as status10_14_17_,
|
273 |
|
|
journal19_.subjects as subject11_14_17_,
|
274 |
|
|
journal19_.title as title12_14_17_,
|
275 |
|
|
journal19_.type as type13_14_17_,
|
276 |
|
|
journal19_.url as url14_14_17_,
|
277 |
46350
|
panagiotis
|
publisher20_.id as id1_19_18_,
|
278 |
|
|
publisher20_.apc as apc2_19_18_,
|
279 |
|
|
publisher20_.apcCurrency as apcCurre3_19_18_,
|
280 |
|
|
publisher20_.bankAccount as bankAcco8_19_18_,
|
281 |
|
|
publisher20_.contact as contact9_19_18_,
|
282 |
|
|
publisher20_.discount as discount4_19_18_,
|
283 |
|
|
publisher20_.email as email5_19_18_,
|
284 |
|
|
publisher20_.name as name6_19_18_,
|
285 |
|
|
publisher20_.source as source7_19_18_,
|
286 |
46308
|
panagiotis
|
publisher21_.id as id1_19_19_,
|
287 |
|
|
publisher21_.apc as apc2_19_19_,
|
288 |
|
|
publisher21_.apcCurrency as apcCurre3_19_19_,
|
289 |
|
|
publisher21_.bankAccount as bankAcco8_19_19_,
|
290 |
|
|
publisher21_.contact as contact9_19_19_,
|
291 |
|
|
publisher21_.discount as discount4_19_19_,
|
292 |
|
|
publisher21_.email as email5_19_19_,
|
293 |
|
|
publisher21_.name as name6_19_19_,
|
294 |
|
|
publisher21_.source as source7_19_19_,
|
295 |
46350
|
panagiotis
|
user22_.email as email1_22_20_,
|
296 |
|
|
user22_.active as active2_22_20_,
|
297 |
|
|
user22_.firstname as firstnam3_22_20_,
|
298 |
|
|
user22_.id as id4_22_20_,
|
299 |
|
|
user22_.initials as initials5_22_20_,
|
300 |
|
|
user22_.lastname as lastname6_22_20_,
|
301 |
|
|
user22_.orcidid as orcidid7_22_20_,
|
302 |
|
|
user22_.password as password8_22_20_,
|
303 |
|
|
user22_.source as source9_22_20_,
|
304 |
|
|
user22_.telephone as telepho10_22_20_,
|
305 |
|
|
user23_.email as email1_22_21_,
|
306 |
|
|
user23_.active as active2_22_21_,
|
307 |
|
|
user23_.firstname as firstnam3_22_21_,
|
308 |
|
|
user23_.id as id4_22_21_,
|
309 |
|
|
user23_.initials as initials5_22_21_,
|
310 |
|
|
user23_.lastname as lastname6_22_21_,
|
311 |
|
|
user23_.orcidid as orcidid7_22_21_,
|
312 |
|
|
user23_.password as password8_22_21_,
|
313 |
|
|
user23_.source as source9_22_21_,
|
314 |
|
|
user23_.telephone as telepho10_22_21_
|
315 |
46308
|
panagiotis
|
from
|
316 |
|
|
Request this_
|
317 |
|
|
left outer join
|
318 |
|
|
BankAccount bankaccoun2_
|
319 |
|
|
on this_.bankAccount=bankaccoun2_.id
|
320 |
|
|
left outer join
|
321 |
|
|
BankTransferReceipt banktransf3_
|
322 |
|
|
on this_.bankTransferReceipt=banktransf3_.id
|
323 |
|
|
left outer join
|
324 |
|
|
Budget budget4_
|
325 |
|
|
on this_.budget=budget4_.id
|
326 |
|
|
left outer join
|
327 |
46350
|
panagiotis
|
Organization organizati5_
|
328 |
|
|
on budget4_.organization=organizati5_.id
|
329 |
46308
|
panagiotis
|
left outer join
|
330 |
46350
|
panagiotis
|
Country country6_
|
331 |
|
|
on organizati5_.country=country6_.id
|
332 |
46308
|
panagiotis
|
left outer join
|
333 |
46350
|
panagiotis
|
Publisher publisher7_
|
334 |
|
|
on budget4_.publisher=publisher7_.id
|
335 |
46308
|
panagiotis
|
left outer join
|
336 |
46350
|
panagiotis
|
BankAccount bankaccoun8_
|
337 |
|
|
on publisher7_.bankAccount=bankaccoun8_.id
|
338 |
46308
|
panagiotis
|
left outer join
|
339 |
46350
|
panagiotis
|
"user" user9_
|
340 |
|
|
on publisher7_.contact=user9_.email
|
341 |
46308
|
panagiotis
|
left outer join
|
342 |
46350
|
panagiotis
|
"user" user10_
|
343 |
|
|
on budget4_."user"=user10_.email
|
344 |
46308
|
panagiotis
|
left outer join
|
345 |
46350
|
panagiotis
|
Invoice invoice11_
|
346 |
|
|
on this_.invoice=invoice11_.id
|
347 |
46308
|
panagiotis
|
left outer join
|
348 |
46350
|
panagiotis
|
File file12_
|
349 |
|
|
on invoice11_.file=file12_.id
|
350 |
46308
|
panagiotis
|
left outer join
|
351 |
46350
|
panagiotis
|
Journal journal13_
|
352 |
|
|
on this_.journal=journal13_.id
|
353 |
46308
|
panagiotis
|
left outer join
|
354 |
46350
|
panagiotis
|
Country country14_
|
355 |
|
|
on journal13_.country=country14_.id
|
356 |
46308
|
panagiotis
|
left outer join
|
357 |
46350
|
panagiotis
|
Publisher publisher15_
|
358 |
|
|
on journal13_.publisher=publisher15_.id
|
359 |
46308
|
panagiotis
|
left outer join
|
360 |
46350
|
panagiotis
|
Organization organizati16_
|
361 |
|
|
on this_.organization=organizati16_.id
|
362 |
46308
|
panagiotis
|
left outer join
|
363 |
46350
|
panagiotis
|
Project project17_
|
364 |
|
|
on this_.project=project17_.id
|
365 |
46308
|
panagiotis
|
left outer join
|
366 |
46350
|
panagiotis
|
Publication publicatio18_
|
367 |
|
|
on this_.publication=publicatio18_.id
|
368 |
46308
|
panagiotis
|
left outer join
|
369 |
|
|
Journal journal19_
|
370 |
46350
|
panagiotis
|
on publicatio18_.journal=journal19_.id
|
371 |
46308
|
panagiotis
|
left outer join
|
372 |
46350
|
panagiotis
|
Publisher publisher20_
|
373 |
|
|
on publicatio18_.publisher=publisher20_.id
|
374 |
46308
|
panagiotis
|
left outer join
|
375 |
|
|
Publisher publisher21_
|
376 |
46350
|
panagiotis
|
on this_.publisher=publisher21_.id
|
377 |
46308
|
panagiotis
|
left outer join
|
378 |
46350
|
panagiotis
|
"user" user22_
|
379 |
|
|
on this_.researcher=user22_.email
|
380 |
46308
|
panagiotis
|
left outer join
|
381 |
46350
|
panagiotis
|
"user" user23_
|
382 |
|
|
on this_."user"=user23_.email
|
383 |
46308
|
panagiotis
|
where
|
384 |
|
|
this_.status in (
|
385 |
|
|
?, ?, ?, ?, ?
|
386 |
|
|
)
|
387 |
|
|
Hibernate:
|
388 |
|
|
select
|
389 |
|
|
distinct p1_.id as y0_
|
390 |
|
|
from
|
391 |
|
|
Request this_
|
392 |
|
|
inner join
|
393 |
|
|
Project p1_
|
394 |
|
|
on this_.project=p1_.id
|
395 |
|
|
where
|
396 |
|
|
this_.status in (
|
397 |
|
|
?, ?, ?, ?, ?
|
398 |
|
|
)
|
399 |
|
|
Hibernate:
|
400 |
|
|
select
|
401 |
|
|
sum(this_.apcPaid) as y0_
|
402 |
|
|
from
|
403 |
|
|
Request this_
|
404 |
|
|
Hibernate:
|
405 |
|
|
select
|
406 |
|
|
avg(this_.apcPaid) as y0_
|
407 |
|
|
from
|
408 |
|
|
Request this_
|
409 |
|
|
Hibernate:
|
410 |
|
|
select
|
411 |
46350
|
panagiotis
|
this_.id as id1_20_22_,
|
412 |
|
|
this_.apc as apc2_20_22_,
|
413 |
|
|
this_.apcPaid as apcPaid3_20_22_,
|
414 |
|
|
this_.approvaldate as approval4_20_22_,
|
415 |
|
|
this_.bankAccount as bankAcc16_20_22_,
|
416 |
|
|
this_.bankTransferReceipt as bankTra17_20_22_,
|
417 |
|
|
this_.budget as budget18_20_22_,
|
418 |
|
|
this_.currency as currency5_20_22_,
|
419 |
|
|
this_.date as date6_20_22_,
|
420 |
|
|
this_.datePaid as datePaid7_20_22_,
|
421 |
|
|
this_.discount as discount8_20_22_,
|
422 |
|
|
this_.fundingrequested as fundingr9_20_22_,
|
423 |
|
|
this_.invoice as invoice19_20_22_,
|
424 |
|
|
this_.journal as journal20_20_22_,
|
425 |
|
|
this_.organization as organiz21_20_22_,
|
426 |
|
|
this_.otherCost as otherCo10_20_22_,
|
427 |
|
|
this_.project as project22_20_22_,
|
428 |
|
|
this_.projectparticipation as project11_20_22_,
|
429 |
|
|
this_.publication as publica23_20_22_,
|
430 |
|
|
this_.publisher as publish24_20_22_,
|
431 |
|
|
this_.publisher_email as publish12_20_22_,
|
432 |
|
|
this_.researcher as researc25_20_22_,
|
433 |
|
|
this_.status as status13_20_22_,
|
434 |
|
|
this_.submissiondate as submiss14_20_22_,
|
435 |
|
|
this_.transferCost as transfe15_20_22_,
|
436 |
|
|
this_."user" as user26_20_22_,
|
437 |
46308
|
panagiotis
|
bankaccoun3_.id as id1_2_0_,
|
438 |
|
|
bankaccoun3_.accountHolder as accountH2_2_0_,
|
439 |
|
|
bankaccoun3_.bankAddress as bankAddr3_2_0_,
|
440 |
|
|
bankaccoun3_.bankCode as bankCode4_2_0_,
|
441 |
|
|
bankaccoun3_.bankName as bankName5_2_0_,
|
442 |
|
|
bankaccoun3_.iban as iban6_2_0_,
|
443 |
|
|
banktransf4_.id as id1_3_1_,
|
444 |
|
|
banktransf4_.content as content2_3_1_,
|
445 |
|
|
banktransf4_.contentType as contentT3_3_1_,
|
446 |
|
|
budget5_.id as id1_4_2_,
|
447 |
|
|
budget5_.amountGranted as amountGr2_4_2_,
|
448 |
|
|
budget5_.amountRequested as amountRe3_4_2_,
|
449 |
|
|
budget5_.bankAccount as bankAcc13_4_2_,
|
450 |
|
|
budget5_.bankReceipt as bankRec14_4_2_,
|
451 |
|
|
budget5_.beneficiarysignedcontract as benefic15_4_2_,
|
452 |
|
|
budget5_.currency as currency4_4_2_,
|
453 |
|
|
budget5_.date as date5_4_2_,
|
454 |
|
|
budget5_.datePaid as datePaid6_4_2_,
|
455 |
|
|
budget5_.enddate as enddate7_4_2_,
|
456 |
|
|
budget5_.initialcontractfile as initial16_4_2_,
|
457 |
|
|
budget5_.invoice as invoice17_4_2_,
|
458 |
|
|
budget5_.organization as organiz18_4_2_,
|
459 |
|
|
budget5_.otherCost as otherCos8_4_2_,
|
460 |
|
|
budget5_.publisher as publish19_4_2_,
|
461 |
|
|
budget5_.remaining as remainin9_4_2_,
|
462 |
|
|
budget5_.signedcontract as signedc20_4_2_,
|
463 |
|
|
budget5_.startdate as startda10_4_2_,
|
464 |
|
|
budget5_.status as status11_4_2_,
|
465 |
|
|
budget5_.transferCost as transfe12_4_2_,
|
466 |
|
|
budget5_."user" as user21_4_2_,
|
467 |
46350
|
panagiotis
|
organizati6_.id as id1_16_3_,
|
468 |
|
|
organizati6_.country as country5_16_3_,
|
469 |
|
|
organizati6_.name as name2_16_3_,
|
470 |
|
|
organizati6_.shortname as shortnam3_16_3_,
|
471 |
|
|
organizati6_.source as source4_16_3_,
|
472 |
|
|
country7_.id as id1_9_4_,
|
473 |
|
|
country7_.name as name2_9_4_,
|
474 |
|
|
publisher8_.id as id1_19_5_,
|
475 |
|
|
publisher8_.apc as apc2_19_5_,
|
476 |
|
|
publisher8_.apcCurrency as apcCurre3_19_5_,
|
477 |
|
|
publisher8_.bankAccount as bankAcco8_19_5_,
|
478 |
|
|
publisher8_.contact as contact9_19_5_,
|
479 |
|
|
publisher8_.discount as discount4_19_5_,
|
480 |
|
|
publisher8_.email as email5_19_5_,
|
481 |
|
|
publisher8_.name as name6_19_5_,
|
482 |
|
|
publisher8_.source as source7_19_5_,
|
483 |
|
|
bankaccoun9_.id as id1_2_6_,
|
484 |
|
|
bankaccoun9_.accountHolder as accountH2_2_6_,
|
485 |
|
|
bankaccoun9_.bankAddress as bankAddr3_2_6_,
|
486 |
|
|
bankaccoun9_.bankCode as bankCode4_2_6_,
|
487 |
|
|
bankaccoun9_.bankName as bankName5_2_6_,
|
488 |
|
|
bankaccoun9_.iban as iban6_2_6_,
|
489 |
|
|
user10_.email as email1_22_7_,
|
490 |
|
|
user10_.active as active2_22_7_,
|
491 |
|
|
user10_.firstname as firstnam3_22_7_,
|
492 |
|
|
user10_.id as id4_22_7_,
|
493 |
|
|
user10_.initials as initials5_22_7_,
|
494 |
|
|
user10_.lastname as lastname6_22_7_,
|
495 |
|
|
user10_.orcidid as orcidid7_22_7_,
|
496 |
|
|
user10_.password as password8_22_7_,
|
497 |
|
|
user10_.source as source9_22_7_,
|
498 |
|
|
user10_.telephone as telepho10_22_7_,
|
499 |
|
|
user11_.email as email1_22_8_,
|
500 |
|
|
user11_.active as active2_22_8_,
|
501 |
|
|
user11_.firstname as firstnam3_22_8_,
|
502 |
|
|
user11_.id as id4_22_8_,
|
503 |
|
|
user11_.initials as initials5_22_8_,
|
504 |
|
|
user11_.lastname as lastname6_22_8_,
|
505 |
|
|
user11_.orcidid as orcidid7_22_8_,
|
506 |
|
|
user11_.password as password8_22_8_,
|
507 |
|
|
user11_.source as source9_22_8_,
|
508 |
|
|
user11_.telephone as telepho10_22_8_,
|
509 |
|
|
invoice12_.id as id1_13_9_,
|
510 |
|
|
invoice12_.alternativeid as alternat2_13_9_,
|
511 |
|
|
invoice12_.date as date3_13_9_,
|
512 |
|
|
invoice12_.file as file7_13_9_,
|
513 |
|
|
invoice12_.number as number4_13_9_,
|
514 |
|
|
invoice12_.source as source5_13_9_,
|
515 |
|
|
invoice12_.status as status6_13_9_,
|
516 |
|
|
file13_.id as id1_10_10_,
|
517 |
|
|
file13_.file as file2_10_10_,
|
518 |
|
|
file13_.mimetype as mimetype3_10_10_,
|
519 |
|
|
journal14_.id as id1_14_11_,
|
520 |
|
|
journal14_.alttitle as alttitle2_14_11_,
|
521 |
|
|
journal14_.apc as apc3_14_11_,
|
522 |
|
|
journal14_.apccurrency as apccurre4_14_11_,
|
523 |
|
|
journal14_.country as country15_14_11_,
|
524 |
|
|
journal14_.discount as discount5_14_11_,
|
525 |
|
|
journal14_.issn as issn6_14_11_,
|
526 |
|
|
journal14_.languages as language7_14_11_,
|
527 |
|
|
journal14_.licence as licence8_14_11_,
|
528 |
|
|
journal14_.publisher as publish16_14_11_,
|
529 |
|
|
journal14_.source as source9_14_11_,
|
530 |
|
|
journal14_.status as status10_14_11_,
|
531 |
|
|
journal14_.subjects as subject11_14_11_,
|
532 |
|
|
journal14_.title as title12_14_11_,
|
533 |
|
|
journal14_.type as type13_14_11_,
|
534 |
|
|
journal14_.url as url14_14_11_,
|
535 |
|
|
country15_.id as id1_9_12_,
|
536 |
|
|
country15_.name as name2_9_12_,
|
537 |
|
|
publisher16_.id as id1_19_13_,
|
538 |
|
|
publisher16_.apc as apc2_19_13_,
|
539 |
|
|
publisher16_.apcCurrency as apcCurre3_19_13_,
|
540 |
|
|
publisher16_.bankAccount as bankAcco8_19_13_,
|
541 |
|
|
publisher16_.contact as contact9_19_13_,
|
542 |
|
|
publisher16_.discount as discount4_19_13_,
|
543 |
|
|
publisher16_.email as email5_19_13_,
|
544 |
|
|
publisher16_.name as name6_19_13_,
|
545 |
|
|
publisher16_.source as source7_19_13_,
|
546 |
|
|
organizati17_.id as id1_16_14_,
|
547 |
|
|
organizati17_.country as country5_16_14_,
|
548 |
|
|
organizati17_.name as name2_16_14_,
|
549 |
|
|
organizati17_.shortname as shortnam3_16_14_,
|
550 |
|
|
organizati17_.source as source4_16_14_,
|
551 |
|
|
project18_.id as id1_17_15_,
|
552 |
|
|
project18_.acronym as acronym2_17_15_,
|
553 |
|
|
project18_.call as call3_17_15_,
|
554 |
|
|
project18_.enddate as enddate4_17_15_,
|
555 |
|
|
project18_.funder as funder5_17_15_,
|
556 |
|
|
project18_.fundingstream as fundings6_17_15_,
|
557 |
|
|
project18_."grant" as grant7_17_15_,
|
558 |
|
|
project18_.sc39 as sc8_17_15_,
|
559 |
|
|
project18_.scientificarea as scientif9_17_15_,
|
560 |
|
|
project18_.source as source10_17_15_,
|
561 |
|
|
project18_.startdate as startda11_17_15_,
|
562 |
|
|
project18_.title as title12_17_15_,
|
563 |
|
|
project18_.url as url13_17_15_,
|
564 |
|
|
p1_.id as id1_18_16_,
|
565 |
|
|
p1_.acceptancedate as acceptan2_18_16_,
|
566 |
|
|
p1_.alternativedoi as alternat3_18_16_,
|
567 |
|
|
p1_.alternativetitle as alternat4_18_16_,
|
568 |
|
|
p1_.date as date5_18_16_,
|
569 |
|
|
p1_.doi as doi6_18_16_,
|
570 |
|
|
p1_.eventdetails as eventdet7_18_16_,
|
571 |
|
|
p1_.journal as journal15_18_16_,
|
572 |
|
|
p1_.languages as language8_18_16_,
|
573 |
|
|
p1_.license as license9_18_16_,
|
574 |
|
|
p1_.publisher as publish16_18_16_,
|
575 |
|
|
p1_.repository as reposit10_18_16_,
|
576 |
|
|
p1_.source as source11_18_16_,
|
577 |
|
|
p1_.subjects as subject12_18_16_,
|
578 |
|
|
p1_.title as title13_18_16_,
|
579 |
|
|
p1_.type as type14_18_16_,
|
580 |
46308
|
panagiotis
|
journal20_.id as id1_14_17_,
|
581 |
|
|
journal20_.alttitle as alttitle2_14_17_,
|
582 |
|
|
journal20_.apc as apc3_14_17_,
|
583 |
|
|
journal20_.apccurrency as apccurre4_14_17_,
|
584 |
|
|
journal20_.country as country15_14_17_,
|
585 |
|
|
journal20_.discount as discount5_14_17_,
|
586 |
|
|
journal20_.issn as issn6_14_17_,
|
587 |
|
|
journal20_.languages as language7_14_17_,
|
588 |
|
|
journal20_.licence as licence8_14_17_,
|
589 |
|
|
journal20_.publisher as publish16_14_17_,
|
590 |
|
|
journal20_.source as source9_14_17_,
|
591 |
|
|
journal20_.status as status10_14_17_,
|
592 |
|
|
journal20_.subjects as subject11_14_17_,
|
593 |
|
|
journal20_.title as title12_14_17_,
|
594 |
|
|
journal20_.type as type13_14_17_,
|
595 |
|
|
journal20_.url as url14_14_17_,
|
596 |
46350
|
panagiotis
|
publisher21_.id as id1_19_18_,
|
597 |
|
|
publisher21_.apc as apc2_19_18_,
|
598 |
|
|
publisher21_.apcCurrency as apcCurre3_19_18_,
|
599 |
|
|
publisher21_.bankAccount as bankAcco8_19_18_,
|
600 |
|
|
publisher21_.contact as contact9_19_18_,
|
601 |
|
|
publisher21_.discount as discount4_19_18_,
|
602 |
|
|
publisher21_.email as email5_19_18_,
|
603 |
|
|
publisher21_.name as name6_19_18_,
|
604 |
|
|
publisher21_.source as source7_19_18_,
|
605 |
46308
|
panagiotis
|
publisher22_.id as id1_19_19_,
|
606 |
|
|
publisher22_.apc as apc2_19_19_,
|
607 |
|
|
publisher22_.apcCurrency as apcCurre3_19_19_,
|
608 |
|
|
publisher22_.bankAccount as bankAcco8_19_19_,
|
609 |
|
|
publisher22_.contact as contact9_19_19_,
|
610 |
|
|
publisher22_.discount as discount4_19_19_,
|
611 |
|
|
publisher22_.email as email5_19_19_,
|
612 |
|
|
publisher22_.name as name6_19_19_,
|
613 |
|
|
publisher22_.source as source7_19_19_,
|
614 |
46350
|
panagiotis
|
user23_.email as email1_22_20_,
|
615 |
|
|
user23_.active as active2_22_20_,
|
616 |
|
|
user23_.firstname as firstnam3_22_20_,
|
617 |
|
|
user23_.id as id4_22_20_,
|
618 |
|
|
user23_.initials as initials5_22_20_,
|
619 |
|
|
user23_.lastname as lastname6_22_20_,
|
620 |
|
|
user23_.orcidid as orcidid7_22_20_,
|
621 |
|
|
user23_.password as password8_22_20_,
|
622 |
|
|
user23_.source as source9_22_20_,
|
623 |
|
|
user23_.telephone as telepho10_22_20_,
|
624 |
|
|
user24_.email as email1_22_21_,
|
625 |
|
|
user24_.active as active2_22_21_,
|
626 |
|
|
user24_.firstname as firstnam3_22_21_,
|
627 |
|
|
user24_.id as id4_22_21_,
|
628 |
|
|
user24_.initials as initials5_22_21_,
|
629 |
|
|
user24_.lastname as lastname6_22_21_,
|
630 |
|
|
user24_.orcidid as orcidid7_22_21_,
|
631 |
|
|
user24_.password as password8_22_21_,
|
632 |
|
|
user24_.source as source9_22_21_,
|
633 |
|
|
user24_.telephone as telepho10_22_21_
|
634 |
46308
|
panagiotis
|
from
|
635 |
|
|
Request this_
|
636 |
|
|
left outer join
|
637 |
|
|
BankAccount bankaccoun3_
|
638 |
|
|
on this_.bankAccount=bankaccoun3_.id
|
639 |
|
|
left outer join
|
640 |
|
|
BankTransferReceipt banktransf4_
|
641 |
|
|
on this_.bankTransferReceipt=banktransf4_.id
|
642 |
|
|
left outer join
|
643 |
|
|
Budget budget5_
|
644 |
|
|
on this_.budget=budget5_.id
|
645 |
|
|
left outer join
|
646 |
46350
|
panagiotis
|
Organization organizati6_
|
647 |
|
|
on budget5_.organization=organizati6_.id
|
648 |
46308
|
panagiotis
|
left outer join
|
649 |
46350
|
panagiotis
|
Country country7_
|
650 |
|
|
on organizati6_.country=country7_.id
|
651 |
46308
|
panagiotis
|
left outer join
|
652 |
46350
|
panagiotis
|
Publisher publisher8_
|
653 |
|
|
on budget5_.publisher=publisher8_.id
|
654 |
46308
|
panagiotis
|
left outer join
|
655 |
46350
|
panagiotis
|
BankAccount bankaccoun9_
|
656 |
|
|
on publisher8_.bankAccount=bankaccoun9_.id
|
657 |
46308
|
panagiotis
|
left outer join
|
658 |
46350
|
panagiotis
|
"user" user10_
|
659 |
|
|
on publisher8_.contact=user10_.email
|
660 |
46308
|
panagiotis
|
left outer join
|
661 |
46350
|
panagiotis
|
"user" user11_
|
662 |
|
|
on budget5_."user"=user11_.email
|
663 |
46308
|
panagiotis
|
left outer join
|
664 |
46350
|
panagiotis
|
Invoice invoice12_
|
665 |
|
|
on this_.invoice=invoice12_.id
|
666 |
46308
|
panagiotis
|
left outer join
|
667 |
46350
|
panagiotis
|
File file13_
|
668 |
|
|
on invoice12_.file=file13_.id
|
669 |
46308
|
panagiotis
|
left outer join
|
670 |
46350
|
panagiotis
|
Journal journal14_
|
671 |
|
|
on this_.journal=journal14_.id
|
672 |
46308
|
panagiotis
|
left outer join
|
673 |
46350
|
panagiotis
|
Country country15_
|
674 |
|
|
on journal14_.country=country15_.id
|
675 |
46308
|
panagiotis
|
left outer join
|
676 |
46350
|
panagiotis
|
Publisher publisher16_
|
677 |
|
|
on journal14_.publisher=publisher16_.id
|
678 |
46308
|
panagiotis
|
left outer join
|
679 |
46350
|
panagiotis
|
Organization organizati17_
|
680 |
|
|
on this_.organization=organizati17_.id
|
681 |
46308
|
panagiotis
|
left outer join
|
682 |
46350
|
panagiotis
|
Project project18_
|
683 |
|
|
on this_.project=project18_.id
|
684 |
46308
|
panagiotis
|
inner join
|
685 |
|
|
Publication p1_
|
686 |
|
|
on this_.publication=p1_.id
|
687 |
|
|
left outer join
|
688 |
46350
|
panagiotis
|
Journal journal20_
|
689 |
|
|
on p1_.journal=journal20_.id
|
690 |
46308
|
panagiotis
|
left outer join
|
691 |
46350
|
panagiotis
|
Publisher publisher21_
|
692 |
|
|
on p1_.publisher=publisher21_.id
|
693 |
46308
|
panagiotis
|
left outer join
|
694 |
46350
|
panagiotis
|
Publisher publisher22_
|
695 |
|
|
on this_.publisher=publisher22_.id
|
696 |
46308
|
panagiotis
|
left outer join
|
697 |
46350
|
panagiotis
|
"user" user23_
|
698 |
|
|
on this_.researcher=user23_.email
|
699 |
46308
|
panagiotis
|
left outer join
|
700 |
46350
|
panagiotis
|
"user" user24_
|
701 |
|
|
on this_."user"=user24_.email
|
702 |
46308
|
panagiotis
|
where
|
703 |
|
|
p1_.type=?
|
704 |
|
|
and this_.status=?
|
705 |
|
|
Hibernate:
|
706 |
|
|
select
|
707 |
|
|
avg(this_.apcPaid) as y0_
|
708 |
|
|
from
|
709 |
|
|
Request this_
|
710 |
|
|
inner join
|
711 |
|
|
Publication p1_
|
712 |
|
|
on this_.publication=p1_.id
|
713 |
|
|
where
|
714 |
|
|
p1_.type=?
|
715 |
|
|
Hibernate:
|
716 |
|
|
select
|
717 |
46350
|
panagiotis
|
this_.id as id1_20_22_,
|
718 |
|
|
this_.apc as apc2_20_22_,
|
719 |
|
|
this_.apcPaid as apcPaid3_20_22_,
|
720 |
|
|
this_.approvaldate as approval4_20_22_,
|
721 |
|
|
this_.bankAccount as bankAcc16_20_22_,
|
722 |
|
|
this_.bankTransferReceipt as bankTra17_20_22_,
|
723 |
|
|
this_.budget as budget18_20_22_,
|
724 |
|
|
this_.currency as currency5_20_22_,
|
725 |
|
|
this_.date as date6_20_22_,
|
726 |
|
|
this_.datePaid as datePaid7_20_22_,
|
727 |
|
|
this_.discount as discount8_20_22_,
|
728 |
|
|
this_.fundingrequested as fundingr9_20_22_,
|
729 |
|
|
this_.invoice as invoice19_20_22_,
|
730 |
|
|
this_.journal as journal20_20_22_,
|
731 |
|
|
this_.organization as organiz21_20_22_,
|
732 |
|
|
this_.otherCost as otherCo10_20_22_,
|
733 |
|
|
this_.project as project22_20_22_,
|
734 |
|
|
this_.projectparticipation as project11_20_22_,
|
735 |
|
|
this_.publication as publica23_20_22_,
|
736 |
|
|
this_.publisher as publish24_20_22_,
|
737 |
|
|
this_.publisher_email as publish12_20_22_,
|
738 |
|
|
this_.researcher as researc25_20_22_,
|
739 |
|
|
this_.status as status13_20_22_,
|
740 |
|
|
this_.submissiondate as submiss14_20_22_,
|
741 |
|
|
this_.transferCost as transfe15_20_22_,
|
742 |
|
|
this_."user" as user26_20_22_,
|
743 |
46308
|
panagiotis
|
bankaccoun3_.id as id1_2_0_,
|
744 |
|
|
bankaccoun3_.accountHolder as accountH2_2_0_,
|
745 |
|
|
bankaccoun3_.bankAddress as bankAddr3_2_0_,
|
746 |
|
|
bankaccoun3_.bankCode as bankCode4_2_0_,
|
747 |
|
|
bankaccoun3_.bankName as bankName5_2_0_,
|
748 |
|
|
bankaccoun3_.iban as iban6_2_0_,
|
749 |
|
|
banktransf4_.id as id1_3_1_,
|
750 |
|
|
banktransf4_.content as content2_3_1_,
|
751 |
|
|
banktransf4_.contentType as contentT3_3_1_,
|
752 |
|
|
budget5_.id as id1_4_2_,
|
753 |
|
|
budget5_.amountGranted as amountGr2_4_2_,
|
754 |
|
|
budget5_.amountRequested as amountRe3_4_2_,
|
755 |
|
|
budget5_.bankAccount as bankAcc13_4_2_,
|
756 |
|
|
budget5_.bankReceipt as bankRec14_4_2_,
|
757 |
|
|
budget5_.beneficiarysignedcontract as benefic15_4_2_,
|
758 |
|
|
budget5_.currency as currency4_4_2_,
|
759 |
|
|
budget5_.date as date5_4_2_,
|
760 |
|
|
budget5_.datePaid as datePaid6_4_2_,
|
761 |
|
|
budget5_.enddate as enddate7_4_2_,
|
762 |
|
|
budget5_.initialcontractfile as initial16_4_2_,
|
763 |
|
|
budget5_.invoice as invoice17_4_2_,
|
764 |
|
|
budget5_.organization as organiz18_4_2_,
|
765 |
|
|
budget5_.otherCost as otherCos8_4_2_,
|
766 |
|
|
budget5_.publisher as publish19_4_2_,
|
767 |
|
|
budget5_.remaining as remainin9_4_2_,
|
768 |
|
|
budget5_.signedcontract as signedc20_4_2_,
|
769 |
|
|
budget5_.startdate as startda10_4_2_,
|
770 |
|
|
budget5_.status as status11_4_2_,
|
771 |
|
|
budget5_.transferCost as transfe12_4_2_,
|
772 |
|
|
budget5_."user" as user21_4_2_,
|
773 |
46350
|
panagiotis
|
organizati6_.id as id1_16_3_,
|
774 |
|
|
organizati6_.country as country5_16_3_,
|
775 |
|
|
organizati6_.name as name2_16_3_,
|
776 |
|
|
organizati6_.shortname as shortnam3_16_3_,
|
777 |
|
|
organizati6_.source as source4_16_3_,
|
778 |
|
|
country7_.id as id1_9_4_,
|
779 |
|
|
country7_.name as name2_9_4_,
|
780 |
|
|
publisher8_.id as id1_19_5_,
|
781 |
|
|
publisher8_.apc as apc2_19_5_,
|
782 |
|
|
publisher8_.apcCurrency as apcCurre3_19_5_,
|
783 |
|
|
publisher8_.bankAccount as bankAcco8_19_5_,
|
784 |
|
|
publisher8_.contact as contact9_19_5_,
|
785 |
|
|
publisher8_.discount as discount4_19_5_,
|
786 |
|
|
publisher8_.email as email5_19_5_,
|
787 |
|
|
publisher8_.name as name6_19_5_,
|
788 |
|
|
publisher8_.source as source7_19_5_,
|
789 |
|
|
bankaccoun9_.id as id1_2_6_,
|
790 |
|
|
bankaccoun9_.accountHolder as accountH2_2_6_,
|
791 |
|
|
bankaccoun9_.bankAddress as bankAddr3_2_6_,
|
792 |
|
|
bankaccoun9_.bankCode as bankCode4_2_6_,
|
793 |
|
|
bankaccoun9_.bankName as bankName5_2_6_,
|
794 |
|
|
bankaccoun9_.iban as iban6_2_6_,
|
795 |
|
|
user10_.email as email1_22_7_,
|
796 |
|
|
user10_.active as active2_22_7_,
|
797 |
|
|
user10_.firstname as firstnam3_22_7_,
|
798 |
|
|
user10_.id as id4_22_7_,
|
799 |
|
|
user10_.initials as initials5_22_7_,
|
800 |
|
|
user10_.lastname as lastname6_22_7_,
|
801 |
|
|
user10_.orcidid as orcidid7_22_7_,
|
802 |
|
|
user10_.password as password8_22_7_,
|
803 |
|
|
user10_.source as source9_22_7_,
|
804 |
|
|
user10_.telephone as telepho10_22_7_,
|
805 |
|
|
user11_.email as email1_22_8_,
|
806 |
|
|
user11_.active as active2_22_8_,
|
807 |
|
|
user11_.firstname as firstnam3_22_8_,
|
808 |
|
|
user11_.id as id4_22_8_,
|
809 |
|
|
user11_.initials as initials5_22_8_,
|
810 |
|
|
user11_.lastname as lastname6_22_8_,
|
811 |
|
|
user11_.orcidid as orcidid7_22_8_,
|
812 |
|
|
user11_.password as password8_22_8_,
|
813 |
|
|
user11_.source as source9_22_8_,
|
814 |
|
|
user11_.telephone as telepho10_22_8_,
|
815 |
|
|
invoice12_.id as id1_13_9_,
|
816 |
|
|
invoice12_.alternativeid as alternat2_13_9_,
|
817 |
|
|
invoice12_.date as date3_13_9_,
|
818 |
|
|
invoice12_.file as file7_13_9_,
|
819 |
|
|
invoice12_.number as number4_13_9_,
|
820 |
|
|
invoice12_.source as source5_13_9_,
|
821 |
|
|
invoice12_.status as status6_13_9_,
|
822 |
|
|
file13_.id as id1_10_10_,
|
823 |
|
|
file13_.file as file2_10_10_,
|
824 |
|
|
file13_.mimetype as mimetype3_10_10_,
|
825 |
|
|
journal14_.id as id1_14_11_,
|
826 |
|
|
journal14_.alttitle as alttitle2_14_11_,
|
827 |
|
|
journal14_.apc as apc3_14_11_,
|
828 |
|
|
journal14_.apccurrency as apccurre4_14_11_,
|
829 |
|
|
journal14_.country as country15_14_11_,
|
830 |
|
|
journal14_.discount as discount5_14_11_,
|
831 |
|
|
journal14_.issn as issn6_14_11_,
|
832 |
|
|
journal14_.languages as language7_14_11_,
|
833 |
|
|
journal14_.licence as licence8_14_11_,
|
834 |
|
|
journal14_.publisher as publish16_14_11_,
|
835 |
|
|
journal14_.source as source9_14_11_,
|
836 |
|
|
journal14_.status as status10_14_11_,
|
837 |
|
|
journal14_.subjects as subject11_14_11_,
|
838 |
|
|
journal14_.title as title12_14_11_,
|
839 |
|
|
journal14_.type as type13_14_11_,
|
840 |
|
|
journal14_.url as url14_14_11_,
|
841 |
|
|
country15_.id as id1_9_12_,
|
842 |
|
|
country15_.name as name2_9_12_,
|
843 |
|
|
publisher16_.id as id1_19_13_,
|
844 |
|
|
publisher16_.apc as apc2_19_13_,
|
845 |
|
|
publisher16_.apcCurrency as apcCurre3_19_13_,
|
846 |
|
|
publisher16_.bankAccount as bankAcco8_19_13_,
|
847 |
|
|
publisher16_.contact as contact9_19_13_,
|
848 |
|
|
publisher16_.discount as discount4_19_13_,
|
849 |
|
|
publisher16_.email as email5_19_13_,
|
850 |
|
|
publisher16_.name as name6_19_13_,
|
851 |
|
|
publisher16_.source as source7_19_13_,
|
852 |
|
|
organizati17_.id as id1_16_14_,
|
853 |
|
|
organizati17_.country as country5_16_14_,
|
854 |
|
|
organizati17_.name as name2_16_14_,
|
855 |
|
|
organizati17_.shortname as shortnam3_16_14_,
|
856 |
|
|
organizati17_.source as source4_16_14_,
|
857 |
|
|
project18_.id as id1_17_15_,
|
858 |
|
|
project18_.acronym as acronym2_17_15_,
|
859 |
|
|
project18_.call as call3_17_15_,
|
860 |
|
|
project18_.enddate as enddate4_17_15_,
|
861 |
|
|
project18_.funder as funder5_17_15_,
|
862 |
|
|
project18_.fundingstream as fundings6_17_15_,
|
863 |
|
|
project18_."grant" as grant7_17_15_,
|
864 |
|
|
project18_.sc39 as sc8_17_15_,
|
865 |
|
|
project18_.scientificarea as scientif9_17_15_,
|
866 |
|
|
project18_.source as source10_17_15_,
|
867 |
|
|
project18_.startdate as startda11_17_15_,
|
868 |
|
|
project18_.title as title12_17_15_,
|
869 |
|
|
project18_.url as url13_17_15_,
|
870 |
|
|
p1_.id as id1_18_16_,
|
871 |
|
|
p1_.acceptancedate as acceptan2_18_16_,
|
872 |
|
|
p1_.alternativedoi as alternat3_18_16_,
|
873 |
|
|
p1_.alternativetitle as alternat4_18_16_,
|
874 |
|
|
p1_.date as date5_18_16_,
|
875 |
|
|
p1_.doi as doi6_18_16_,
|
876 |
|
|
p1_.eventdetails as eventdet7_18_16_,
|
877 |
|
|
p1_.journal as journal15_18_16_,
|
878 |
|
|
p1_.languages as language8_18_16_,
|
879 |
|
|
p1_.license as license9_18_16_,
|
880 |
|
|
p1_.publisher as publish16_18_16_,
|
881 |
|
|
p1_.repository as reposit10_18_16_,
|
882 |
|
|
p1_.source as source11_18_16_,
|
883 |
|
|
p1_.subjects as subject12_18_16_,
|
884 |
|
|
p1_.title as title13_18_16_,
|
885 |
|
|
p1_.type as type14_18_16_,
|
886 |
46308
|
panagiotis
|
journal20_.id as id1_14_17_,
|
887 |
|
|
journal20_.alttitle as alttitle2_14_17_,
|
888 |
|
|
journal20_.apc as apc3_14_17_,
|
889 |
|
|
journal20_.apccurrency as apccurre4_14_17_,
|
890 |
|
|
journal20_.country as country15_14_17_,
|
891 |
|
|
journal20_.discount as discount5_14_17_,
|
892 |
|
|
journal20_.issn as issn6_14_17_,
|
893 |
|
|
journal20_.languages as language7_14_17_,
|
894 |
|
|
journal20_.licence as licence8_14_17_,
|
895 |
|
|
journal20_.publisher as publish16_14_17_,
|
896 |
|
|
journal20_.source as source9_14_17_,
|
897 |
|
|
journal20_.status as status10_14_17_,
|
898 |
|
|
journal20_.subjects as subject11_14_17_,
|
899 |
|
|
journal20_.title as title12_14_17_,
|
900 |
|
|
journal20_.type as type13_14_17_,
|
901 |
|
|
journal20_.url as url14_14_17_,
|
902 |
46350
|
panagiotis
|
publisher21_.id as id1_19_18_,
|
903 |
|
|
publisher21_.apc as apc2_19_18_,
|
904 |
|
|
publisher21_.apcCurrency as apcCurre3_19_18_,
|
905 |
|
|
publisher21_.bankAccount as bankAcco8_19_18_,
|
906 |
|
|
publisher21_.contact as contact9_19_18_,
|
907 |
|
|
publisher21_.discount as discount4_19_18_,
|
908 |
|
|
publisher21_.email as email5_19_18_,
|
909 |
|
|
publisher21_.name as name6_19_18_,
|
910 |
|
|
publisher21_.source as source7_19_18_,
|
911 |
46308
|
panagiotis
|
publisher22_.id as id1_19_19_,
|
912 |
|
|
publisher22_.apc as apc2_19_19_,
|
913 |
|
|
publisher22_.apcCurrency as apcCurre3_19_19_,
|
914 |
|
|
publisher22_.bankAccount as bankAcco8_19_19_,
|
915 |
|
|
publisher22_.contact as contact9_19_19_,
|
916 |
|
|
publisher22_.discount as discount4_19_19_,
|
917 |
|
|
publisher22_.email as email5_19_19_,
|
918 |
|
|
publisher22_.name as name6_19_19_,
|
919 |
|
|
publisher22_.source as source7_19_19_,
|
920 |
46350
|
panagiotis
|
user23_.email as email1_22_20_,
|
921 |
|
|
user23_.active as active2_22_20_,
|
922 |
|
|
user23_.firstname as firstnam3_22_20_,
|
923 |
|
|
user23_.id as id4_22_20_,
|
924 |
|
|
user23_.initials as initials5_22_20_,
|
925 |
|
|
user23_.lastname as lastname6_22_20_,
|
926 |
|
|
user23_.orcidid as orcidid7_22_20_,
|
927 |
|
|
user23_.password as password8_22_20_,
|
928 |
|
|
user23_.source as source9_22_20_,
|
929 |
|
|
user23_.telephone as telepho10_22_20_,
|
930 |
|
|
user24_.email as email1_22_21_,
|
931 |
|
|
user24_.active as active2_22_21_,
|
932 |
|
|
user24_.firstname as firstnam3_22_21_,
|
933 |
|
|
user24_.id as id4_22_21_,
|
934 |
|
|
user24_.initials as initials5_22_21_,
|
935 |
|
|
user24_.lastname as lastname6_22_21_,
|
936 |
|
|
user24_.orcidid as orcidid7_22_21_,
|
937 |
|
|
user24_.password as password8_22_21_,
|
938 |
|
|
user24_.source as source9_22_21_,
|
939 |
|
|
user24_.telephone as telepho10_22_21_
|
940 |
46308
|
panagiotis
|
from
|
941 |
|
|
Request this_
|
942 |
|
|
left outer join
|
943 |
|
|
BankAccount bankaccoun3_
|
944 |
|
|
on this_.bankAccount=bankaccoun3_.id
|
945 |
|
|
left outer join
|
946 |
|
|
BankTransferReceipt banktransf4_
|
947 |
|
|
on this_.bankTransferReceipt=banktransf4_.id
|
948 |
|
|
left outer join
|
949 |
|
|
Budget budget5_
|
950 |
|
|
on this_.budget=budget5_.id
|
951 |
|
|
left outer join
|
952 |
46350
|
panagiotis
|
Organization organizati6_
|
953 |
|
|
on budget5_.organization=organizati6_.id
|
954 |
46308
|
panagiotis
|
left outer join
|
955 |
46350
|
panagiotis
|
Country country7_
|
956 |
|
|
on organizati6_.country=country7_.id
|
957 |
46308
|
panagiotis
|
left outer join
|
958 |
46350
|
panagiotis
|
Publisher publisher8_
|
959 |
|
|
on budget5_.publisher=publisher8_.id
|
960 |
46308
|
panagiotis
|
left outer join
|
961 |
46350
|
panagiotis
|
BankAccount bankaccoun9_
|
962 |
|
|
on publisher8_.bankAccount=bankaccoun9_.id
|
963 |
46308
|
panagiotis
|
left outer join
|
964 |
46350
|
panagiotis
|
"user" user10_
|
965 |
|
|
on publisher8_.contact=user10_.email
|
966 |
46308
|
panagiotis
|
left outer join
|
967 |
46350
|
panagiotis
|
"user" user11_
|
968 |
|
|
on budget5_."user"=user11_.email
|
969 |
46308
|
panagiotis
|
left outer join
|
970 |
46350
|
panagiotis
|
Invoice invoice12_
|
971 |
|
|
on this_.invoice=invoice12_.id
|
972 |
46308
|
panagiotis
|
left outer join
|
973 |
46350
|
panagiotis
|
File file13_
|
974 |
|
|
on invoice12_.file=file13_.id
|
975 |
46308
|
panagiotis
|
left outer join
|
976 |
46350
|
panagiotis
|
Journal journal14_
|
977 |
|
|
on this_.journal=journal14_.id
|
978 |
46308
|
panagiotis
|
left outer join
|
979 |
46350
|
panagiotis
|
Country country15_
|
980 |
|
|
on journal14_.country=country15_.id
|
981 |
46308
|
panagiotis
|
left outer join
|
982 |
46350
|
panagiotis
|
Publisher publisher16_
|
983 |
|
|
on journal14_.publisher=publisher16_.id
|
984 |
46308
|
panagiotis
|
left outer join
|
985 |
46350
|
panagiotis
|
Organization organizati17_
|
986 |
|
|
on this_.organization=organizati17_.id
|
987 |
46308
|
panagiotis
|
left outer join
|
988 |
46350
|
panagiotis
|
Project project18_
|
989 |
|
|
on this_.project=project18_.id
|
990 |
46308
|
panagiotis
|
inner join
|
991 |
|
|
Publication p1_
|
992 |
|
|
on this_.publication=p1_.id
|
993 |
|
|
left outer join
|
994 |
46350
|
panagiotis
|
Journal journal20_
|
995 |
|
|
on p1_.journal=journal20_.id
|
996 |
46308
|
panagiotis
|
left outer join
|
997 |
46350
|
panagiotis
|
Publisher publisher21_
|
998 |
|
|
on p1_.publisher=publisher21_.id
|
999 |
46308
|
panagiotis
|
left outer join
|
1000 |
46350
|
panagiotis
|
Publisher publisher22_
|
1001 |
|
|
on this_.publisher=publisher22_.id
|
1002 |
46308
|
panagiotis
|
left outer join
|
1003 |
46350
|
panagiotis
|
"user" user23_
|
1004 |
|
|
on this_.researcher=user23_.email
|
1005 |
46308
|
panagiotis
|
left outer join
|
1006 |
46350
|
panagiotis
|
"user" user24_
|
1007 |
|
|
on this_."user"=user24_.email
|
1008 |
46308
|
panagiotis
|
where
|
1009 |
|
|
p1_.type=?
|
1010 |
|
|
and this_.status=?
|
1011 |
|
|
Hibernate:
|
1012 |
|
|
select
|
1013 |
|
|
avg(this_.apcPaid) as y0_
|
1014 |
|
|
from
|
1015 |
|
|
Request this_
|
1016 |
|
|
inner join
|
1017 |
|
|
Publication p1_
|
1018 |
|
|
on this_.publication=p1_.id
|
1019 |
|
|
where
|
1020 |
|
|
p1_.type=?
|
1021 |
|
|
Hibernate:
|
1022 |
|
|
select
|
1023 |
|
|
avg(this_.apcPaid) as y0_
|
1024 |
|
|
from
|
1025 |
|
|
Request this_
|
1026 |
|
|
inner join
|
1027 |
|
|
Publication p1_
|
1028 |
|
|
on this_.publication=p1_.id
|
1029 |
|
|
where
|
1030 |
|
|
p1_.type=?
|
1031 |
|
|
Hibernate:
|
1032 |
|
|
select
|
1033 |
46350
|
panagiotis
|
this_.id as id1_20_22_,
|
1034 |
|
|
this_.apc as apc2_20_22_,
|
1035 |
|
|
this_.apcPaid as apcPaid3_20_22_,
|
1036 |
|
|
this_.approvaldate as approval4_20_22_,
|
1037 |
|
|
this_.bankAccount as bankAcc16_20_22_,
|
1038 |
|
|
this_.bankTransferReceipt as bankTra17_20_22_,
|
1039 |
|
|
this_.budget as budget18_20_22_,
|
1040 |
|
|
this_.currency as currency5_20_22_,
|
1041 |
|
|
this_.date as date6_20_22_,
|
1042 |
|
|
this_.datePaid as datePaid7_20_22_,
|
1043 |
|
|
this_.discount as discount8_20_22_,
|
1044 |
|
|
this_.fundingrequested as fundingr9_20_22_,
|
1045 |
|
|
this_.invoice as invoice19_20_22_,
|
1046 |
|
|
this_.journal as journal20_20_22_,
|
1047 |
|
|
this_.organization as organiz21_20_22_,
|
1048 |
|
|
this_.otherCost as otherCo10_20_22_,
|
1049 |
|
|
this_.project as project22_20_22_,
|
1050 |
|
|
this_.projectparticipation as project11_20_22_,
|
1051 |
|
|
this_.publication as publica23_20_22_,
|
1052 |
|
|
this_.publisher as publish24_20_22_,
|
1053 |
|
|
this_.publisher_email as publish12_20_22_,
|
1054 |
|
|
this_.researcher as researc25_20_22_,
|
1055 |
|
|
this_.status as status13_20_22_,
|
1056 |
|
|
this_.submissiondate as submiss14_20_22_,
|
1057 |
|
|
this_.transferCost as transfe15_20_22_,
|
1058 |
|
|
this_."user" as user26_20_22_,
|
1059 |
46308
|
panagiotis
|
bankaccoun2_.id as id1_2_0_,
|
1060 |
|
|
bankaccoun2_.accountHolder as accountH2_2_0_,
|
1061 |
|
|
bankaccoun2_.bankAddress as bankAddr3_2_0_,
|
1062 |
|
|
bankaccoun2_.bankCode as bankCode4_2_0_,
|
1063 |
|
|
bankaccoun2_.bankName as bankName5_2_0_,
|
1064 |
|
|
bankaccoun2_.iban as iban6_2_0_,
|
1065 |
|
|
banktransf3_.id as id1_3_1_,
|
1066 |
|
|
banktransf3_.content as content2_3_1_,
|
1067 |
|
|
banktransf3_.contentType as contentT3_3_1_,
|
1068 |
|
|
budget4_.id as id1_4_2_,
|
1069 |
|
|
budget4_.amountGranted as amountGr2_4_2_,
|
1070 |
|
|
budget4_.amountRequested as amountRe3_4_2_,
|
1071 |
|
|
budget4_.bankAccount as bankAcc13_4_2_,
|
1072 |
|
|
budget4_.bankReceipt as bankRec14_4_2_,
|
1073 |
|
|
budget4_.beneficiarysignedcontract as benefic15_4_2_,
|
1074 |
|
|
budget4_.currency as currency4_4_2_,
|
1075 |
|
|
budget4_.date as date5_4_2_,
|
1076 |
|
|
budget4_.datePaid as datePaid6_4_2_,
|
1077 |
|
|
budget4_.enddate as enddate7_4_2_,
|
1078 |
|
|
budget4_.initialcontractfile as initial16_4_2_,
|
1079 |
|
|
budget4_.invoice as invoice17_4_2_,
|
1080 |
|
|
budget4_.organization as organiz18_4_2_,
|
1081 |
|
|
budget4_.otherCost as otherCos8_4_2_,
|
1082 |
|
|
budget4_.publisher as publish19_4_2_,
|
1083 |
|
|
budget4_.remaining as remainin9_4_2_,
|
1084 |
|
|
budget4_.signedcontract as signedc20_4_2_,
|
1085 |
|
|
budget4_.startdate as startda10_4_2_,
|
1086 |
|
|
budget4_.status as status11_4_2_,
|
1087 |
|
|
budget4_.transferCost as transfe12_4_2_,
|
1088 |
|
|
budget4_."user" as user21_4_2_,
|
1089 |
46350
|
panagiotis
|
organizati5_.id as id1_16_3_,
|
1090 |
|
|
organizati5_.country as country5_16_3_,
|
1091 |
|
|
organizati5_.name as name2_16_3_,
|
1092 |
|
|
organizati5_.shortname as shortnam3_16_3_,
|
1093 |
|
|
organizati5_.source as source4_16_3_,
|
1094 |
|
|
country6_.id as id1_9_4_,
|
1095 |
|
|
country6_.name as name2_9_4_,
|
1096 |
|
|
publisher7_.id as id1_19_5_,
|
1097 |
|
|
publisher7_.apc as apc2_19_5_,
|
1098 |
|
|
publisher7_.apcCurrency as apcCurre3_19_5_,
|
1099 |
|
|
publisher7_.bankAccount as bankAcco8_19_5_,
|
1100 |
|
|
publisher7_.contact as contact9_19_5_,
|
1101 |
|
|
publisher7_.discount as discount4_19_5_,
|
1102 |
|
|
publisher7_.email as email5_19_5_,
|
1103 |
|
|
publisher7_.name as name6_19_5_,
|
1104 |
|
|
publisher7_.source as source7_19_5_,
|
1105 |
|
|
bankaccoun8_.id as id1_2_6_,
|
1106 |
|
|
bankaccoun8_.accountHolder as accountH2_2_6_,
|
1107 |
|
|
bankaccoun8_.bankAddress as bankAddr3_2_6_,
|
1108 |
|
|
bankaccoun8_.bankCode as bankCode4_2_6_,
|
1109 |
|
|
bankaccoun8_.bankName as bankName5_2_6_,
|
1110 |
|
|
bankaccoun8_.iban as iban6_2_6_,
|
1111 |
|
|
user9_.email as email1_22_7_,
|
1112 |
|
|
user9_.active as active2_22_7_,
|
1113 |
|
|
user9_.firstname as firstnam3_22_7_,
|
1114 |
|
|
user9_.id as id4_22_7_,
|
1115 |
|
|
user9_.initials as initials5_22_7_,
|
1116 |
|
|
user9_.lastname as lastname6_22_7_,
|
1117 |
|
|
user9_.orcidid as orcidid7_22_7_,
|
1118 |
|
|
user9_.password as password8_22_7_,
|
1119 |
|
|
user9_.source as source9_22_7_,
|
1120 |
|
|
user9_.telephone as telepho10_22_7_,
|
1121 |
|
|
user10_.email as email1_22_8_,
|
1122 |
|
|
user10_.active as active2_22_8_,
|
1123 |
|
|
user10_.firstname as firstnam3_22_8_,
|
1124 |
|
|
user10_.id as id4_22_8_,
|
1125 |
|
|
user10_.initials as initials5_22_8_,
|
1126 |
|
|
user10_.lastname as lastname6_22_8_,
|
1127 |
|
|
user10_.orcidid as orcidid7_22_8_,
|
1128 |
|
|
user10_.password as password8_22_8_,
|
1129 |
|
|
user10_.source as source9_22_8_,
|
1130 |
|
|
user10_.telephone as telepho10_22_8_,
|
1131 |
|
|
invoice11_.id as id1_13_9_,
|
1132 |
|
|
invoice11_.alternativeid as alternat2_13_9_,
|
1133 |
|
|
invoice11_.date as date3_13_9_,
|
1134 |
|
|
invoice11_.file as file7_13_9_,
|
1135 |
|
|
invoice11_.number as number4_13_9_,
|
1136 |
|
|
invoice11_.source as source5_13_9_,
|
1137 |
|
|
invoice11_.status as status6_13_9_,
|
1138 |
|
|
file12_.id as id1_10_10_,
|
1139 |
|
|
file12_.file as file2_10_10_,
|
1140 |
|
|
file12_.mimetype as mimetype3_10_10_,
|
1141 |
|
|
journal13_.id as id1_14_11_,
|
1142 |
|
|
journal13_.alttitle as alttitle2_14_11_,
|
1143 |
|
|
journal13_.apc as apc3_14_11_,
|
1144 |
|
|
journal13_.apccurrency as apccurre4_14_11_,
|
1145 |
|
|
journal13_.country as country15_14_11_,
|
1146 |
|
|
journal13_.discount as discount5_14_11_,
|
1147 |
|
|
journal13_.issn as issn6_14_11_,
|
1148 |
|
|
journal13_.languages as language7_14_11_,
|
1149 |
|
|
journal13_.licence as licence8_14_11_,
|
1150 |
|
|
journal13_.publisher as publish16_14_11_,
|
1151 |
|
|
journal13_.source as source9_14_11_,
|
1152 |
|
|
journal13_.status as status10_14_11_,
|
1153 |
|
|
journal13_.subjects as subject11_14_11_,
|
1154 |
|
|
journal13_.title as title12_14_11_,
|
1155 |
|
|
journal13_.type as type13_14_11_,
|
1156 |
|
|
journal13_.url as url14_14_11_,
|
1157 |
|
|
country14_.id as id1_9_12_,
|
1158 |
|
|
country14_.name as name2_9_12_,
|
1159 |
|
|
publisher15_.id as id1_19_13_,
|
1160 |
|
|
publisher15_.apc as apc2_19_13_,
|
1161 |
|
|
publisher15_.apcCurrency as apcCurre3_19_13_,
|
1162 |
|
|
publisher15_.bankAccount as bankAcco8_19_13_,
|
1163 |
|
|
publisher15_.contact as contact9_19_13_,
|
1164 |
|
|
publisher15_.discount as discount4_19_13_,
|
1165 |
|
|
publisher15_.email as email5_19_13_,
|
1166 |
|
|
publisher15_.name as name6_19_13_,
|
1167 |
|
|
publisher15_.source as source7_19_13_,
|
1168 |
|
|
organizati16_.id as id1_16_14_,
|
1169 |
|
|
organizati16_.country as country5_16_14_,
|
1170 |
|
|
organizati16_.name as name2_16_14_,
|
1171 |
|
|
organizati16_.shortname as shortnam3_16_14_,
|
1172 |
|
|
organizati16_.source as source4_16_14_,
|
1173 |
|
|
project17_.id as id1_17_15_,
|
1174 |
|
|
project17_.acronym as acronym2_17_15_,
|
1175 |
|
|
project17_.call as call3_17_15_,
|
1176 |
|
|
project17_.enddate as enddate4_17_15_,
|
1177 |
|
|
project17_.funder as funder5_17_15_,
|
1178 |
|
|
project17_.fundingstream as fundings6_17_15_,
|
1179 |
|
|
project17_."grant" as grant7_17_15_,
|
1180 |
|
|
project17_.sc39 as sc8_17_15_,
|
1181 |
|
|
project17_.scientificarea as scientif9_17_15_,
|
1182 |
|
|
project17_.source as source10_17_15_,
|
1183 |
|
|
project17_.startdate as startda11_17_15_,
|
1184 |
|
|
project17_.title as title12_17_15_,
|
1185 |
|
|
project17_.url as url13_17_15_,
|
1186 |
|
|
publicatio18_.id as id1_18_16_,
|
1187 |
|
|
publicatio18_.acceptancedate as acceptan2_18_16_,
|
1188 |
|
|
publicatio18_.alternativedoi as alternat3_18_16_,
|
1189 |
|
|
publicatio18_.alternativetitle as alternat4_18_16_,
|
1190 |
|
|
publicatio18_.date as date5_18_16_,
|
1191 |
|
|
publicatio18_.doi as doi6_18_16_,
|
1192 |
|
|
publicatio18_.eventdetails as eventdet7_18_16_,
|
1193 |
|
|
publicatio18_.journal as journal15_18_16_,
|
1194 |
|
|
publicatio18_.languages as language8_18_16_,
|
1195 |
|
|
publicatio18_.license as license9_18_16_,
|
1196 |
|
|
publicatio18_.publisher as publish16_18_16_,
|
1197 |
|
|
publicatio18_.repository as reposit10_18_16_,
|
1198 |
|
|
publicatio18_.source as source11_18_16_,
|
1199 |
|
|
publicatio18_.subjects as subject12_18_16_,
|
1200 |
|
|
publicatio18_.title as title13_18_16_,
|
1201 |
|
|
publicatio18_.type as type14_18_16_,
|
1202 |
46308
|
panagiotis
|
journal19_.id as id1_14_17_,
|
1203 |
|
|
journal19_.alttitle as alttitle2_14_17_,
|
1204 |
|
|
journal19_.apc as apc3_14_17_,
|
1205 |
|
|
journal19_.apccurrency as apccurre4_14_17_,
|
1206 |
|
|
journal19_.country as country15_14_17_,
|
1207 |
|
|
journal19_.discount as discount5_14_17_,
|
1208 |
|
|
journal19_.issn as issn6_14_17_,
|
1209 |
|
|
journal19_.languages as language7_14_17_,
|
1210 |
|
|
journal19_.licence as licence8_14_17_,
|
1211 |
|
|
journal19_.publisher as publish16_14_17_,
|
1212 |
|
|
journal19_.source as source9_14_17_,
|
1213 |
|
|
journal19_.status as status10_14_17_,
|
1214 |
|
|
journal19_.subjects as subject11_14_17_,
|
1215 |
|
|
journal19_.title as title12_14_17_,
|
1216 |
|
|
journal19_.type as type13_14_17_,
|
1217 |
|
|
journal19_.url as url14_14_17_,
|
1218 |
46350
|
panagiotis
|
publisher20_.id as id1_19_18_,
|
1219 |
|
|
publisher20_.apc as apc2_19_18_,
|
1220 |
|
|
publisher20_.apcCurrency as apcCurre3_19_18_,
|
1221 |
|
|
publisher20_.bankAccount as bankAcco8_19_18_,
|
1222 |
|
|
publisher20_.contact as contact9_19_18_,
|
1223 |
|
|
publisher20_.discount as discount4_19_18_,
|
1224 |
|
|
publisher20_.email as email5_19_18_,
|
1225 |
|
|
publisher20_.name as name6_19_18_,
|
1226 |
|
|
publisher20_.source as source7_19_18_,
|
1227 |
46308
|
panagiotis
|
publisher21_.id as id1_19_19_,
|
1228 |
|
|
publisher21_.apc as apc2_19_19_,
|
1229 |
|
|
publisher21_.apcCurrency as apcCurre3_19_19_,
|
1230 |
|
|
publisher21_.bankAccount as bankAcco8_19_19_,
|
1231 |
|
|
publisher21_.contact as contact9_19_19_,
|
1232 |
|
|
publisher21_.discount as discount4_19_19_,
|
1233 |
|
|
publisher21_.email as email5_19_19_,
|
1234 |
|
|
publisher21_.name as name6_19_19_,
|
1235 |
|
|
publisher21_.source as source7_19_19_,
|
1236 |
46350
|
panagiotis
|
user22_.email as email1_22_20_,
|
1237 |
|
|
user22_.active as active2_22_20_,
|
1238 |
|
|
user22_.firstname as firstnam3_22_20_,
|
1239 |
|
|
user22_.id as id4_22_20_,
|
1240 |
|
|
user22_.initials as initials5_22_20_,
|
1241 |
|
|
user22_.lastname as lastname6_22_20_,
|
1242 |
|
|
user22_.orcidid as orcidid7_22_20_,
|
1243 |
|
|
user22_.password as password8_22_20_,
|
1244 |
|
|
user22_.source as source9_22_20_,
|
1245 |
|
|
user22_.telephone as telepho10_22_20_,
|
1246 |
|
|
user23_.email as email1_22_21_,
|
1247 |
|
|
user23_.active as active2_22_21_,
|
1248 |
|
|
user23_.firstname as firstnam3_22_21_,
|
1249 |
|
|
user23_.id as id4_22_21_,
|
1250 |
|
|
user23_.initials as initials5_22_21_,
|
1251 |
|
|
user23_.lastname as lastname6_22_21_,
|
1252 |
|
|
user23_.orcidid as orcidid7_22_21_,
|
1253 |
|
|
user23_.password as password8_22_21_,
|
1254 |
|
|
user23_.source as source9_22_21_,
|
1255 |
|
|
user23_.telephone as telepho10_22_21_
|
1256 |
46308
|
panagiotis
|
from
|
1257 |
|
|
Request this_
|
1258 |
|
|
left outer join
|
1259 |
|
|
BankAccount bankaccoun2_
|
1260 |
|
|
on this_.bankAccount=bankaccoun2_.id
|
1261 |
|
|
left outer join
|
1262 |
|
|
BankTransferReceipt banktransf3_
|
1263 |
|
|
on this_.bankTransferReceipt=banktransf3_.id
|
1264 |
|
|
left outer join
|
1265 |
|
|
Budget budget4_
|
1266 |
|
|
on this_.budget=budget4_.id
|
1267 |
|
|
left outer join
|
1268 |
46350
|
panagiotis
|
Organization organizati5_
|
1269 |
|
|
on budget4_.organization=organizati5_.id
|
1270 |
46308
|
panagiotis
|
left outer join
|
1271 |
46350
|
panagiotis
|
Country country6_
|
1272 |
|
|
on organizati5_.country=country6_.id
|
1273 |
46308
|
panagiotis
|
left outer join
|
1274 |
46350
|
panagiotis
|
Publisher publisher7_
|
1275 |
|
|
on budget4_.publisher=publisher7_.id
|
1276 |
46308
|
panagiotis
|
left outer join
|
1277 |
46350
|
panagiotis
|
BankAccount bankaccoun8_
|
1278 |
|
|
on publisher7_.bankAccount=bankaccoun8_.id
|
1279 |
46308
|
panagiotis
|
left outer join
|
1280 |
46350
|
panagiotis
|
"user" user9_
|
1281 |
|
|
on publisher7_.contact=user9_.email
|
1282 |
46308
|
panagiotis
|
left outer join
|
1283 |
46350
|
panagiotis
|
"user" user10_
|
1284 |
|
|
on budget4_."user"=user10_.email
|
1285 |
46308
|
panagiotis
|
left outer join
|
1286 |
46350
|
panagiotis
|
Invoice invoice11_
|
1287 |
|
|
on this_.invoice=invoice11_.id
|
1288 |
46308
|
panagiotis
|
left outer join
|
1289 |
46350
|
panagiotis
|
File file12_
|
1290 |
|
|
on invoice11_.file=file12_.id
|
1291 |
46308
|
panagiotis
|
left outer join
|
1292 |
46350
|
panagiotis
|
Journal journal13_
|
1293 |
|
|
on this_.journal=journal13_.id
|
1294 |
46308
|
panagiotis
|
left outer join
|
1295 |
46350
|
panagiotis
|
Country country14_
|
1296 |
|
|
on journal13_.country=country14_.id
|
1297 |
46308
|
panagiotis
|
left outer join
|
1298 |
46350
|
panagiotis
|
Publisher publisher15_
|
1299 |
|
|
on journal13_.publisher=publisher15_.id
|
1300 |
46308
|
panagiotis
|
left outer join
|
1301 |
46350
|
panagiotis
|
Organization organizati16_
|
1302 |
|
|
on this_.organization=organizati16_.id
|
1303 |
46308
|
panagiotis
|
left outer join
|
1304 |
46350
|
panagiotis
|
Project project17_
|
1305 |
|
|
on this_.project=project17_.id
|
1306 |
46308
|
panagiotis
|
left outer join
|
1307 |
46350
|
panagiotis
|
Publication publicatio18_
|
1308 |
|
|
on this_.publication=publicatio18_.id
|
1309 |
46308
|
panagiotis
|
left outer join
|
1310 |
|
|
Journal journal19_
|
1311 |
46350
|
panagiotis
|
on publicatio18_.journal=journal19_.id
|
1312 |
46308
|
panagiotis
|
left outer join
|
1313 |
46350
|
panagiotis
|
Publisher publisher20_
|
1314 |
|
|
on publicatio18_.publisher=publisher20_.id
|
1315 |
46308
|
panagiotis
|
left outer join
|
1316 |
|
|
Publisher publisher21_
|
1317 |
46350
|
panagiotis
|
on this_.publisher=publisher21_.id
|
1318 |
46308
|
panagiotis
|
left outer join
|
1319 |
46350
|
panagiotis
|
"user" user22_
|
1320 |
|
|
on this_.researcher=user22_.email
|
1321 |
46308
|
panagiotis
|
left outer join
|
1322 |
46350
|
panagiotis
|
"user" user23_
|
1323 |
|
|
on this_."user"=user23_.email
|
1324 |
46308
|
panagiotis
|
where
|
1325 |
|
|
this_.status in (
|
1326 |
|
|
?, ?, ?, ?, ?
|
1327 |
|
|
)
|
1328 |
|
|
Hibernate:
|
1329 |
|
|
select
|
1330 |
46350
|
panagiotis
|
this_.id as id1_20_22_,
|
1331 |
|
|
this_.apc as apc2_20_22_,
|
1332 |
|
|
this_.apcPaid as apcPaid3_20_22_,
|
1333 |
|
|
this_.approvaldate as approval4_20_22_,
|
1334 |
|
|
this_.bankAccount as bankAcc16_20_22_,
|
1335 |
|
|
this_.bankTransferReceipt as bankTra17_20_22_,
|
1336 |
|
|
this_.budget as budget18_20_22_,
|
1337 |
|
|
this_.currency as currency5_20_22_,
|
1338 |
|
|
this_.date as date6_20_22_,
|
1339 |
|
|
this_.datePaid as datePaid7_20_22_,
|
1340 |
|
|
this_.discount as discount8_20_22_,
|
1341 |
|
|
this_.fundingrequested as fundingr9_20_22_,
|
1342 |
|
|
this_.invoice as invoice19_20_22_,
|
1343 |
|
|
this_.journal as journal20_20_22_,
|
1344 |
|
|
this_.organization as organiz21_20_22_,
|
1345 |
|
|
this_.otherCost as otherCo10_20_22_,
|
1346 |
|
|
this_.project as project22_20_22_,
|
1347 |
|
|
this_.projectparticipation as project11_20_22_,
|
1348 |
|
|
this_.publication as publica23_20_22_,
|
1349 |
|
|
this_.publisher as publish24_20_22_,
|
1350 |
|
|
this_.publisher_email as publish12_20_22_,
|
1351 |
|
|
this_.researcher as researc25_20_22_,
|
1352 |
|
|
this_.status as status13_20_22_,
|
1353 |
|
|
this_.submissiondate as submiss14_20_22_,
|
1354 |
|
|
this_.transferCost as transfe15_20_22_,
|
1355 |
|
|
this_."user" as user26_20_22_,
|
1356 |
46308
|
panagiotis
|
bankaccoun3_.id as id1_2_0_,
|
1357 |
|
|
bankaccoun3_.accountHolder as accountH2_2_0_,
|
1358 |
|
|
bankaccoun3_.bankAddress as bankAddr3_2_0_,
|
1359 |
|
|
bankaccoun3_.bankCode as bankCode4_2_0_,
|
1360 |
|
|
bankaccoun3_.bankName as bankName5_2_0_,
|
1361 |
|
|
bankaccoun3_.iban as iban6_2_0_,
|
1362 |
|
|
banktransf4_.id as id1_3_1_,
|
1363 |
|
|
banktransf4_.content as content2_3_1_,
|
1364 |
|
|
banktransf4_.contentType as contentT3_3_1_,
|
1365 |
|
|
budget5_.id as id1_4_2_,
|
1366 |
|
|
budget5_.amountGranted as amountGr2_4_2_,
|
1367 |
|
|
budget5_.amountRequested as amountRe3_4_2_,
|
1368 |
|
|
budget5_.bankAccount as bankAcc13_4_2_,
|
1369 |
|
|
budget5_.bankReceipt as bankRec14_4_2_,
|
1370 |
|
|
budget5_.beneficiarysignedcontract as benefic15_4_2_,
|
1371 |
|
|
budget5_.currency as currency4_4_2_,
|
1372 |
|
|
budget5_.date as date5_4_2_,
|
1373 |
|
|
budget5_.datePaid as datePaid6_4_2_,
|
1374 |
|
|
budget5_.enddate as enddate7_4_2_,
|
1375 |
|
|
budget5_.initialcontractfile as initial16_4_2_,
|
1376 |
|
|
budget5_.invoice as invoice17_4_2_,
|
1377 |
|
|
budget5_.organization as organiz18_4_2_,
|
1378 |
|
|
budget5_.otherCost as otherCos8_4_2_,
|
1379 |
|
|
budget5_.publisher as publish19_4_2_,
|
1380 |
|
|
budget5_.remaining as remainin9_4_2_,
|
1381 |
|
|
budget5_.signedcontract as signedc20_4_2_,
|
1382 |
|
|
budget5_.startdate as startda10_4_2_,
|
1383 |
|
|
budget5_.status as status11_4_2_,
|
1384 |
|
|
budget5_.transferCost as transfe12_4_2_,
|
1385 |
|
|
budget5_."user" as user21_4_2_,
|
1386 |
46350
|
panagiotis
|
organizati6_.id as id1_16_3_,
|
1387 |
|
|
organizati6_.country as country5_16_3_,
|
1388 |
|
|
organizati6_.name as name2_16_3_,
|
1389 |
|
|
organizati6_.shortname as shortnam3_16_3_,
|
1390 |
|
|
organizati6_.source as source4_16_3_,
|
1391 |
|
|
country7_.id as id1_9_4_,
|
1392 |
|
|
country7_.name as name2_9_4_,
|
1393 |
|
|
publisher8_.id as id1_19_5_,
|
1394 |
|
|
publisher8_.apc as apc2_19_5_,
|
1395 |
|
|
publisher8_.apcCurrency as apcCurre3_19_5_,
|
1396 |
|
|
publisher8_.bankAccount as bankAcco8_19_5_,
|
1397 |
|
|
publisher8_.contact as contact9_19_5_,
|
1398 |
|
|
publisher8_.discount as discount4_19_5_,
|
1399 |
|
|
publisher8_.email as email5_19_5_,
|
1400 |
|
|
publisher8_.name as name6_19_5_,
|
1401 |
|
|
publisher8_.source as source7_19_5_,
|
1402 |
|
|
bankaccoun9_.id as id1_2_6_,
|
1403 |
|
|
bankaccoun9_.accountHolder as accountH2_2_6_,
|
1404 |
|
|
bankaccoun9_.bankAddress as bankAddr3_2_6_,
|
1405 |
|
|
bankaccoun9_.bankCode as bankCode4_2_6_,
|
1406 |
|
|
bankaccoun9_.bankName as bankName5_2_6_,
|
1407 |
|
|
bankaccoun9_.iban as iban6_2_6_,
|
1408 |
|
|
user10_.email as email1_22_7_,
|
1409 |
|
|
user10_.active as active2_22_7_,
|
1410 |
|
|
user10_.firstname as firstnam3_22_7_,
|
1411 |
|
|
user10_.id as id4_22_7_,
|
1412 |
|
|
user10_.initials as initials5_22_7_,
|
1413 |
|
|
user10_.lastname as lastname6_22_7_,
|
1414 |
|
|
user10_.orcidid as orcidid7_22_7_,
|
1415 |
|
|
user10_.password as password8_22_7_,
|
1416 |
|
|
user10_.source as source9_22_7_,
|
1417 |
|
|
user10_.telephone as telepho10_22_7_,
|
1418 |
|
|
user11_.email as email1_22_8_,
|
1419 |
|
|
user11_.active as active2_22_8_,
|
1420 |
|
|
user11_.firstname as firstnam3_22_8_,
|
1421 |
|
|
user11_.id as id4_22_8_,
|
1422 |
|
|
user11_.initials as initials5_22_8_,
|
1423 |
|
|
user11_.lastname as lastname6_22_8_,
|
1424 |
|
|
user11_.orcidid as orcidid7_22_8_,
|
1425 |
|
|
user11_.password as password8_22_8_,
|
1426 |
|
|
user11_.source as source9_22_8_,
|
1427 |
|
|
user11_.telephone as telepho10_22_8_,
|
1428 |
|
|
invoice12_.id as id1_13_9_,
|
1429 |
|
|
invoice12_.alternativeid as alternat2_13_9_,
|
1430 |
|
|
invoice12_.date as date3_13_9_,
|
1431 |
|
|
invoice12_.file as file7_13_9_,
|
1432 |
|
|
invoice12_.number as number4_13_9_,
|
1433 |
|
|
invoice12_.source as source5_13_9_,
|
1434 |
|
|
invoice12_.status as status6_13_9_,
|
1435 |
|
|
file13_.id as id1_10_10_,
|
1436 |
|
|
file13_.file as file2_10_10_,
|
1437 |
|
|
file13_.mimetype as mimetype3_10_10_,
|
1438 |
|
|
journal14_.id as id1_14_11_,
|
1439 |
|
|
journal14_.alttitle as alttitle2_14_11_,
|
1440 |
|
|
journal14_.apc as apc3_14_11_,
|
1441 |
|
|
journal14_.apccurrency as apccurre4_14_11_,
|
1442 |
|
|
journal14_.country as country15_14_11_,
|
1443 |
|
|
journal14_.discount as discount5_14_11_,
|
1444 |
|
|
journal14_.issn as issn6_14_11_,
|
1445 |
|
|
journal14_.languages as language7_14_11_,
|
1446 |
|
|
journal14_.licence as licence8_14_11_,
|
1447 |
|
|
journal14_.publisher as publish16_14_11_,
|
1448 |
|
|
journal14_.source as source9_14_11_,
|
1449 |
|
|
journal14_.status as status10_14_11_,
|
1450 |
|
|
journal14_.subjects as subject11_14_11_,
|
1451 |
|
|
journal14_.title as title12_14_11_,
|
1452 |
|
|
journal14_.type as type13_14_11_,
|
1453 |
|
|
journal14_.url as url14_14_11_,
|
1454 |
|
|
country15_.id as id1_9_12_,
|
1455 |
|
|
country15_.name as name2_9_12_,
|
1456 |
|
|
publisher16_.id as id1_19_13_,
|
1457 |
|
|
publisher16_.apc as apc2_19_13_,
|
1458 |
|
|
publisher16_.apcCurrency as apcCurre3_19_13_,
|
1459 |
|
|
publisher16_.bankAccount as bankAcco8_19_13_,
|
1460 |
|
|
publisher16_.contact as contact9_19_13_,
|
1461 |
|
|
publisher16_.discount as discount4_19_13_,
|
1462 |
|
|
publisher16_.email as email5_19_13_,
|
1463 |
|
|
publisher16_.name as name6_19_13_,
|
1464 |
|
|
publisher16_.source as source7_19_13_,
|
1465 |
|
|
organizati17_.id as id1_16_14_,
|
1466 |
|
|
organizati17_.country as country5_16_14_,
|
1467 |
|
|
organizati17_.name as name2_16_14_,
|
1468 |
|
|
organizati17_.shortname as shortnam3_16_14_,
|
1469 |
|
|
organizati17_.source as source4_16_14_,
|
1470 |
|
|
project18_.id as id1_17_15_,
|
1471 |
|
|
project18_.acronym as acronym2_17_15_,
|
1472 |
|
|
project18_.call as call3_17_15_,
|
1473 |
|
|
project18_.enddate as enddate4_17_15_,
|
1474 |
|
|
project18_.funder as funder5_17_15_,
|
1475 |
|
|
project18_.fundingstream as fundings6_17_15_,
|
1476 |
|
|
project18_."grant" as grant7_17_15_,
|
1477 |
|
|
project18_.sc39 as sc8_17_15_,
|
1478 |
|
|
project18_.scientificarea as scientif9_17_15_,
|
1479 |
|
|
project18_.source as source10_17_15_,
|
1480 |
|
|
project18_.startdate as startda11_17_15_,
|
1481 |
|
|
project18_.title as title12_17_15_,
|
1482 |
|
|
project18_.url as url13_17_15_,
|
1483 |
|
|
p1_.id as id1_18_16_,
|
1484 |
|
|
p1_.acceptancedate as acceptan2_18_16_,
|
1485 |
|
|
p1_.alternativedoi as alternat3_18_16_,
|
1486 |
|
|
p1_.alternativetitle as alternat4_18_16_,
|
1487 |
|
|
p1_.date as date5_18_16_,
|
1488 |
|
|
p1_.doi as doi6_18_16_,
|
1489 |
|
|
p1_.eventdetails as eventdet7_18_16_,
|
1490 |
|
|
p1_.journal as journal15_18_16_,
|
1491 |
|
|
p1_.languages as language8_18_16_,
|
1492 |
|
|
p1_.license as license9_18_16_,
|
1493 |
|
|
p1_.publisher as publish16_18_16_,
|
1494 |
|
|
p1_.repository as reposit10_18_16_,
|
1495 |
|
|
p1_.source as source11_18_16_,
|
1496 |
|
|
p1_.subjects as subject12_18_16_,
|
1497 |
|
|
p1_.title as title13_18_16_,
|
1498 |
|
|
p1_.type as type14_18_16_,
|
1499 |
46308
|
panagiotis
|
journal20_.id as id1_14_17_,
|
1500 |
|
|
journal20_.alttitle as alttitle2_14_17_,
|
1501 |
|
|
journal20_.apc as apc3_14_17_,
|
1502 |
|
|
journal20_.apccurrency as apccurre4_14_17_,
|
1503 |
|
|
journal20_.country as country15_14_17_,
|
1504 |
|
|
journal20_.discount as discount5_14_17_,
|
1505 |
|
|
journal20_.issn as issn6_14_17_,
|
1506 |
|
|
journal20_.languages as language7_14_17_,
|
1507 |
|
|
journal20_.licence as licence8_14_17_,
|
1508 |
|
|
journal20_.publisher as publish16_14_17_,
|
1509 |
|
|
journal20_.source as source9_14_17_,
|
1510 |
|
|
journal20_.status as status10_14_17_,
|
1511 |
|
|
journal20_.subjects as subject11_14_17_,
|
1512 |
|
|
journal20_.title as title12_14_17_,
|
1513 |
|
|
journal20_.type as type13_14_17_,
|
1514 |
|
|
journal20_.url as url14_14_17_,
|
1515 |
46350
|
panagiotis
|
publisher21_.id as id1_19_18_,
|
1516 |
|
|
publisher21_.apc as apc2_19_18_,
|
1517 |
|
|
publisher21_.apcCurrency as apcCurre3_19_18_,
|
1518 |
|
|
publisher21_.bankAccount as bankAcco8_19_18_,
|
1519 |
|
|
publisher21_.contact as contact9_19_18_,
|
1520 |
|
|
publisher21_.discount as discount4_19_18_,
|
1521 |
|
|
publisher21_.email as email5_19_18_,
|
1522 |
|
|
publisher21_.name as name6_19_18_,
|
1523 |
|
|
publisher21_.source as source7_19_18_,
|
1524 |
46308
|
panagiotis
|
publisher22_.id as id1_19_19_,
|
1525 |
|
|
publisher22_.apc as apc2_19_19_,
|
1526 |
|
|
publisher22_.apcCurrency as apcCurre3_19_19_,
|
1527 |
|
|
publisher22_.bankAccount as bankAcco8_19_19_,
|
1528 |
|
|
publisher22_.contact as contact9_19_19_,
|
1529 |
|
|
publisher22_.discount as discount4_19_19_,
|
1530 |
|
|
publisher22_.email as email5_19_19_,
|
1531 |
|
|
publisher22_.name as name6_19_19_,
|
1532 |
|
|
publisher22_.source as source7_19_19_,
|
1533 |
46350
|
panagiotis
|
user23_.email as email1_22_20_,
|
1534 |
|
|
user23_.active as active2_22_20_,
|
1535 |
|
|
user23_.firstname as firstnam3_22_20_,
|
1536 |
|
|
user23_.id as id4_22_20_,
|
1537 |
|
|
user23_.initials as initials5_22_20_,
|
1538 |
|
|
user23_.lastname as lastname6_22_20_,
|
1539 |
|
|
user23_.orcidid as orcidid7_22_20_,
|
1540 |
|
|
user23_.password as password8_22_20_,
|
1541 |
|
|
user23_.source as source9_22_20_,
|
1542 |
|
|
user23_.telephone as telepho10_22_20_,
|
1543 |
|
|
user24_.email as email1_22_21_,
|
1544 |
|
|
user24_.active as active2_22_21_,
|
1545 |
|
|
user24_.firstname as firstnam3_22_21_,
|
1546 |
|
|
user24_.id as id4_22_21_,
|
1547 |
|
|
user24_.initials as initials5_22_21_,
|
1548 |
|
|
user24_.lastname as lastname6_22_21_,
|
1549 |
|
|
user24_.orcidid as orcidid7_22_21_,
|
1550 |
|
|
user24_.password as password8_22_21_,
|
1551 |
|
|
user24_.source as source9_22_21_,
|
1552 |
|
|
user24_.telephone as telepho10_22_21_
|
1553 |
46308
|
panagiotis
|
from
|
1554 |
|
|
Request this_
|
1555 |
|
|
left outer join
|
1556 |
|
|
BankAccount bankaccoun3_
|
1557 |
|
|
on this_.bankAccount=bankaccoun3_.id
|
1558 |
|
|
left outer join
|
1559 |
|
|
BankTransferReceipt banktransf4_
|
1560 |
|
|
on this_.bankTransferReceipt=banktransf4_.id
|
1561 |
|
|
left outer join
|
1562 |
|
|
Budget budget5_
|
1563 |
|
|
on this_.budget=budget5_.id
|
1564 |
|
|
left outer join
|
1565 |
46350
|
panagiotis
|
Organization organizati6_
|
1566 |
|
|
on budget5_.organization=organizati6_.id
|
1567 |
46308
|
panagiotis
|
left outer join
|
1568 |
46350
|
panagiotis
|
Country country7_
|
1569 |
|
|
on organizati6_.country=country7_.id
|
1570 |
46308
|
panagiotis
|
left outer join
|
1571 |
46350
|
panagiotis
|
Publisher publisher8_
|
1572 |
|
|
on budget5_.publisher=publisher8_.id
|
1573 |
46308
|
panagiotis
|
left outer join
|
1574 |
46350
|
panagiotis
|
BankAccount bankaccoun9_
|
1575 |
|
|
on publisher8_.bankAccount=bankaccoun9_.id
|
1576 |
46308
|
panagiotis
|
left outer join
|
1577 |
46350
|
panagiotis
|
"user" user10_
|
1578 |
|
|
on publisher8_.contact=user10_.email
|
1579 |
46308
|
panagiotis
|
left outer join
|
1580 |
46350
|
panagiotis
|
"user" user11_
|
1581 |
|
|
on budget5_."user"=user11_.email
|
1582 |
46308
|
panagiotis
|
left outer join
|
1583 |
46350
|
panagiotis
|
Invoice invoice12_
|
1584 |
|
|
on this_.invoice=invoice12_.id
|
1585 |
46308
|
panagiotis
|
left outer join
|
1586 |
46350
|
panagiotis
|
File file13_
|
1587 |
|
|
on invoice12_.file=file13_.id
|
1588 |
46308
|
panagiotis
|
left outer join
|
1589 |
46350
|
panagiotis
|
Journal journal14_
|
1590 |
|
|
on this_.journal=journal14_.id
|
1591 |
46308
|
panagiotis
|
left outer join
|
1592 |
46350
|
panagiotis
|
Country country15_
|
1593 |
|
|
on journal14_.country=country15_.id
|
1594 |
46308
|
panagiotis
|
left outer join
|
1595 |
46350
|
panagiotis
|
Publisher publisher16_
|
1596 |
|
|
on journal14_.publisher=publisher16_.id
|
1597 |
46308
|
panagiotis
|
left outer join
|
1598 |
46350
|
panagiotis
|
Organization organizati17_
|
1599 |
|
|
on this_.organization=organizati17_.id
|
1600 |
46308
|
panagiotis
|
left outer join
|
1601 |
46350
|
panagiotis
|
Project project18_
|
1602 |
|
|
on this_.project=project18_.id
|
1603 |
46308
|
panagiotis
|
inner join
|
1604 |
|
|
Publication p1_
|
1605 |
|
|
on this_.publication=p1_.id
|
1606 |
|
|
left outer join
|
1607 |
46350
|
panagiotis
|
Journal journal20_
|
1608 |
|
|
on p1_.journal=journal20_.id
|
1609 |
46308
|
panagiotis
|
left outer join
|
1610 |
46350
|
panagiotis
|
Publisher publisher21_
|
1611 |
|
|
on p1_.publisher=publisher21_.id
|
1612 |
46308
|
panagiotis
|
left outer join
|
1613 |
46350
|
panagiotis
|
Publisher publisher22_
|
1614 |
|
|
on this_.publisher=publisher22_.id
|
1615 |
46308
|
panagiotis
|
left outer join
|
1616 |
46350
|
panagiotis
|
"user" user23_
|
1617 |
|
|
on this_.researcher=user23_.email
|
1618 |
46308
|
panagiotis
|
left outer join
|
1619 |
46350
|
panagiotis
|
"user" user24_
|
1620 |
|
|
on this_."user"=user24_.email
|
1621 |
46308
|
panagiotis
|
where
|
1622 |
|
|
p1_.doi is not null
|
1623 |
|
|
and this_.status in (
|
1624 |
|
|
?, ?, ?, ?, ?
|
1625 |
|
|
)
|
1626 |
|
|
Hibernate:
|
1627 |
|
|
select
|
1628 |
46350
|
panagiotis
|
this_.id as id1_20_22_,
|
1629 |
|
|
this_.apc as apc2_20_22_,
|
1630 |
|
|
this_.apcPaid as apcPaid3_20_22_,
|
1631 |
|
|
this_.approvaldate as approval4_20_22_,
|
1632 |
|
|
this_.bankAccount as bankAcc16_20_22_,
|
1633 |
|
|
this_.bankTransferReceipt as bankTra17_20_22_,
|
1634 |
|
|
this_.budget as budget18_20_22_,
|
1635 |
|
|
this_.currency as currency5_20_22_,
|
1636 |
|
|
this_.date as date6_20_22_,
|
1637 |
|
|
this_.datePaid as datePaid7_20_22_,
|
1638 |
|
|
this_.discount as discount8_20_22_,
|
1639 |
|
|
this_.fundingrequested as fundingr9_20_22_,
|
1640 |
|
|
this_.invoice as invoice19_20_22_,
|
1641 |
|
|
this_.journal as journal20_20_22_,
|
1642 |
|
|
this_.organization as organiz21_20_22_,
|
1643 |
|
|
this_.otherCost as otherCo10_20_22_,
|
1644 |
|
|
this_.project as project22_20_22_,
|
1645 |
|
|
this_.projectparticipation as project11_20_22_,
|
1646 |
|
|
this_.publication as publica23_20_22_,
|
1647 |
|
|
this_.publisher as publish24_20_22_,
|
1648 |
|
|
this_.publisher_email as publish12_20_22_,
|
1649 |
|
|
this_.researcher as researc25_20_22_,
|
1650 |
|
|
this_.status as status13_20_22_,
|
1651 |
|
|
this_.submissiondate as submiss14_20_22_,
|
1652 |
|
|
this_.transferCost as transfe15_20_22_,
|
1653 |
|
|
this_."user" as user26_20_22_,
|
1654 |
46308
|
panagiotis
|
bankaccoun2_.id as id1_2_0_,
|
1655 |
|
|
bankaccoun2_.accountHolder as accountH2_2_0_,
|
1656 |
|
|
bankaccoun2_.bankAddress as bankAddr3_2_0_,
|
1657 |
|
|
bankaccoun2_.bankCode as bankCode4_2_0_,
|
1658 |
|
|
bankaccoun2_.bankName as bankName5_2_0_,
|
1659 |
|
|
bankaccoun2_.iban as iban6_2_0_,
|
1660 |
|
|
banktransf3_.id as id1_3_1_,
|
1661 |
|
|
banktransf3_.content as content2_3_1_,
|
1662 |
|
|
banktransf3_.contentType as contentT3_3_1_,
|
1663 |
|
|
budget4_.id as id1_4_2_,
|
1664 |
|
|
budget4_.amountGranted as amountGr2_4_2_,
|
1665 |
|
|
budget4_.amountRequested as amountRe3_4_2_,
|
1666 |
|
|
budget4_.bankAccount as bankAcc13_4_2_,
|
1667 |
|
|
budget4_.bankReceipt as bankRec14_4_2_,
|
1668 |
|
|
budget4_.beneficiarysignedcontract as benefic15_4_2_,
|
1669 |
|
|
budget4_.currency as currency4_4_2_,
|
1670 |
|
|
budget4_.date as date5_4_2_,
|
1671 |
|
|
budget4_.datePaid as datePaid6_4_2_,
|
1672 |
|
|
budget4_.enddate as enddate7_4_2_,
|
1673 |
|
|
budget4_.initialcontractfile as initial16_4_2_,
|
1674 |
|
|
budget4_.invoice as invoice17_4_2_,
|
1675 |
|
|
budget4_.organization as organiz18_4_2_,
|
1676 |
|
|
budget4_.otherCost as otherCos8_4_2_,
|
1677 |
|
|
budget4_.publisher as publish19_4_2_,
|
1678 |
|
|
budget4_.remaining as remainin9_4_2_,
|
1679 |
|
|
budget4_.signedcontract as signedc20_4_2_,
|
1680 |
|
|
budget4_.startdate as startda10_4_2_,
|
1681 |
|
|
budget4_.status as status11_4_2_,
|
1682 |
|
|
budget4_.transferCost as transfe12_4_2_,
|
1683 |
|
|
budget4_."user" as user21_4_2_,
|
1684 |
46350
|
panagiotis
|
organizati5_.id as id1_16_3_,
|
1685 |
|
|
organizati5_.country as country5_16_3_,
|
1686 |
|
|
organizati5_.name as name2_16_3_,
|
1687 |
|
|
organizati5_.shortname as shortnam3_16_3_,
|
1688 |
|
|
organizati5_.source as source4_16_3_,
|
1689 |
|
|
country6_.id as id1_9_4_,
|
1690 |
|
|
country6_.name as name2_9_4_,
|
1691 |
|
|
publisher7_.id as id1_19_5_,
|
1692 |
|
|
publisher7_.apc as apc2_19_5_,
|
1693 |
|
|
publisher7_.apcCurrency as apcCurre3_19_5_,
|
1694 |
|
|
publisher7_.bankAccount as bankAcco8_19_5_,
|
1695 |
|
|
publisher7_.contact as contact9_19_5_,
|
1696 |
|
|
publisher7_.discount as discount4_19_5_,
|
1697 |
|
|
publisher7_.email as email5_19_5_,
|
1698 |
|
|
publisher7_.name as name6_19_5_,
|
1699 |
|
|
publisher7_.source as source7_19_5_,
|
1700 |
|
|
bankaccoun8_.id as id1_2_6_,
|
1701 |
|
|
bankaccoun8_.accountHolder as accountH2_2_6_,
|
1702 |
|
|
bankaccoun8_.bankAddress as bankAddr3_2_6_,
|
1703 |
|
|
bankaccoun8_.bankCode as bankCode4_2_6_,
|
1704 |
|
|
bankaccoun8_.bankName as bankName5_2_6_,
|
1705 |
|
|
bankaccoun8_.iban as iban6_2_6_,
|
1706 |
|
|
user9_.email as email1_22_7_,
|
1707 |
|
|
user9_.active as active2_22_7_,
|
1708 |
|
|
user9_.firstname as firstnam3_22_7_,
|
1709 |
|
|
user9_.id as id4_22_7_,
|
1710 |
|
|
user9_.initials as initials5_22_7_,
|
1711 |
|
|
user9_.lastname as lastname6_22_7_,
|
1712 |
|
|
user9_.orcidid as orcidid7_22_7_,
|
1713 |
|
|
user9_.password as password8_22_7_,
|
1714 |
|
|
user9_.source as source9_22_7_,
|
1715 |
|
|
user9_.telephone as telepho10_22_7_,
|
1716 |
|
|
user10_.email as email1_22_8_,
|
1717 |
|
|
user10_.active as active2_22_8_,
|
1718 |
|
|
user10_.firstname as firstnam3_22_8_,
|
1719 |
|
|
user10_.id as id4_22_8_,
|
1720 |
|
|
user10_.initials as initials5_22_8_,
|
1721 |
|
|
user10_.lastname as lastname6_22_8_,
|
1722 |
|
|
user10_.orcidid as orcidid7_22_8_,
|
1723 |
|
|
user10_.password as password8_22_8_,
|
1724 |
|
|
user10_.source as source9_22_8_,
|
1725 |
|
|
user10_.telephone as telepho10_22_8_,
|
1726 |
|
|
invoice11_.id as id1_13_9_,
|
1727 |
|
|
invoice11_.alternativeid as alternat2_13_9_,
|
1728 |
|
|
invoice11_.date as date3_13_9_,
|
1729 |
|
|
invoice11_.file as file7_13_9_,
|
1730 |
|
|
invoice11_.number as number4_13_9_,
|
1731 |
|
|
invoice11_.source as source5_13_9_,
|
1732 |
|
|
invoice11_.status as status6_13_9_,
|
1733 |
|
|
file12_.id as id1_10_10_,
|
1734 |
|
|
file12_.file as file2_10_10_,
|
1735 |
|
|
file12_.mimetype as mimetype3_10_10_,
|
1736 |
|
|
journal13_.id as id1_14_11_,
|
1737 |
|
|
journal13_.alttitle as alttitle2_14_11_,
|
1738 |
|
|
journal13_.apc as apc3_14_11_,
|
1739 |
|
|
journal13_.apccurrency as apccurre4_14_11_,
|
1740 |
|
|
journal13_.country as country15_14_11_,
|
1741 |
|
|
journal13_.discount as discount5_14_11_,
|
1742 |
|
|
journal13_.issn as issn6_14_11_,
|
1743 |
|
|
journal13_.languages as language7_14_11_,
|
1744 |
|
|
journal13_.licence as licence8_14_11_,
|
1745 |
|
|
journal13_.publisher as publish16_14_11_,
|
1746 |
|
|
journal13_.source as source9_14_11_,
|
1747 |
|
|
journal13_.status as status10_14_11_,
|
1748 |
|
|
journal13_.subjects as subject11_14_11_,
|
1749 |
|
|
journal13_.title as title12_14_11_,
|
1750 |
|
|
journal13_.type as type13_14_11_,
|
1751 |
|
|
journal13_.url as url14_14_11_,
|
1752 |
|
|
country14_.id as id1_9_12_,
|
1753 |
|
|
country14_.name as name2_9_12_,
|
1754 |
|
|
publisher15_.id as id1_19_13_,
|
1755 |
|
|
publisher15_.apc as apc2_19_13_,
|
1756 |
|
|
publisher15_.apcCurrency as apcCurre3_19_13_,
|
1757 |
|
|
publisher15_.bankAccount as bankAcco8_19_13_,
|
1758 |
|
|
publisher15_.contact as contact9_19_13_,
|
1759 |
|
|
publisher15_.discount as discount4_19_13_,
|
1760 |
|
|
publisher15_.email as email5_19_13_,
|
1761 |
|
|
publisher15_.name as name6_19_13_,
|
1762 |
|
|
publisher15_.source as source7_19_13_,
|
1763 |
|
|
organizati16_.id as id1_16_14_,
|
1764 |
|
|
organizati16_.country as country5_16_14_,
|
1765 |
|
|
organizati16_.name as name2_16_14_,
|
1766 |
|
|
organizati16_.shortname as shortnam3_16_14_,
|
1767 |
|
|
organizati16_.source as source4_16_14_,
|
1768 |
|
|
project17_.id as id1_17_15_,
|
1769 |
|
|
project17_.acronym as acronym2_17_15_,
|
1770 |
|
|
project17_.call as call3_17_15_,
|
1771 |
|
|
project17_.enddate as enddate4_17_15_,
|
1772 |
|
|
project17_.funder as funder5_17_15_,
|
1773 |
|
|
project17_.fundingstream as fundings6_17_15_,
|
1774 |
|
|
project17_."grant" as grant7_17_15_,
|
1775 |
|
|
project17_.sc39 as sc8_17_15_,
|
1776 |
|
|
project17_.scientificarea as scientif9_17_15_,
|
1777 |
|
|
project17_.source as source10_17_15_,
|
1778 |
|
|
project17_.startdate as startda11_17_15_,
|
1779 |
|
|
project17_.title as title12_17_15_,
|
1780 |
|
|
project17_.url as url13_17_15_,
|
1781 |
|
|
publicatio18_.id as id1_18_16_,
|
1782 |
|
|
publicatio18_.acceptancedate as acceptan2_18_16_,
|
1783 |
|
|
publicatio18_.alternativedoi as alternat3_18_16_,
|
1784 |
|
|
publicatio18_.alternativetitle as alternat4_18_16_,
|
1785 |
|
|
publicatio18_.date as date5_18_16_,
|
1786 |
|
|
publicatio18_.doi as doi6_18_16_,
|
1787 |
|
|
publicatio18_.eventdetails as eventdet7_18_16_,
|
1788 |
|
|
publicatio18_.journal as journal15_18_16_,
|
1789 |
|
|
publicatio18_.languages as language8_18_16_,
|
1790 |
|
|
publicatio18_.license as license9_18_16_,
|
1791 |
|
|
publicatio18_.publisher as publish16_18_16_,
|
1792 |
|
|
publicatio18_.repository as reposit10_18_16_,
|
1793 |
|
|
publicatio18_.source as source11_18_16_,
|
1794 |
|
|
publicatio18_.subjects as subject12_18_16_,
|
1795 |
|
|
publicatio18_.title as title13_18_16_,
|
1796 |
|
|
publicatio18_.type as type14_18_16_,
|
1797 |
46308
|
panagiotis
|
journal19_.id as id1_14_17_,
|
1798 |
|
|
journal19_.alttitle as alttitle2_14_17_,
|
1799 |
|
|
journal19_.apc as apc3_14_17_,
|
1800 |
|
|
journal19_.apccurrency as apccurre4_14_17_,
|
1801 |
|
|
journal19_.country as country15_14_17_,
|
1802 |
|
|
journal19_.discount as discount5_14_17_,
|
1803 |
|
|
journal19_.issn as issn6_14_17_,
|
1804 |
|
|
journal19_.languages as language7_14_17_,
|
1805 |
|
|
journal19_.licence as licence8_14_17_,
|
1806 |
|
|
journal19_.publisher as publish16_14_17_,
|
1807 |
|
|
journal19_.source as source9_14_17_,
|
1808 |
|
|
journal19_.status as status10_14_17_,
|
1809 |
|
|
journal19_.subjects as subject11_14_17_,
|
1810 |
|
|
journal19_.title as title12_14_17_,
|
1811 |
|
|
journal19_.type as type13_14_17_,
|
1812 |
|
|
journal19_.url as url14_14_17_,
|
1813 |
46350
|
panagiotis
|
publisher20_.id as id1_19_18_,
|
1814 |
|
|
publisher20_.apc as apc2_19_18_,
|
1815 |
|
|
publisher20_.apcCurrency as apcCurre3_19_18_,
|
1816 |
|
|
publisher20_.bankAccount as bankAcco8_19_18_,
|
1817 |
|
|
publisher20_.contact as contact9_19_18_,
|
1818 |
|
|
publisher20_.discount as discount4_19_18_,
|
1819 |
|
|
publisher20_.email as email5_19_18_,
|
1820 |
|
|
publisher20_.name as name6_19_18_,
|
1821 |
|
|
publisher20_.source as source7_19_18_,
|
1822 |
46308
|
panagiotis
|
publisher21_.id as id1_19_19_,
|
1823 |
|
|
publisher21_.apc as apc2_19_19_,
|
1824 |
|
|
publisher21_.apcCurrency as apcCurre3_19_19_,
|
1825 |
|
|
publisher21_.bankAccount as bankAcco8_19_19_,
|
1826 |
|
|
publisher21_.contact as contact9_19_19_,
|
1827 |
|
|
publisher21_.discount as discount4_19_19_,
|
1828 |
|
|
publisher21_.email as email5_19_19_,
|
1829 |
|
|
publisher21_.name as name6_19_19_,
|
1830 |
|
|
publisher21_.source as source7_19_19_,
|
1831 |
46350
|
panagiotis
|
user22_.email as email1_22_20_,
|
1832 |
|
|
user22_.active as active2_22_20_,
|
1833 |
|
|
user22_.firstname as firstnam3_22_20_,
|
1834 |
|
|
user22_.id as id4_22_20_,
|
1835 |
|
|
user22_.initials as initials5_22_20_,
|
1836 |
|
|
user22_.lastname as lastname6_22_20_,
|
1837 |
|
|
user22_.orcidid as orcidid7_22_20_,
|
1838 |
|
|
user22_.password as password8_22_20_,
|
1839 |
|
|
user22_.source as source9_22_20_,
|
1840 |
|
|
user22_.telephone as telepho10_22_20_,
|
1841 |
|
|
user23_.email as email1_22_21_,
|
1842 |
|
|
user23_.active as active2_22_21_,
|
1843 |
|
|
user23_.firstname as firstnam3_22_21_,
|
1844 |
|
|
user23_.id as id4_22_21_,
|
1845 |
|
|
user23_.initials as initials5_22_21_,
|
1846 |
|
|
user23_.lastname as lastname6_22_21_,
|
1847 |
|
|
user23_.orcidid as orcidid7_22_21_,
|
1848 |
|
|
user23_.password as password8_22_21_,
|
1849 |
|
|
user23_.source as source9_22_21_,
|
1850 |
|
|
user23_.telephone as telepho10_22_21_
|
1851 |
46308
|
panagiotis
|
from
|
1852 |
|
|
Request this_
|
1853 |
|
|
left outer join
|
1854 |
|
|
BankAccount bankaccoun2_
|
1855 |
|
|
on this_.bankAccount=bankaccoun2_.id
|
1856 |
|
|
left outer join
|
1857 |
|
|
BankTransferReceipt banktransf3_
|
1858 |
|
|
on this_.bankTransferReceipt=banktransf3_.id
|
1859 |
|
|
left outer join
|
1860 |
|
|
Budget budget4_
|
1861 |
|
|
on this_.budget=budget4_.id
|
1862 |
|
|
left outer join
|
1863 |
46350
|
panagiotis
|
Organization organizati5_
|
1864 |
|
|
on budget4_.organization=organizati5_.id
|
1865 |
46308
|
panagiotis
|
left outer join
|
1866 |
46350
|
panagiotis
|
Country country6_
|
1867 |
|
|
on organizati5_.country=country6_.id
|
1868 |
46308
|
panagiotis
|
left outer join
|
1869 |
46350
|
panagiotis
|
Publisher publisher7_
|
1870 |
|
|
on budget4_.publisher=publisher7_.id
|
1871 |
46308
|
panagiotis
|
left outer join
|
1872 |
46350
|
panagiotis
|
BankAccount bankaccoun8_
|
1873 |
|
|
on publisher7_.bankAccount=bankaccoun8_.id
|
1874 |
46308
|
panagiotis
|
left outer join
|
1875 |
46350
|
panagiotis
|
"user" user9_
|
1876 |
|
|
on publisher7_.contact=user9_.email
|
1877 |
46308
|
panagiotis
|
left outer join
|
1878 |
46350
|
panagiotis
|
"user" user10_
|
1879 |
|
|
on budget4_."user"=user10_.email
|
1880 |
46308
|
panagiotis
|
left outer join
|
1881 |
46350
|
panagiotis
|
Invoice invoice11_
|
1882 |
|
|
on this_.invoice=invoice11_.id
|
1883 |
46308
|
panagiotis
|
left outer join
|
1884 |
46350
|
panagiotis
|
File file12_
|
1885 |
|
|
on invoice11_.file=file12_.id
|
1886 |
46308
|
panagiotis
|
left outer join
|
1887 |
46350
|
panagiotis
|
Journal journal13_
|
1888 |
|
|
on this_.journal=journal13_.id
|
1889 |
46308
|
panagiotis
|
left outer join
|
1890 |
46350
|
panagiotis
|
Country country14_
|
1891 |
|
|
on journal13_.country=country14_.id
|
1892 |
46308
|
panagiotis
|
left outer join
|
1893 |
46350
|
panagiotis
|
Publisher publisher15_
|
1894 |
|
|
on journal13_.publisher=publisher15_.id
|
1895 |
46308
|
panagiotis
|
left outer join
|
1896 |
46350
|
panagiotis
|
Organization organizati16_
|
1897 |
|
|
on this_.organization=organizati16_.id
|
1898 |
46308
|
panagiotis
|
left outer join
|
1899 |
46350
|
panagiotis
|
Project project17_
|
1900 |
|
|
on this_.project=project17_.id
|
1901 |
46308
|
panagiotis
|
left outer join
|
1902 |
46350
|
panagiotis
|
Publication publicatio18_
|
1903 |
|
|
on this_.publication=publicatio18_.id
|
1904 |
46308
|
panagiotis
|
left outer join
|
1905 |
|
|
Journal journal19_
|
1906 |
46350
|
panagiotis
|
on publicatio18_.journal=journal19_.id
|
1907 |
46308
|
panagiotis
|
left outer join
|
1908 |
46350
|
panagiotis
|
Publisher publisher20_
|
1909 |
|
|
on publicatio18_.publisher=publisher20_.id
|
1910 |
46308
|
panagiotis
|
left outer join
|
1911 |
|
|
Publisher publisher21_
|
1912 |
46350
|
panagiotis
|
on this_.publisher=publisher21_.id
|
1913 |
46308
|
panagiotis
|
left outer join
|
1914 |
46350
|
panagiotis
|
"user" user22_
|
1915 |
|
|
on this_.researcher=user22_.email
|
1916 |
46308
|
panagiotis
|
left outer join
|
1917 |
46350
|
panagiotis
|
"user" user23_
|
1918 |
|
|
on this_."user"=user23_.email
|
1919 |
46308
|
panagiotis
|
where
|
1920 |
|
|
this_.status in (
|
1921 |
|
|
?
|
1922 |
|
|
)
|
1923 |
|
|
Hibernate:
|
1924 |
|
|
select
|
1925 |
46350
|
panagiotis
|
this_.id as id1_20_22_,
|
1926 |
|
|
this_.apc as apc2_20_22_,
|
1927 |
|
|
this_.apcPaid as apcPaid3_20_22_,
|
1928 |
|
|
this_.approvaldate as approval4_20_22_,
|
1929 |
|
|
this_.bankAccount as bankAcc16_20_22_,
|
1930 |
|
|
this_.bankTransferReceipt as bankTra17_20_22_,
|
1931 |
|
|
this_.budget as budget18_20_22_,
|
1932 |
|
|
this_.currency as currency5_20_22_,
|
1933 |
|
|
this_.date as date6_20_22_,
|
1934 |
|
|
this_.datePaid as datePaid7_20_22_,
|
1935 |
|
|
this_.discount as discount8_20_22_,
|
1936 |
|
|
this_.fundingrequested as fundingr9_20_22_,
|
1937 |
|
|
this_.invoice as invoice19_20_22_,
|
1938 |
|
|
this_.journal as journal20_20_22_,
|
1939 |
|
|
this_.organization as organiz21_20_22_,
|
1940 |
|
|
this_.otherCost as otherCo10_20_22_,
|
1941 |
|
|
this_.project as project22_20_22_,
|
1942 |
|
|
this_.projectparticipation as project11_20_22_,
|
1943 |
|
|
this_.publication as publica23_20_22_,
|
1944 |
|
|
this_.publisher as publish24_20_22_,
|
1945 |
|
|
this_.publisher_email as publish12_20_22_,
|
1946 |
|
|
this_.researcher as researc25_20_22_,
|
1947 |
|
|
this_.status as status13_20_22_,
|
1948 |
|
|
this_.submissiondate as submiss14_20_22_,
|
1949 |
|
|
this_.transferCost as transfe15_20_22_,
|
1950 |
|
|
this_."user" as user26_20_22_,
|
1951 |
46308
|
panagiotis
|
bankaccoun3_.id as id1_2_0_,
|
1952 |
|
|
bankaccoun3_.accountHolder as accountH2_2_0_,
|
1953 |
|
|
bankaccoun3_.bankAddress as bankAddr3_2_0_,
|
1954 |
|
|
bankaccoun3_.bankCode as bankCode4_2_0_,
|
1955 |
|
|
bankaccoun3_.bankName as bankName5_2_0_,
|
1956 |
|
|
bankaccoun3_.iban as iban6_2_0_,
|
1957 |
|
|
banktransf4_.id as id1_3_1_,
|
1958 |
|
|
banktransf4_.content as content2_3_1_,
|
1959 |
|
|
banktransf4_.contentType as contentT3_3_1_,
|
1960 |
|
|
budget5_.id as id1_4_2_,
|
1961 |
|
|
budget5_.amountGranted as amountGr2_4_2_,
|
1962 |
|
|
budget5_.amountRequested as amountRe3_4_2_,
|
1963 |
|
|
budget5_.bankAccount as bankAcc13_4_2_,
|
1964 |
|
|
budget5_.bankReceipt as bankRec14_4_2_,
|
1965 |
|
|
budget5_.beneficiarysignedcontract as benefic15_4_2_,
|
1966 |
|
|
budget5_.currency as currency4_4_2_,
|
1967 |
|
|
budget5_.date as date5_4_2_,
|
1968 |
|
|
budget5_.datePaid as datePaid6_4_2_,
|
1969 |
|
|
budget5_.enddate as enddate7_4_2_,
|
1970 |
|
|
budget5_.initialcontractfile as initial16_4_2_,
|
1971 |
|
|
budget5_.invoice as invoice17_4_2_,
|
1972 |
|
|
budget5_.organization as organiz18_4_2_,
|
1973 |
|
|
budget5_.otherCost as otherCos8_4_2_,
|
1974 |
|
|
budget5_.publisher as publish19_4_2_,
|
1975 |
|
|
budget5_.remaining as remainin9_4_2_,
|
1976 |
|
|
budget5_.signedcontract as signedc20_4_2_,
|
1977 |
|
|
budget5_.startdate as startda10_4_2_,
|
1978 |
|
|
budget5_.status as status11_4_2_,
|
1979 |
|
|
budget5_.transferCost as transfe12_4_2_,
|
1980 |
|
|
budget5_."user" as user21_4_2_,
|
1981 |
46350
|
panagiotis
|
organizati6_.id as id1_16_3_,
|
1982 |
|
|
organizati6_.country as country5_16_3_,
|
1983 |
|
|
organizati6_.name as name2_16_3_,
|
1984 |
|
|
organizati6_.shortname as shortnam3_16_3_,
|
1985 |
|
|
organizati6_.source as source4_16_3_,
|
1986 |
|
|
country7_.id as id1_9_4_,
|
1987 |
|
|
country7_.name as name2_9_4_,
|
1988 |
|
|
publisher8_.id as id1_19_5_,
|
1989 |
|
|
publisher8_.apc as apc2_19_5_,
|
1990 |
|
|
publisher8_.apcCurrency as apcCurre3_19_5_,
|
1991 |
|
|
publisher8_.bankAccount as bankAcco8_19_5_,
|
1992 |
|
|
publisher8_.contact as contact9_19_5_,
|
1993 |
|
|
publisher8_.discount as discount4_19_5_,
|
1994 |
|
|
publisher8_.email as email5_19_5_,
|
1995 |
|
|
publisher8_.name as name6_19_5_,
|
1996 |
|
|
publisher8_.source as source7_19_5_,
|
1997 |
|
|
bankaccoun9_.id as id1_2_6_,
|
1998 |
|
|
bankaccoun9_.accountHolder as accountH2_2_6_,
|
1999 |
|
|
bankaccoun9_.bankAddress as bankAddr3_2_6_,
|
2000 |
|
|
bankaccoun9_.bankCode as bankCode4_2_6_,
|
2001 |
|
|
bankaccoun9_.bankName as bankName5_2_6_,
|
2002 |
|
|
bankaccoun9_.iban as iban6_2_6_,
|
2003 |
|
|
user10_.email as email1_22_7_,
|
2004 |
|
|
user10_.active as active2_22_7_,
|
2005 |
|
|
user10_.firstname as firstnam3_22_7_,
|
2006 |
|
|
user10_.id as id4_22_7_,
|
2007 |
|
|
user10_.initials as initials5_22_7_,
|
2008 |
|
|
user10_.lastname as lastname6_22_7_,
|
2009 |
|
|
user10_.orcidid as orcidid7_22_7_,
|
2010 |
|
|
user10_.password as password8_22_7_,
|
2011 |
|
|
user10_.source as source9_22_7_,
|
2012 |
|
|
user10_.telephone as telepho10_22_7_,
|
2013 |
|
|
user11_.email as email1_22_8_,
|
2014 |
|
|
user11_.active as active2_22_8_,
|
2015 |
|
|
user11_.firstname as firstnam3_22_8_,
|
2016 |
|
|
user11_.id as id4_22_8_,
|
2017 |
|
|
user11_.initials as initials5_22_8_,
|
2018 |
|
|
user11_.lastname as lastname6_22_8_,
|
2019 |
|
|
user11_.orcidid as orcidid7_22_8_,
|
2020 |
|
|
user11_.password as password8_22_8_,
|
2021 |
|
|
user11_.source as source9_22_8_,
|
2022 |
|
|
user11_.telephone as telepho10_22_8_,
|
2023 |
|
|
invoice12_.id as id1_13_9_,
|
2024 |
|
|
invoice12_.alternativeid as alternat2_13_9_,
|
2025 |
|
|
invoice12_.date as date3_13_9_,
|
2026 |
|
|
invoice12_.file as file7_13_9_,
|
2027 |
|
|
invoice12_.number as number4_13_9_,
|
2028 |
|
|
invoice12_.source as source5_13_9_,
|
2029 |
|
|
invoice12_.status as status6_13_9_,
|
2030 |
|
|
file13_.id as id1_10_10_,
|
2031 |
|
|
file13_.file as file2_10_10_,
|
2032 |
|
|
file13_.mimetype as mimetype3_10_10_,
|
2033 |
|
|
journal14_.id as id1_14_11_,
|
2034 |
|
|
journal14_.alttitle as alttitle2_14_11_,
|
2035 |
|
|
journal14_.apc as apc3_14_11_,
|
2036 |
|
|
journal14_.apccurrency as apccurre4_14_11_,
|
2037 |
|
|
journal14_.country as country15_14_11_,
|
2038 |
|
|
journal14_.discount as discount5_14_11_,
|
2039 |
|
|
journal14_.issn as issn6_14_11_,
|
2040 |
|
|
journal14_.languages as language7_14_11_,
|
2041 |
|
|
journal14_.licence as licence8_14_11_,
|
2042 |
|
|
journal14_.publisher as publish16_14_11_,
|
2043 |
|
|
journal14_.source as source9_14_11_,
|
2044 |
|
|
journal14_.status as status10_14_11_,
|
2045 |
|
|
journal14_.subjects as subject11_14_11_,
|
2046 |
|
|
journal14_.title as title12_14_11_,
|
2047 |
|
|
journal14_.type as type13_14_11_,
|
2048 |
|
|
journal14_.url as url14_14_11_,
|
2049 |
|
|
country15_.id as id1_9_12_,
|
2050 |
|
|
country15_.name as name2_9_12_,
|
2051 |
|
|
publisher16_.id as id1_19_13_,
|
2052 |
|
|
publisher16_.apc as apc2_19_13_,
|
2053 |
|
|
publisher16_.apcCurrency as apcCurre3_19_13_,
|
2054 |
|
|
publisher16_.bankAccount as bankAcco8_19_13_,
|
2055 |
|
|
publisher16_.contact as contact9_19_13_,
|
2056 |
|
|
publisher16_.discount as discount4_19_13_,
|
2057 |
|
|
publisher16_.email as email5_19_13_,
|
2058 |
|
|
publisher16_.name as name6_19_13_,
|
2059 |
|
|
publisher16_.source as source7_19_13_,
|
2060 |
|
|
organizati17_.id as id1_16_14_,
|
2061 |
|
|
organizati17_.country as country5_16_14_,
|
2062 |
|
|
organizati17_.name as name2_16_14_,
|
2063 |
|
|
organizati17_.shortname as shortnam3_16_14_,
|
2064 |
|
|
organizati17_.source as source4_16_14_,
|
2065 |
|
|
project18_.id as id1_17_15_,
|
2066 |
|
|
project18_.acronym as acronym2_17_15_,
|
2067 |
|
|
project18_.call as call3_17_15_,
|
2068 |
|
|
project18_.enddate as enddate4_17_15_,
|
2069 |
|
|
project18_.funder as funder5_17_15_,
|
2070 |
|
|
project18_.fundingstream as fundings6_17_15_,
|
2071 |
|
|
project18_."grant" as grant7_17_15_,
|
2072 |
|
|
project18_.sc39 as sc8_17_15_,
|
2073 |
|
|
project18_.scientificarea as scientif9_17_15_,
|
2074 |
|
|
project18_.source as source10_17_15_,
|
2075 |
|
|
project18_.startdate as startda11_17_15_,
|
2076 |
|
|
project18_.title as title12_17_15_,
|
2077 |
|
|
project18_.url as url13_17_15_,
|
2078 |
|
|
p1_.id as id1_18_16_,
|
2079 |
|
|
p1_.acceptancedate as acceptan2_18_16_,
|
2080 |
|
|
p1_.alternativedoi as alternat3_18_16_,
|
2081 |
|
|
p1_.alternativetitle as alternat4_18_16_,
|
2082 |
|
|
p1_.date as date5_18_16_,
|
2083 |
|
|
p1_.doi as doi6_18_16_,
|
2084 |
|
|
p1_.eventdetails as eventdet7_18_16_,
|
2085 |
|
|
p1_.journal as journal15_18_16_,
|
2086 |
|
|
p1_.languages as language8_18_16_,
|
2087 |
|
|
p1_.license as license9_18_16_,
|
2088 |
|
|
p1_.publisher as publish16_18_16_,
|
2089 |
|
|
p1_.repository as reposit10_18_16_,
|
2090 |
|
|
p1_.source as source11_18_16_,
|
2091 |
|
|
p1_.subjects as subject12_18_16_,
|
2092 |
|
|
p1_.title as title13_18_16_,
|
2093 |
|
|
p1_.type as type14_18_16_,
|
2094 |
46308
|
panagiotis
|
journal20_.id as id1_14_17_,
|
2095 |
|
|
journal20_.alttitle as alttitle2_14_17_,
|
2096 |
|
|
journal20_.apc as apc3_14_17_,
|
2097 |
|
|
journal20_.apccurrency as apccurre4_14_17_,
|
2098 |
|
|
journal20_.country as country15_14_17_,
|
2099 |
|
|
journal20_.discount as discount5_14_17_,
|
2100 |
|
|
journal20_.issn as issn6_14_17_,
|
2101 |
|
|
journal20_.languages as language7_14_17_,
|
2102 |
|
|
journal20_.licence as licence8_14_17_,
|
2103 |
|
|
journal20_.publisher as publish16_14_17_,
|
2104 |
|
|
journal20_.source as source9_14_17_,
|
2105 |
|
|
journal20_.status as status10_14_17_,
|
2106 |
|
|
journal20_.subjects as subject11_14_17_,
|
2107 |
|
|
journal20_.title as title12_14_17_,
|
2108 |
|
|
journal20_.type as type13_14_17_,
|
2109 |
|
|
journal20_.url as url14_14_17_,
|
2110 |
46350
|
panagiotis
|
publisher21_.id as id1_19_18_,
|
2111 |
|
|
publisher21_.apc as apc2_19_18_,
|
2112 |
|
|
publisher21_.apcCurrency as apcCurre3_19_18_,
|
2113 |
|
|
publisher21_.bankAccount as bankAcco8_19_18_,
|
2114 |
|
|
publisher21_.contact as contact9_19_18_,
|
2115 |
|
|
publisher21_.discount as discount4_19_18_,
|
2116 |
|
|
publisher21_.email as email5_19_18_,
|
2117 |
|
|
publisher21_.name as name6_19_18_,
|
2118 |
|
|
publisher21_.source as source7_19_18_,
|
2119 |
46308
|
panagiotis
|
publisher22_.id as id1_19_19_,
|
2120 |
|
|
publisher22_.apc as apc2_19_19_,
|
2121 |
|
|
publisher22_.apcCurrency as apcCurre3_19_19_,
|
2122 |
|
|
publisher22_.bankAccount as bankAcco8_19_19_,
|
2123 |
|
|
publisher22_.contact as contact9_19_19_,
|
2124 |
|
|
publisher22_.discount as discount4_19_19_,
|
2125 |
|
|
publisher22_.email as email5_19_19_,
|
2126 |
|
|
publisher22_.name as name6_19_19_,
|
2127 |
|
|
publisher22_.source as source7_19_19_,
|
2128 |
46350
|
panagiotis
|
user23_.email as email1_22_20_,
|
2129 |
|
|
user23_.active as active2_22_20_,
|
2130 |
|
|
user23_.firstname as firstnam3_22_20_,
|
2131 |
|
|
user23_.id as id4_22_20_,
|
2132 |
|
|
user23_.initials as initials5_22_20_,
|
2133 |
|
|
user23_.lastname as lastname6_22_20_,
|
2134 |
|
|
user23_.orcidid as orcidid7_22_20_,
|
2135 |
|
|
user23_.password as password8_22_20_,
|
2136 |
|
|
user23_.source as source9_22_20_,
|
2137 |
|
|
user23_.telephone as telepho10_22_20_,
|
2138 |
|
|
user24_.email as email1_22_21_,
|
2139 |
|
|
user24_.active as active2_22_21_,
|
2140 |
|
|
user24_.firstname as firstnam3_22_21_,
|
2141 |
|
|
user24_.id as id4_22_21_,
|
2142 |
|
|
user24_.initials as initials5_22_21_,
|
2143 |
|
|
user24_.lastname as lastname6_22_21_,
|
2144 |
|
|
user24_.orcidid as orcidid7_22_21_,
|
2145 |
|
|
user24_.password as password8_22_21_,
|
2146 |
|
|
user24_.source as source9_22_21_,
|
2147 |
|
|
user24_.telephone as telepho10_22_21_
|
2148 |
46308
|
panagiotis
|
from
|
2149 |
|
|
Request this_
|
2150 |
|
|
left outer join
|
2151 |
|
|
BankAccount bankaccoun3_
|
2152 |
|
|
on this_.bankAccount=bankaccoun3_.id
|
2153 |
|
|
left outer join
|
2154 |
|
|
BankTransferReceipt banktransf4_
|
2155 |
|
|
on this_.bankTransferReceipt=banktransf4_.id
|
2156 |
|
|
left outer join
|
2157 |
|
|
Budget budget5_
|
2158 |
|
|
on this_.budget=budget5_.id
|
2159 |
|
|
left outer join
|
2160 |
46350
|
panagiotis
|
Organization organizati6_
|
2161 |
|
|
on budget5_.organization=organizati6_.id
|
2162 |
46308
|
panagiotis
|
left outer join
|
2163 |
46350
|
panagiotis
|
Country country7_
|
2164 |
|
|
on organizati6_.country=country7_.id
|
2165 |
46308
|
panagiotis
|
left outer join
|
2166 |
46350
|
panagiotis
|
Publisher publisher8_
|
2167 |
|
|
on budget5_.publisher=publisher8_.id
|
2168 |
46308
|
panagiotis
|
left outer join
|
2169 |
46350
|
panagiotis
|
BankAccount bankaccoun9_
|
2170 |
|
|
on publisher8_.bankAccount=bankaccoun9_.id
|
2171 |
46308
|
panagiotis
|
left outer join
|
2172 |
46350
|
panagiotis
|
"user" user10_
|
2173 |
|
|
on publisher8_.contact=user10_.email
|
2174 |
46308
|
panagiotis
|
left outer join
|
2175 |
46350
|
panagiotis
|
"user" user11_
|
2176 |
|
|
on budget5_."user"=user11_.email
|
2177 |
46308
|
panagiotis
|
left outer join
|
2178 |
46350
|
panagiotis
|
Invoice invoice12_
|
2179 |
|
|
on this_.invoice=invoice12_.id
|
2180 |
46308
|
panagiotis
|
left outer join
|
2181 |
46350
|
panagiotis
|
File file13_
|
2182 |
|
|
on invoice12_.file=file13_.id
|
2183 |
46308
|
panagiotis
|
left outer join
|
2184 |
46350
|
panagiotis
|
Journal journal14_
|
2185 |
|
|
on this_.journal=journal14_.id
|
2186 |
46308
|
panagiotis
|
left outer join
|
2187 |
46350
|
panagiotis
|
Country country15_
|
2188 |
|
|
on journal14_.country=country15_.id
|
2189 |
46308
|
panagiotis
|
left outer join
|
2190 |
46350
|
panagiotis
|
Publisher publisher16_
|
2191 |
|
|
on journal14_.publisher=publisher16_.id
|
2192 |
46308
|
panagiotis
|
left outer join
|
2193 |
46350
|
panagiotis
|
Organization organizati17_
|
2194 |
|
|
on this_.organization=organizati17_.id
|
2195 |
46308
|
panagiotis
|
left outer join
|
2196 |
46350
|
panagiotis
|
Project project18_
|
2197 |
|
|
on this_.project=project18_.id
|
2198 |
46308
|
panagiotis
|
inner join
|
2199 |
|
|
Publication p1_
|
2200 |
|
|
on this_.publication=p1_.id
|
2201 |
|
|
left outer join
|
2202 |
46350
|
panagiotis
|
Journal journal20_
|
2203 |
|
|
on p1_.journal=journal20_.id
|
2204 |
46308
|
panagiotis
|
left outer join
|
2205 |
46350
|
panagiotis
|
Publisher publisher21_
|
2206 |
|
|
on p1_.publisher=publisher21_.id
|
2207 |
46308
|
panagiotis
|
left outer join
|
2208 |
46350
|
panagiotis
|
Publisher publisher22_
|
2209 |
|
|
on this_.publisher=publisher22_.id
|
2210 |
46308
|
panagiotis
|
left outer join
|
2211 |
46350
|
panagiotis
|
"user" user23_
|
2212 |
|
|
on this_.researcher=user23_.email
|
2213 |
46308
|
panagiotis
|
left outer join
|
2214 |
46350
|
panagiotis
|
"user" user24_
|
2215 |
|
|
on this_."user"=user24_.email
|
2216 |
46308
|
panagiotis
|
where
|
2217 |
|
|
p1_.doi is not null
|
2218 |
|
|
and this_.status=?
|
2219 |
|
|
0 publications from 0 projects have been approved for funding since 1/1/2015.A total of null EUR has been paid for APCs, with an average of nullEUR per publication: 0 articles with an average of null EUR 0 books with an average of null EUR null EUR
|
2220 |
|
|
Out of 0 approved requests, 0 have a DOI.Out of 0 paid requests, 0 have a DOI.
|