PG
Size: a a a
PG
DK
PG
KP
D
SB
select B.* from ACT_GE_BYTEARRAY B inner join
(select B.NAME_, MAX(D.DEPLOY_TIME_) DEPLOY_TIME_ from ACT_GE_BYTEARRAY B
inner join ACT_RE_DEPLOYMENT D on B.DEPLOYMENT_ID_ = D.ID_
where D.NAME_ = 'backendApplication' and (D.SOURCE_ is null or D.SOURCE_ = 'application' )
and B.NAME_ in ('name.bpmn') group by B.NAME_) LAST_RESOURCE on B.NAME_ = LAST_RESOURCE.NAME_
inner join ACT_RE_DEPLOYMENT D on B.DEPLOYMENT_ID_ = D.ID_
and D.DEPLOY_TIME_ = LAST_RESOURCE.DEPLOY_TIME_ and D.NAME_ = 'backendApplication'
and (D.SOURCE_ is null or D.SOURCE_ = 'application' ) and D.TENANT_ID_ is null order by B.ID_ asc;
SB
DK
SB
DK
SB
SB
SB
LP
DK
LP
DK
LP
LP
DK