Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT EXP(SUM(ln(combined."manufacturingMultiplier"))) AS "combManufMultiplier", EXP(SUM(ln(combined."researchMultiplier"))) AS "combResearchMultiplier", combined."solarSystemName", combined."solarSystemID"
- FROM
- (SELECT "manufacturingMultiplier", "researchMultiplier", ss."solarSystemName", ss."solarSystemID" FROM evesde."mapSolarSystems" AS ss
- INNER JOIN evesde."staStations" AS st
- ON ss."solarSystemID" = st."solarSystemID"
- INNER JOIN evesde."staOperations" AS op
- ON op."operationID" = st."operationID"
- INNER JOIN nonccp."operationSystemIndexMultipliers" AS osim
- ON op."operationID" = osim."operationID"
- ) AS combined GROUP BY combined."solarSystemName", combined."solarSystemID";
- The TABLE nonccp."operationSystemIndexMultipliers" follows.
- ┌─────────────┬─────────────────────────┬────────────────────┐
- │ operationID │ manufacturingMultiplier │ researchMultiplier │
- ├─────────────┼─────────────────────────┼────────────────────┤
- │ 49 │ 0.5 │ 0.6 │
- │ 45 │ 0.6 │ 0.8 │
- │ 48 │ 0.6 │ 0.5 │
- │ 50 │ 0.6 │ 0.6 │
- │ 4 │ 0.95 │ 0.98 │
- │ 14 │ 0.95 │ 0.98 │
- │ 17 │ 0.95 │ 0.98 │
- │ 20 │ 0.95 │ 0.98 │
- │ 24 │ 0.95 │ 0.98 │
- │ 6 │ 0.97 │ 0.98 │
- │ 12 │ 0.97 │ 0.98 │
- │ 32 │ 0.97 │ 0.98 │
- │ 37 │ 0.97 │ 0.98 │
- │ 10 │ 0.98 │ 0.97 │
- │ 11 │ 0.98 │ 0.97 │
- │ 16 │ 0.98 │ 0.95 │
- │ 18 │ 0.98 │ 0.95 │
- │ 19 │ 0.98 │ 0.95 │
- │ 1 │ 0.98 │ 0.98 │
- │ 2 │ 0.98 │ 0.98 │
- │ 7 │ 0.98 │ 0.98 │
- │ 8 │ 0.98 │ 0.98 │
- │ 9 │ 0.98 │ 0.98 │
- │ 15 │ 0.98 │ 0.98 │
- │ 22 │ 0.98 │ 0.98 │
- │ 23 │ 0.98 │ 0.98 │
- │ 25 │ 0.98 │ 0.98 │
- │ 26 │ 0.98 │ 0.98 │
- │ 28 │ 0.98 │ 0.98 │
- │ 30 │ 0.98 │ 0.98 │
- │ 31 │ 0.98 │ 0.98 │
- │ 33 │ 0.98 │ 0.98 │
- │ 34 │ 0.98 │ 0.98 │
- │ 35 │ 0.98 │ 0.98 │
- │ 36 │ 0.98 │ 0.98 │
- │ 40 │ 0.98 │ 0.98 │
- │ 41 │ 0.98 │ 0.98 │
- │ 42 │ 0.98 │ 0.98 │
- │ 43 │ 0.98 │ 0.98 │
- │ 44 │ 0.98 │ 0.98 │
- │ 52 │ 0.98 │ 0.98 │
- │ 53 │ 0.98 │ 0.98 │
- │ 54 │ 0.98 │ 0.98 │
- │ 55 │ 0.98 │ 0.98 │
- │ 51 │ 0.7 │ 0.6 │
- │ 47 │ 0.8 │ 0.7 │
- │ 3 │ 0.98 │ 0.98 │
- │ 13 │ 0.97 │ 0.97 │
- │ 29 │ 0.98 │ 0.98 │
- │ 38 │ 0.98 │ 0.98 │
- │ 39 │ 0.98 │ 0.98 │
- │ 27 │ 0.98 │ 0.98 │
- │ 21 │ 0.98 │ 0.98 │
- │ 5 │ 0.95 │ 0.98 │
- │ 46 │ 0.95 │ 0.8 │
- └─────────────┴─────────────────────────┴────────────────────┘
- The same TABLE IN CSV format
- operationID,manufacturingMultiplier,researchMultiplier
- 49,0.5,0.6
- 45,0.6,0.8
- 48,0.6,0.5
- 50,0.6,0.6
- 4,0.95,0.98
- 14,0.95,0.98
- 17,0.95,0.98
- 20,0.95,0.98
- 24,0.95,0.98
- 6,0.97,0.98
- 12,0.97,0.98
- 32,0.97,0.98
- 37,0.97,0.98
- 10,0.98,0.97
- 11,0.98,0.97
- 16,0.98,0.95
- 18,0.98,0.95
- 19,0.98,0.95
- 1,0.98,0.98
- 2,0.98,0.98
- 7,0.98,0.98
- 8,0.98,0.98
- 9,0.98,0.98
- 15,0.98,0.98
- 22,0.98,0.98
- 23,0.98,0.98
- 25,0.98,0.98
- 26,0.98,0.98
- 28,0.98,0.98
- 30,0.98,0.98
- 31,0.98,0.98
- 33,0.98,0.98
- 34,0.98,0.98
- 35,0.98,0.98
- 36,0.98,0.98
- 40,0.98,0.98
- 41,0.98,0.98
- 42,0.98,0.98
- 43,0.98,0.98
- 44,0.98,0.98
- 52,0.98,0.98
- 53,0.98,0.98
- 54,0.98,0.98
- 55,0.98,0.98
- 51,0.7,0.6
- 47,0.8,0.7
- 3,0.98,0.98
- 13,0.97,0.97
- 29,0.98,0.98
- 38,0.98,0.98
- 39,0.98,0.98
- 27,0.98,0.98
- 21,0.98,0.98
- 5,0.95,0.98
- 46,0.95,0.8
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement