(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 = 39148 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 = 39148 AND pts.player_id = 6079 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 = 39148 AND pts.player_id = 6079 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 = 39148 AND pts.player_id = 6079 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 = 39148 AND pts.player_id = 29691 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 = 39148 AND pts.player_id = 29691 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 = 39148 AND pts.player_id = 29691 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 = 39148 AND pts.player_id = 44882 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 = 39148 AND pts.player_id = 44882 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 = 39148 AND pts.player_id = 44882 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 = 39148 AND pts.player_id = 28142 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 = 39148 AND pts.player_id = 28142 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 = 39148 AND pts.player_id = 28142 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 = 39148 AND pts.player_id = 28143 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 = 39148 AND pts.player_id = 28143 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 = 39148 AND pts.player_id = 28143 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 = 39148 AND pts.player_id = 42896 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 = 39148 AND pts.player_id = 42896 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 = 39148 AND pts.player_id = 42896 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 = 39148 AND pts.player_id = 15931 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 = 39148 AND pts.player_id = 15931 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 = 39148 AND pts.player_id = 15931 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 = 39148 AND pts.player_id = 44959 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 = 39148 AND pts.player_id = 44959 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 = 39148 AND pts.player_id = 44959 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 = 39148 AND pts.player_id = 42547 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 = 39148 AND pts.player_id = 42547 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 = 39148 AND pts.player_id = 42547 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 = 39148 AND pts.player_id = 45418 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 = 39148 AND pts.player_id = 45418 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 = 39148 AND pts.player_id = 45418 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 = 39148 AND pts.player_id = 39478 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 = 39148 AND pts.player_id = 39478 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 = 39148 AND pts.player_id = 39478 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 = 39148 AND pts.player_id = 43357 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 = 39148 AND pts.player_id = 43357 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 = 39148 AND pts.player_id = 43357 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 = 39148 AND pts.player_id = 15846 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 = 39148 AND pts.player_id = 15846 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 = 39148 AND pts.player_id = 15846 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 = 39148 AND pts.player_id = 39813 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 = 39148 AND pts.player_id = 39813 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 = 39148 AND pts.player_id = 39813 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 = 39148 AND pts.player_id = 47027 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 = 39148 AND pts.player_id = 47027 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 = 39148 AND pts.player_id = 47027 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 = 39148 AND pts.player_id = 27685 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 = 39148 AND pts.player_id = 27685 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 = 39148 AND pts.player_id = 27685 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 = 39148 AND pts.player_id = 48493 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 = 39148 AND pts.player_id = 48493 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 = 39148 AND pts.player_id = 48493 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 = 39148 AND pts.player_id = 34445 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 = 39148 AND pts.player_id = 34445 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 = 39148 AND pts.player_id = 34445 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 = 39148 AND pts.player_id = 38321 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 = 39148 AND pts.player_id = 38321 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 = 39148 AND pts.player_id = 38321 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 = 39148 AND pts.player_id = 28408 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 = 39148 AND pts.player_id = 28408 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 = 39148 AND pts.player_id = 28408 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 = 39148 AND pts.player_id = 52171 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 = 39148 AND pts.player_id = 52171 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 = 39148 AND pts.player_id = 52171 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 = 39148 AND pts.player_id = 43604 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 = 39148 AND pts.player_id = 43604 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 = 39148 AND pts.player_id = 43604 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 = 39148 AND pts.player_id = 44790 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 = 39148 AND pts.player_id = 44790 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 = 39148 AND pts.player_id = 44790 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 = 39148 AND pts.player_id = 45041 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 = 39148 AND pts.player_id = 45041 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 = 39148 AND pts.player_id = 45041 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 = 39148 AND pts.player_id = 32092 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 = 39148 AND pts.player_id = 32092 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 = 39148 AND pts.player_id = 32092 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 = 39148 AND pts.player_id = 24563 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 = 39148 AND pts.player_id = 24563 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 = 39148 AND pts.player_id = 24563 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 = 39148 AND pts.player_id = 42845 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 = 39148 AND pts.player_id = 42845 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 = 39148 AND pts.player_id = 42845 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 = 39148 AND pts.player_id = 14739 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 = 39148 AND pts.player_id = 14739 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 = 39148 AND pts.player_id = 14739 GROUP BY pts.player_id
| PLAYER NAME |
TOTAL POINTS |
EVENT POINTS |
BONUS POINTS |
| Anshewitz, Jason |
105 |
95.0 |
10 |
| Athanasiou, Dimitrios |
10 |
10.0 |
0 |
| Browne, Kyle |
90 |
80.0 |
10 |
| Carafa, Debbie |
10 |
10.0 |
0 |
| Cicchetti, Dawn |
37 |
30.0 |
7 |
| Cormier, Ralph |
10 |
10.0 |
0 |
| Dietel, Jim |
67 |
60.0 |
7 |
| Durgin, William |
57 |
50.0 |
7 |
| Francis, Billy |
100 |
90.0 |
10 |
| Francis, William |
95 |
85.0 |
10 |
| Gallagher, Bryan |
10 |
10.0 |
0 |
| Johnson, David M |
85 |
75.0 |
10 |
| MacHardy, Patrick |
52 |
45.0 |
7 |
| Martin, Laura |
10 |
10.0 |
0 |
| Meleedy, Ryan |
72 |
65.0 |
7 |
| Mendes, Freddie |
10 |
10.0 |
0 |
| Mills, John |
10 |
10.0 |
0 |
| O'Brien, Paul |
62 |
55.0 |
7 |
| Piaseczny, Maria |
10 |
10.0 |
0 |
| Piaseczny, Chris |
120 |
110.0 |
10 |
| Richards, nick |
10 |
10.0 |
0 |
| Rushton, Mike |
134 |
120.0 |
14 |
| Sergio, Kristoffer |
47 |
40.0 |
7 |
| Smith, Jean |
115 |
105.0 |
10 |
| Smith, Debi |
10 |
10.0 |
0 |
| Suffredini, David |
42 |
35.0 |
7 |
| Turcotte, Rob |
10 |
10.0 |
0 |
| Weinberg, Jeffrey |
10 |
10.0 |
0 |