Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement