SHARE
TWEET

Relevant Decryptors

Fuzzysteve Aug 12th, 2013 236 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  SELECT it2.typeid,
  2.        it2.typename,
  3.        COALESCE(dta2.valueint, dta2.valuefloat) modifier
  4. FROM   invblueprinttypes ibt
  5.        JOIN ramtyperequirements rtr
  6.          ON ( ibt.blueprinttypeid = rtr.typeid )
  7.        JOIN invtypes it1
  8.          ON ( rtr.requiredtypeid = it1.typeid1.groupid = 716
  9.               AND activityid = 8 )
  10.        JOIN dgmtypeattributes dta
  11.          ON ( it1.typeid = dta.typeid
  12.               AND dta.attributeid = 1115 )
  13.        JOIN invtypes it2
  14.          ON ( it2.groupid = COALESCE(dta.valueint, dta.valuefloat) )
  15.        JOIN dgmtypeattributes dta2
  16.          ON ( dta2.typeid = it2.typeid
  17.               AND dta2.attributeid = 1112 )
  18. WHERE  ibt.producttypeid = 2454;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top