| 1 |
[url=https://dl.
dropboxusercontent.
com/u/19320633/brackmanMegadata.
csv]Here[/url]
is
a
slighlty
larger
CSV
listing
51695
ZK
teamgames
of
at
least
6
players
in
size,
with
winner
and
loser
player
id
l
ists
for
each.
|
1 |
[url=https://dl.
dropboxusercontent.
com/u/19320633/brackmanMegadata.
csv]Here[/url]
is
a
slighlty
larger
CSV
listing
51695
ZK
teamgames
of
at
least
6
players
in
size,
with
winner
and
loser
player
id
lists
for
each.
|
| 2 |
\n
|
2 |
\n
|
| 3 |
Here is the exact methodology used to obtain this data:
|
3 |
Here is the exact methodology used to obtain this data:
|
| 4 |
[quote]
|
4 |
[quote]
|
| 5 |
Select distinct SBP2.SpringBattleID, SpringBattles.PlayerCount,SpringBattles.Title,
|
5 |
Select distinct SBP2.SpringBattleID, SpringBattles.PlayerCount,SpringBattles.Title,
|
| 6 |
substring(
|
6 |
substring(
|
| 7 |
(
|
7 |
(
|
| 8 |
Select ','+CAST(SBP1.AccountID AS VARCHAR) AS [text()]
|
8 |
Select ','+CAST(SBP1.AccountID AS VARCHAR) AS [text()]
|
| 9 |
From SpringBattlePlayers SBP1
|
9 |
From SpringBattlePlayers SBP1
|
| 10 |
Where SBP1.SpringBattleID = SBP2.SpringBattleID
|
10 |
Where SBP1.SpringBattleID = SBP2.SpringBattleID
|
| 11 |
AND SBP1.IsInVictoryTeam = 1 AND SBP1.IsSpectator = 0
|
11 |
AND SBP1.IsInVictoryTeam = 1 AND SBP1.IsSpectator = 0
|
| 12 |
For XML PATH ('')
|
12 |
For XML PATH ('')
|
| 13 |
), 2, 1000) [Winners],
|
13 |
), 2, 1000) [Winners],
|
| 14 |
substring(
|
14 |
substring(
|
| 15 |
(
|
15 |
(
|
| 16 |
Select ','+CAST(SBP1.AccountID AS VARCHAR) AS [text()]
|
16 |
Select ','+CAST(SBP1.AccountID AS VARCHAR) AS [text()]
|
| 17 |
From SpringBattlePlayers SBP1
|
17 |
From SpringBattlePlayers SBP1
|
| 18 |
Where SBP1.SpringBattleID = SBP2.SpringBattleID
|
18 |
Where SBP1.SpringBattleID = SBP2.SpringBattleID
|
| 19 |
AND SBP1.IsInVictoryTeam = 0 AND SBP1.IsSpectator = 0
|
19 |
AND SBP1.IsInVictoryTeam = 0 AND SBP1.IsSpectator = 0
|
| 20 |
For XML PATH ('')
|
20 |
For XML PATH ('')
|
| 21 |
), 2, 1000) [Losers]
|
21 |
), 2, 1000) [Losers]
|
| 22 |
From SpringBattlePlayers SBP2 LEFT JOIN SpringBattles ON SBP2.SpringBattleID = SpringBattles.SpringBattleID
|
22 |
From SpringBattlePlayers SBP2 LEFT JOIN SpringBattles ON SBP2.SpringBattleID = SpringBattles.SpringBattleID
|
| 23 |
WHERE IsFfa = 0 AND isMission = 0 AND HasBots = 0 AND PlayerCount > 5
|
23 |
WHERE IsFfa = 0 AND isMission = 0 AND HasBots = 0 AND PlayerCount > 5
|
| 24 |
[/quote]
|
24 |
[/quote]
|
| 25 |
\n
|
25 |
\n
|
| 26 |
Verify that i didn't do anything silly, and you can have a conclusive run.
|
26 |
Verify that i didn't do anything silly, and you can have a conclusive run.
|
| 27 |
\n
|
27 |
\n
|
!predict is wrong! - New Prediction System for Teams