(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 = 45608 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 = 45608 AND pts.player_id = 55179 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 = 45608 AND pts.player_id = 55179 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 = 45608 AND pts.player_id = 55179 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 = 45608 AND pts.player_id = 54850 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 = 45608 AND pts.player_id = 54850 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 = 45608 AND pts.player_id = 54850 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 = 45608 AND pts.player_id = 55627 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 = 45608 AND pts.player_id = 55627 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 = 45608 AND pts.player_id = 55627 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 = 45608 AND pts.player_id = 43857 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 = 45608 AND pts.player_id = 43857 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 = 45608 AND pts.player_id = 43857 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 = 45608 AND pts.player_id = 43497 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 = 45608 AND pts.player_id = 43497 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 = 45608 AND pts.player_id = 43497 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 = 45608 AND pts.player_id = 25850 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 = 45608 AND pts.player_id = 25850 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 = 45608 AND pts.player_id = 25850 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 = 45608 AND pts.player_id = 55114 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 = 45608 AND pts.player_id = 55114 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 = 45608 AND pts.player_id = 55114 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 = 45608 AND pts.player_id = 43363 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 = 45608 AND pts.player_id = 43363 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 = 45608 AND pts.player_id = 43363 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 = 45608 AND pts.player_id = 55447 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 = 45608 AND pts.player_id = 55447 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 = 45608 AND pts.player_id = 55447 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 = 45608 AND pts.player_id = 15424 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 = 45608 AND pts.player_id = 15424 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 = 45608 AND pts.player_id = 15424 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 = 45608 AND pts.player_id = 6304 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 = 45608 AND pts.player_id = 6304 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 = 45608 AND pts.player_id = 6304 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 = 45608 AND pts.player_id = 6535 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 = 45608 AND pts.player_id = 6535 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 = 45608 AND pts.player_id = 6535 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 = 45608 AND pts.player_id = 7187 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 = 45608 AND pts.player_id = 7187 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 = 45608 AND pts.player_id = 7187 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 = 45608 AND pts.player_id = 7188 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 = 45608 AND pts.player_id = 7188 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 = 45608 AND pts.player_id = 7188 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 = 45608 AND pts.player_id = 15425 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 = 45608 AND pts.player_id = 15425 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 = 45608 AND pts.player_id = 15425 GROUP BY pts.player_id
| PLAYER NAME |
TOTAL POINTS |
EVENT POINTS |
BONUS POINTS |
| Balcom, Helen |
115 |
110.0 |
5 |
| Bryant, Joe |
128 |
120.0 |
8 |
| Bryant, Kathy |
80 |
75.0 |
5 |
| Dicruttalo, Joe |
90 |
85.0 |
5 |
| Grant, Frank |
85 |
80.0 |
5 |
| Johnson, Scott |
54 |
50.0 |
4 |
| Latailee, Rick |
64 |
60.0 |
4 |
| Lynn, Elvis |
59 |
55.0 |
4 |
| Marsella, Anthony |
110 |
105.0 |
5 |
| Piso, Louise |
44 |
40.0 |
4 |
| Pitasi, Judy |
95 |
90.0 |
5 |
| Russell, Hank |
39 |
35.0 |
4 |
| Smith, Nada |
100 |
95.0 |
5 |
| Smith, Ronnie |
69 |
65.0 |
4 |
| Van Duyne, Buster |
49 |
45.0 |
4 |