(mysqli): SELECT id, name, city FROM location WHERE active = 1 ORDER BY name ASC
(mysqli): SELECT id, name, state FROM tournament WHERE 1 ORDER BY name ASC
(mysqli): SELECT l.*, t.start_date, t.end_date FROM location l INNER JOIN event e ON e.location_id = l.id INNER JOIN tournament t ON t.id = e.tournament_id WHERE l.id = 664
(mysqli): SELECT name FROM location WHERE id = 664
(mysqli): SELECT p.id as trash, SUM(pts.points) as pts, pts.player_id, CONCAT(p.last,', ',p.first) as name FROM event e INNER JOIN player_pts pts ON pts.event_id = e.id INNER JOIN player p ON p.id = pts.player_id WHERE e.location_id = 664 GROUP BY pts.player_id ORDER BY pts DESC LIMIT 200
(mysqli): SELECT ppts.player_id AS id, SUM(ppts.points) as pts FROM participation_points ppts INNER JOIN event e ON e.id = ppts.event_id WHERE e.location_id = 664 GROUP BY ppts.player_id
(mysqli): SELECT bpts.player_id AS id, SUM(bpts.points) as pts FROM bounty_points bpts INNER JOIN event e ON e.id = bpts.event_id WHERE e.location_id = 664 GROUP BY bpts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(pts.event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 664 GROUP BY pts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 664 AND action = 1 GROUP BY pts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 664 AND (action = 1 OR action = 2 OR action = 3) GROUP BY pts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 664 AND action != 'CHECK_IN' GROUP BY pts.player_id
(mysqli): SELECT t.id, t.name, t.state FROM tournament t WHERE t.active = 1 ORDER BY t.name ASC
(mysqli): SELECT id, name, city FROM location WHERE active = 1 ORDER BY name ASC
(mysqli): SELECT id, name, state FROM tournament WHERE 1 ORDER BY name ASC
(mysqli): SELECT l.id, l.name, l.city FROM location l LEFT JOIN event e ON e.location_id = l.id LEFT JOIN tournament t ON t.id = e.tournament_id WHERE l.active = 1 AND t.active = 1 ORDER BY l.name ASC
OVERALL - TOP 50
| Rank |
Player Name |
Total Points |
Event Points |
Bonus Points |
Total Events |
Average / Event |
Wins |
Top 16s |
|
#15
|
O'Brien, Kelly
|
1450
|
1330
|
120
|
34
|
42.65
|
3
|
15
|
|
#11
|
Young, Bob
|
1632
|
1465
|
167
|
26
|
62.77
|
3
|
20
|
|
#26
|
Swift, David
|
556
|
500
|
56
|
9
|
61.78
|
2
|
7
|
|
#25
|
Baptista, Jorge
|
638
|
580
|
58
|
15
|
42.53
|
2
|
7
|
|
#12
|
Spier, Cindy
|
1575
|
1410
|
165
|
23
|
68.48
|
2
|
17
|
|
#8
|
Congro, Basil
|
1869
|
1710
|
159
|
33
|
56.64
|
2
|
21
|
|
#6
|
O'Connell, Alan
|
1957
|
1775
|
182
|
34
|
57.56
|
2
|
23
|
|
#5
|
Bowden, Jeffrey SIR
|
1981
|
1810
|
171
|
33
|
60.03
|
2
|
23
|
|
#4
|
Minot, Joseph
|
2115
|
1905
|
210
|
37
|
57.16
|
2
|
26
|
|
#3
|
Smith, Ronnie
|
2320
|
2110
|
210
|
36
|
64.44
|
2
|
26
|
|
#63
|
Brennan, Mark
|
142
|
130
|
12
|
2
|
71.00
|
1
|
1
|
|
|
Players above this line are qualified for the WSOP Finale on Saturday, June 3, 2023
|
|
|
#51
|
Spencer, Nick
|
279
|
225
|
54
|
4
|
69.75
|
1
|
3
|
|
#52
|
Kuperschmid, Jason
|
273
|
250
|
23
|
8
|
34.13
|
1
|
3
|
|
#41
|
Chamoun, Jim
|
374
|
335
|
39
|
6
|
62.33
|
1
|
4
|
|
#40
|
Holt, Brandon
|
380
|
350
|
30
|
8
|
47.50
|
1
|
3
|
|
#33
|
Dennehy, Jake
|
445
|
395
|
50
|
9
|
49.44
|
1
|
4
|
|
#28
|
Miller, Stephen
|
509
|
470
|
39
|
14
|
36.36
|
1
|
5
|
|
#24
|
Mercado, Tyler
|
653
|
585
|
68
|
15
|
43.53
|
1
|
7
|
|
#21
|
Marani, Jack
|
752
|
670
|
82
|
14
|
53.71
|
1
|
8
|
|
#22
|
Taylor, Bryant
|
742
|
680
|
62
|
14
|
53.00
|
1
|
8
|
|
#20
|
Janofsky, Jerry
|
807
|
730
|
77
|
12
|
67.25
|
1
|
9
|
|
#18
|
Torres, Victoria
|
1020
|
920
|
100
|
20
|
51.00
|
1
|
14
|
|
#17
|
McGonagle, Jim
|
1166
|
1055
|
111
|
21
|
55.52
|
1
|
13
|
|
#16
|
Ho, Sam
|
1290
|
1155
|
135
|
22
|
58.64
|
1
|
15
|
|
#14
|
Pappas, Jim
|
1488
|
1360
|
128
|
36
|
41.33
|
1
|
16
|
|
#13
|
Goel, Varun
|
1543
|
1395
|
148
|
26
|
59.35
|
1
|
17
|
|
#10
|
Fegan, Marc
|
1661
|
1505
|
156
|
36
|
46.14
|
1
|
21
|
|
#9
|
Driscoll, Greg
|
1693
|
1515
|
178
|
24
|
70.54
|
1
|
21
|
|
#127
|
Hegarty, John
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#128
|
Champagne, Bob
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#129
|
Macedo, Dino
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#130
|
mattos, joshua
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#131
|
Raine, Sheila
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#132
|
French, Brad
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#133
|
Quinn, Jim
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#134
|
Anderson, Brian
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#135
|
Silva, Tony
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#136
|
Perez, Edwin
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#137
|
Myers, Evan
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#138
|
Vadeboncoeur, Rene
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#139
|
Savage, Honey
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#140
|
Aidamouni, George
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#141
|
Magee, Tom
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#142
|
Chakrapani, Ram
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#143
|
Boudreau, Sean
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#144
|
Bosco, Jamey
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#145
|
Kemp, Erick
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#146
|
Saengsombat, Vilay
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#147
|
Dougherty, David
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#148
|
Cooper, Tony
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#149
|
Nguyen, Amanda
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#150
|
Granville, Bruno
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#151
|
Bartlett, Guy
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#152
|
Cormier, Brad
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#153
|
Miller, Ronald
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#154
|
Murphy, Horace
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#155
|
Shawki, Tony
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#156
|
Monteiro II, Frank
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#157
|
goncalves, john
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#158
|
Duncan, David
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#159
|
Cox, Kevin
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#160
|
Fernandes, Oliver
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#161
|
Willett, Steve
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#162
|
Beland Jr., Robert
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#163
|
Ordway, Matt
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#164
|
Vargo, Eric
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#165
|
Scopelites, John
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#166
|
Folger, Josh
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#167
|
Hamilton, Danny
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#168
|
McGilvery, Kelsie
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#169
|
Lopes, Curtis
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#170
|
Steeves, Vaughn
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#171
|
Su, Kai
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#172
|
Fren, Fayez
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#173
|
Rainey, Matt
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#174
|
Villa, Ron
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#175
|
Council, Keith
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#176
|
Harrington, Connor
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#177
|
Joseph, Dave
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#178
|
Fren, Raymond
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#179
|
Forrest, Aaron
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#180
|
Croteau, Peter
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#181
|
Ortiz, Tylique
|
10
|
10
|
0
|
1
|
10.00
|
0
|
|
|
#114
|
LaCapria, Rick
|
20
|
20
|
0
|
2
|
10.00
|
0
|
|
|
#115
|
Falvey, Michael
|
20
|
20
|
0
|
2
|
10.00
|
0
|
|
|
#116
|
Segrini, Ali
|
20
|
20
|
0
|
2
|
10.00
|
0
|
|
|
#117
|
Crowley, Joe
|
20
|
20
|
0
|
2
|
10.00
|
0
|
|
|
#118
|
Trieber, Lenny
|
20
|
20
|
0
|
2
|
10.00
|
0
|
|
|
#119
|
Harrold, Joe
|
20
|
20
|
0
|
2
|
10.00
|
0
|
|
|
#120
|
Scott, Ronald
|
20
|
20
|
0
|
2
|
10.00
|
0
|
|
|
#121
|
Daley, Daniel
|
20
|
20
|
0
|
2
|
10.00
|
0
|
|
|
#122
|
Baker, Mike
|
20
|
20
|
0
|
2
|
10.00
|
0
|
|
|
#123
|
Devereaux, Daniel
|
20
|
20
|
0
|
2
|
10.00
|
0
|
|
|
#124
|
mattes, keith
|
20
|
20
|
0
|
2
|
10.00
|
0
|
|
|
#125
|
Moran, John
|
20
|
20
|
0
|
2
|
10.00
|
0
|
|
|
#126
|
Geller, Phillip
|
20
|
20
|
0
|
2
|
10.00
|
0
|
|
|
#111
|
Peterson, Jim
|
36
|
30
|
6
|
1
|
36.00
|
0
|
1
|
|
#110
|
Santangelo, Robert
|
37
|
30
|
7
|
1
|
37.00
|
0
|
1
|
|
#112
|
Scalia, Nate
|
30
|
30
|
0
|
3
|
10.00
|
0
|
|
|
#113
|
Munichiello, Mike
|
30
|
30
|
0
|
3
|
10.00
|
0
|
|