(mysqli): SELECT pts.player_id as id, CONCAT(p.last, ', ', p.first) as name, p.email, p.phone, pts.action FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 30013 AND pts.action = 'CHECK_IN' ORDER BY p.last
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 40464 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 40464 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 40464 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 38763 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 38763 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 38763 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 36476 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 36476 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 36476 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 38204 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 38204 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 38204 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 15478 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 15478 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 15478 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 14051 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 14051 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 14051 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 40503 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 40503 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 40503 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 29352 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 29352 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 29352 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 36043 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 36043 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 36043 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 13711 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 13711 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 13711 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 28002 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 28002 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 28002 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 15589 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 15589 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 15589 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 34296 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 34296 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 34296 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 21906 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 21906 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 21906 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 25419 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 25419 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 25419 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 40748 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 40748 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 40748 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 15720 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 15720 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 15720 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 27777 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 27777 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 27777 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 35004 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 35004 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 35004 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 16467 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 16467 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 16467 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 29985 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 29985 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 29985 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 27888 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 27888 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 27888 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 30241 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 30241 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 30241 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 30237 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 30237 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 30237 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM player_pts AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 38337 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM bounty_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 38337 GROUP BY pts.player_id
(mysqli): SELECT SUM(pts.points * e.points_multiplier) as points FROM participation_points AS pts LEFT JOIN event AS e ON e.id = pts.event_id WHERE pts.event_id = 30013 AND pts.player_id = 38337 GROUP BY pts.player_id
| PLAYER NAME |
TOTAL POINTS |
EVENT POINTS |
BONUS POINTS |
| Alan, Alex |
66 |
60.0 |
6 |
| Badger, Carlton |
61 |
55.0 |
6 |
| Barnicle, Charlie |
104 |
95.0 |
9 |
| Bower, Earl |
10 |
10.0 |
0 |
| Cintolo, Michael |
10 |
10.0 |
0 |
| Colangelo, Bob |
10 |
10.0 |
0 |
| Davis, Nikki |
133 |
120.0 |
13 |
| Discher, Bert |
84 |
75.0 |
9 |
| Dixon, Jeff |
114 |
105.0 |
9 |
| Giroux, Paul |
36 |
30.0 |
6 |
| Kessler, Jody |
10 |
10.0 |
0 |
| Lemire, Jim |
56 |
50.0 |
6 |
| Linces, Vinny |
10 |
10.0 |
0 |
| Mann, Richard |
71 |
65.0 |
6 |
| Mermelstein, Fred |
10 |
10.0 |
0 |
| Mespelli, Sean |
41 |
35.0 |
6 |
| Osche, Joe |
94 |
85.0 |
9 |
| Ostrofsky, Libby |
46 |
40.0 |
6 |
| Powell, Scott |
119 |
110.0 |
9 |
| Resch, Brenda |
89 |
80.0 |
9 |
| Shepard, Chris |
51 |
45.0 |
6 |
| Stocklin, Scott |
10 |
10.0 |
0 |
| Veksler, Lilia |
99 |
90.0 |
9 |
| Veksler, Mark |
10 |
10.0 |
0 |
| Worcester, John |
10 |
10.0 |
0 |