Relevant Decryptors

 SELECT it2.typeid,
       it2.typename,
       COALESCE(dta2.valueint, dta2.valuefloat) modifier
FROM   invblueprinttypes ibt
       JOIN ramtyperequirements rtr
         ON ( ibt.blueprinttypeid = rtr.typeid )
       JOIN invtypes it1
         ON ( rtr.requiredtypeid = it1.typeid1.groupid = 716
              AND activityid = 8 )
       JOIN dgmtypeattributes dta
         ON ( it1.typeid = dta.typeid
              AND dta.attributeid = 1115 )
       JOIN invtypes it2
         ON ( it2.groupid = COALESCE(dta.valueint, dta.valuefloat) )
       JOIN dgmtypeattributes dta2
         ON ( dta2.typeid = it2.typeid
              AND dta2.attributeid = 1112 )
WHERE  ibt.producttypeid = 2454;