(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 = 23201 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 = 23201 AND pts.player_id = 30240 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 = 23201 AND pts.player_id = 30240 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 = 23201 AND pts.player_id = 30240 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 = 23201 AND pts.player_id = 2548 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 = 23201 AND pts.player_id = 2548 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 = 23201 AND pts.player_id = 2548 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 = 23201 AND pts.player_id = 22046 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 = 23201 AND pts.player_id = 22046 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 = 23201 AND pts.player_id = 22046 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 = 23201 AND pts.player_id = 34956 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 = 23201 AND pts.player_id = 34956 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 = 23201 AND pts.player_id = 34956 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 = 23201 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 = 23201 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 = 23201 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 = 23201 AND pts.player_id = 12616 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 = 23201 AND pts.player_id = 12616 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 = 23201 AND pts.player_id = 12616 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 = 23201 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 = 23201 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 = 23201 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 = 23201 AND pts.player_id = 32690 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 = 23201 AND pts.player_id = 32690 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 = 23201 AND pts.player_id = 32690 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 = 23201 AND pts.player_id = 13036 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 = 23201 AND pts.player_id = 13036 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 = 23201 AND pts.player_id = 13036 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 = 23201 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 = 23201 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 = 23201 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 = 23201 AND pts.player_id = 13649 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 = 23201 AND pts.player_id = 13649 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 = 23201 AND pts.player_id = 13649 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 = 23201 AND pts.player_id = 11692 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 = 23201 AND pts.player_id = 11692 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 = 23201 AND pts.player_id = 11692 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 = 23201 AND pts.player_id = 34051 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 = 23201 AND pts.player_id = 34051 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 = 23201 AND pts.player_id = 34051 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 = 23201 AND pts.player_id = 22597 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 = 23201 AND pts.player_id = 22597 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 = 23201 AND pts.player_id = 22597 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 = 23201 AND pts.player_id = 30119 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 = 23201 AND pts.player_id = 30119 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 = 23201 AND pts.player_id = 30119 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 = 23201 AND pts.player_id = 33022 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 = 23201 AND pts.player_id = 33022 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 = 23201 AND pts.player_id = 33022 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 = 23201 AND pts.player_id = 33296 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 = 23201 AND pts.player_id = 33296 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 = 23201 AND pts.player_id = 33296 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 = 23201 AND pts.player_id = 22580 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 = 23201 AND pts.player_id = 22580 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 = 23201 AND pts.player_id = 22580 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 = 23201 AND pts.player_id = 28909 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 = 23201 AND pts.player_id = 28909 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 = 23201 AND pts.player_id = 28909 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 = 23201 AND pts.player_id = 25634 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 = 23201 AND pts.player_id = 25634 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 = 23201 AND pts.player_id = 25634 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 = 23201 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 = 23201 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 = 23201 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 = 23201 AND pts.player_id = 19134 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 = 23201 AND pts.player_id = 19134 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 = 23201 AND pts.player_id = 19134 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 = 23201 AND pts.player_id = 31584 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 = 23201 AND pts.player_id = 31584 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 = 23201 AND pts.player_id = 31584 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 = 23201 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 = 23201 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 = 23201 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 = 23201 AND pts.player_id = 22054 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 = 23201 AND pts.player_id = 22054 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 = 23201 AND pts.player_id = 22054 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 = 23201 AND pts.player_id = 29439 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 = 23201 AND pts.player_id = 29439 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 = 23201 AND pts.player_id = 29439 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 = 23201 AND pts.player_id = 29442 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 = 23201 AND pts.player_id = 29442 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 = 23201 AND pts.player_id = 29442 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 = 23201 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 = 23201 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 = 23201 AND pts.player_id = 35227 GROUP BY pts.player_id
| PLAYER NAME |
TOTAL POINTS |
EVENT POINTS |
BONUS POINTS |
| Adams, Paul |
72 |
65.0 |
7 |
| Avellan, Shawn |
57 |
50.0 |
7 |
| Avellan, Robyn |
67 |
60.0 |
7 |
| Baigorria, Jennifer |
10 |
10.0 |
0 |
| Barrett, Carole |
85 |
75.0 |
10 |
| Belluardo, Tom |
52 |
45.0 |
7 |
| Canniff, Lori |
10 |
10.0 |
0 |
| Carignan, Patricia |
90 |
80.0 |
10 |
| Carter, Gary |
42 |
35.0 |
7 |
| Cruz, Charlene |
10 |
10.0 |
0 |
| Giarrusso, Joe |
10 |
10.0 |
0 |
| Gould, David |
134 |
120.0 |
14 |
| Herman, Justin |
105 |
95.0 |
10 |
| Jaffe, Catherine |
10 |
10.0 |
0 |
| Machado, Johnson |
10 |
10.0 |
0 |
| Mann, Bill |
10 |
10.0 |
0 |
| Martin, Christopher |
115 |
105.0 |
10 |
| Masse, Dave |
37 |
30.0 |
7 |
| Nashef, Antoun |
10 |
10.0 |
0 |
| Novel, Dennis |
47 |
40.0 |
7 |
| Smith, Anthony |
95 |
85.0 |
10 |
| Stott, Robyn |
120 |
110.0 |
10 |
| Toney, Stephen |
10 |
10.0 |
0 |
| Valentin, Franklin |
10 |
10.0 |
0 |
| White, Tricia |
10 |
10.0 |
0 |
| Wilbur, Carol |
100 |
90.0 |
10 |
| Wilbur, Eric |
62 |
55.0 |
7 |
| Yackel, Ed |
10 |
10.0 |
0 |