(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 = 20242 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 = 20242 AND pts.player_id = 18942 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 = 20242 AND pts.player_id = 18942 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 = 20242 AND pts.player_id = 18942 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 = 20242 AND pts.player_id = 14109 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 = 20242 AND pts.player_id = 14109 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 = 20242 AND pts.player_id = 14109 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 = 20242 AND pts.player_id = 34126 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 = 20242 AND pts.player_id = 34126 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 = 20242 AND pts.player_id = 34126 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 = 20242 AND pts.player_id = 22851 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 = 20242 AND pts.player_id = 22851 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 = 20242 AND pts.player_id = 22851 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 = 20242 AND pts.player_id = 27616 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 = 20242 AND pts.player_id = 27616 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 = 20242 AND pts.player_id = 27616 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 = 20242 AND pts.player_id = 2390 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 = 20242 AND pts.player_id = 2390 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 = 20242 AND pts.player_id = 2390 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 = 20242 AND pts.player_id = 34622 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 = 20242 AND pts.player_id = 34622 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 = 20242 AND pts.player_id = 34622 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 = 20242 AND pts.player_id = 15920 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 = 20242 AND pts.player_id = 15920 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 = 20242 AND pts.player_id = 15920 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 = 20242 AND pts.player_id = 35027 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 = 20242 AND pts.player_id = 35027 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 = 20242 AND pts.player_id = 35027 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 = 20242 AND pts.player_id = 25422 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 = 20242 AND pts.player_id = 25422 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 = 20242 AND pts.player_id = 25422 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 = 20242 AND pts.player_id = 28784 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 = 20242 AND pts.player_id = 28784 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 = 20242 AND pts.player_id = 28784 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 = 20242 AND pts.player_id = 2251 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 = 20242 AND pts.player_id = 2251 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 = 20242 AND pts.player_id = 2251 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 = 20242 AND pts.player_id = 33214 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 = 20242 AND pts.player_id = 33214 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 = 20242 AND pts.player_id = 33214 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 = 20242 AND pts.player_id = 4255 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 = 20242 AND pts.player_id = 4255 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 = 20242 AND pts.player_id = 4255 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 = 20242 AND pts.player_id = 28950 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 = 20242 AND pts.player_id = 28950 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 = 20242 AND pts.player_id = 28950 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 = 20242 AND pts.player_id = 12315 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 = 20242 AND pts.player_id = 12315 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 = 20242 AND pts.player_id = 12315 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 = 20242 AND pts.player_id = 30295 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 = 20242 AND pts.player_id = 30295 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 = 20242 AND pts.player_id = 30295 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 = 20242 AND pts.player_id = 32283 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 = 20242 AND pts.player_id = 32283 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 = 20242 AND pts.player_id = 32283 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 = 20242 AND pts.player_id = 30899 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 = 20242 AND pts.player_id = 30899 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 = 20242 AND pts.player_id = 30899 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 = 20242 AND pts.player_id = 31040 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 = 20242 AND pts.player_id = 31040 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 = 20242 AND pts.player_id = 31040 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 = 20242 AND pts.player_id = 22852 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 = 20242 AND pts.player_id = 22852 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 = 20242 AND pts.player_id = 22852 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 = 20242 AND pts.player_id = 13467 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 = 20242 AND pts.player_id = 13467 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 = 20242 AND pts.player_id = 13467 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 = 20242 AND pts.player_id = 24651 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 = 20242 AND pts.player_id = 24651 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 = 20242 AND pts.player_id = 24651 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 = 20242 AND pts.player_id = 35227 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 = 20242 AND pts.player_id = 35227 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 = 20242 AND pts.player_id = 35227 GROUP BY pts.player_id
| PLAYER NAME |
TOTAL POINTS |
EVENT POINTS |
BONUS POINTS |
| Barrett, Carole |
113 |
105.0 |
8 |
| Canniff, Lori |
83 |
75.0 |
8 |
| Correia, Nilson |
98 |
90.0 |
8 |
| Cruz, Charlene |
56 |
50.0 |
6 |
| Fitzgerald, Lynne |
10 |
10.0 |
0 |
| Fitzpatrick, Kathleen |
103 |
95.0 |
8 |
| Forshay, Anthony |
10 |
10.0 |
0 |
| Freehart, Robert |
88 |
80.0 |
8 |
| Gotts, Dave |
132 |
120.0 |
12 |
| Gustin, Karen |
10 |
10.0 |
0 |
| Lin, Ruby |
36 |
30.0 |
6 |
| Lorman, Josh |
41 |
35.0 |
6 |
| Mcdermott, Shaun |
10 |
10.0 |
0 |
| Michaud, Pauline |
10 |
10.0 |
0 |
| Morris, Doug |
93 |
85.0 |
8 |
| Nawoichik, Richard B. |
71 |
65.0 |
6 |
| Nguyen, Danny |
46 |
40.0 |
6 |
| Ocnos, George |
61 |
55.0 |
6 |
| Roosa, Jesse |
10 |
10.0 |
0 |
| Roukas, Alex |
10 |
10.0 |
0 |
| Smith, Anthony |
66 |
60.0 |
6 |
| Trask, Jeremy J. |
51 |
45.0 |
6 |
| Valentin, Franklin |
118 |
110.0 |
8 |
| Yackel, Ed |
10 |
10.0 |
0 |