diff options
| author | vainsocial <vainsocial@services> | 2017-05-06 10:22:36 +0000 |
|---|---|---|
| committer | vainsocial <vainsocial@services> | 2017-05-06 10:22:36 +0000 |
| commit | 764572460cc6b50fd253d45bf0821e00e7192f66 (patch) | |
| tree | 37204a31732ab92dae761820bf7cb1e172f2b9db /crunch_team.sql | |
| parent | f8613dc45fed8f800f5053239364704e08ed7d29 (diff) | |
| download | cruncher-764572460cc6b50fd253d45bf0821e00e7192f66.tar.gz cruncher-764572460cc6b50fd253d45bf0821e00e7192f66.zip | |
fix team crunch sql
Diffstat (limited to 'crunch_team.sql')
| -rw-r--r-- | crunch_team.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/crunch_team.sql b/crunch_team.sql index fb94418..a11cc33 100644 --- a/crunch_team.sql +++ b/crunch_team.sql @@ -7,11 +7,11 @@ JOIN ( WHEN tm_cnt=1 THEN 0.33 WHEN tm_cnt=2 THEN 0.66 WHEN tm_cnt=3 THEN 1.33 - ) * + END) * (CASE - WHEN p.winner THEN 1 - WHEN NOT p.winner THEN 0.7 - ) * + WHEN p.winner=TRUE THEN 1 + WHEN p.winner=FALSE THEN 0.7 + END) * (CASE WHEN tm.status='initiate' THEN 10 WHEN tm.status='member' THEN 75 |