Anthony Mirabella Aneurysm9

Working on OpenTelemetry and other observability tooling.

fuzzysteve / decryptorEffects

Created July 28, 2014 03:06

Decryptor effects by blueprint

	SELECT it2.typename,
	it2.typeid,
	coalesce(dta2.valueInt,dta2.valueFloat) multiplier,
	coalesce(dta3.valueInt,dta3.valueFloat) me,
	coalesce(dta4.valueInt,dta4.valueFloat) te,
	coalesce(dta5.valueInt,dta5.valueFloat) runs
	FROM invTypes
	JOIN industryActivityMaterials iam ON (iam.materialtypeid=invTypes.typeid and iam.activityid=8 and groupid=716)
	JOIN industryActivityProducts iap ON (iam.typeid=iap.typeid)
	JOIN dgmTypeAttributes dta on (dta.typeid=invTypes.typeid and dta.attributeID=1115)