P5/21X/OMDSQuery_multipartition.sql

0001 select
0002          r.runnumber as rNb
0003        , m.modedescription as modeT
0004        , p.partitionname as pName
0005        ,s2.fecversionmajorid||'.'||s2.fecversionminorid as new_fec
0006        , s2.fedversionmajorid||'.'||s2.fedversionminorid as new_fed
0007        , s2.connectionversionmajorid||'.'||s2.connectionversionminorid as new_conn
0008        , s2.dcuinfoversionmajorid||'.'||s2.dcuinfoversionminorid
0009         , r.runmode
0010   from
0011     run r
0012   , partition p
0013   , modetype m
0014     , statehistory s2
0015   where
0016       m.runmode=r.runmode
0017   and r.runmode !=21
0018 --  and s2.connectionversionmajorid!=2
0019   and r.partitionid=p.partitionid
0020   and r.partitionid=s2.partitionid
0021   and r.statehistoryid=s2.statehistoryid
0022   and r.runnumber>49800
0023 ;