(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 |
|
#1
|
Starratt, Joe
|
2914
|
2680
|
234
|
39
|
74.72
|
0
|
30
|
|
#2
|
Ziegler, Rick
|
2704
|
2435
|
269
|
38
|
71.16
|
0
|
35
|
|
#4
|
Minot, Joseph
|
2115
|
1905
|
210
|
37
|
57.16
|
2
|
26
|
|
#14
|
Pappas, Jim
|
1488
|
1360
|
128
|
36
|
41.33
|
1
|
16
|
|
#10
|
Fegan, Marc
|
1661
|
1505
|
156
|
36
|
46.14
|
1
|
21
|
|
#7
|
Barros, Manuel
|
1924
|
1735
|
189
|
36
|
53.44
|
0
|
24
|
|
#3
|
Smith, Ronnie
|
2320
|
2110
|
210
|
36
|
64.44
|
2
|
26
|
|
#15
|
O'Brien, Kelly
|
1450
|
1330
|
120
|
34
|
42.65
|
3
|
15
|
|
#6
|
O'Connell, Alan
|
1957
|
1775
|
182
|
34
|
57.56
|
2
|
23
|
|
#8
|
Congro, Basil
|
1869
|
1710
|
159
|
33
|
56.64
|
2
|
21
|
|
#5
|
Bowden, Jeffrey SIR
|
1981
|
1810
|
171
|
33
|
60.03
|
2
|
23
|
|
#13
|
Goel, Varun
|
1543
|
1395
|
148
|
26
|
59.35
|
1
|
17
|
|
#11
|
Young, Bob
|
1632
|
1465
|
167
|
26
|
62.77
|
3
|
20
|
|
#9
|
Driscoll, Greg
|
1693
|
1515
|
178
|
24
|
70.54
|
1
|
21
|
|
#12
|
Spier, Cindy
|
1575
|
1410
|
165
|
23
|
68.48
|
2
|
17
|
|
#16
|
Ho, Sam
|
1290
|
1155
|
135
|
22
|
58.64
|
1
|
15
|
|
#17
|
McGonagle, Jim
|
1166
|
1055
|
111
|
21
|
55.52
|
1
|
13
|
|
#18
|
Torres, Victoria
|
1020
|
920
|
100
|
20
|
51.00
|
1
|
14
|
|
#19
|
Levy, Danny
|
890
|
810
|
80
|
17
|
52.35
|
0
|
12
|
|
#23
|
Stiegman, Robert
|
678
|
615
|
63
|
16
|
42.38
|
0
|
10
|
|
#25
|
Baptista, Jorge
|
638
|
580
|
58
|
15
|
42.53
|
2
|
7
|
|
#24
|
Mercado, Tyler
|
653
|
585
|
68
|
15
|
43.53
|
1
|
7
|
|
#28
|
Miller, Stephen
|
509
|
470
|
39
|
14
|
36.36
|
1
|
5
|
|
#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
|
|
#35
|
Webb, Mike
|
419
|
385
|
34
|
10
|
41.90
|
0
|
4
|
|
#46
|
Davis, Gregory
|
310
|
280
|
30
|
9
|
34.44
|
0
|
4
|
|
#44
|
Fairneny, James
|
315
|
290
|
25
|
9
|
35.00
|
0
|
3
|
|
#39
|
Kelly, Johnny
|
391
|
355
|
36
|
9
|
43.44
|
0
|
6
|
|
#36
|
Womack, Drew
|
412
|
375
|
37
|
9
|
45.78
|
0
|
6
|
|
#32
|
Benanto, Ron
|
445
|
385
|
60
|
9
|
49.44
|
0
|
7
|
|
#33
|
Dennehy, Jake
|
445
|
395
|
50
|
9
|
49.44
|
1
|
4
|
|
#31
|
Taylor, Marcus
|
451
|
395
|
56
|
9
|
50.11
|
0
|
6
|
|
#30
|
Polis, Keith
|
464
|
410
|
54
|
9
|
51.56
|
0
|
5
|
|
#26
|
Swift, David
|
556
|
500
|
56
|
9
|
61.78
|
2
|
7
|
|
#52
|
Kuperschmid, Jason
|
273
|
250
|
23
|
8
|
34.13
|
1
|
3
|
|
#43
|
Gudaitis, Charles
|
367
|
330
|
37
|
8
|
45.88
|
0
|
4
|
|
#40
|
Holt, Brandon
|
380
|
350
|
30
|
8
|
47.50
|
1
|
3
|
|
#34
|
DeAmato, Susan
|
437
|
385
|
52
|
8
|
54.63
|
0
|
7
|
|
#27
|
Holt, Eddie
|
516
|
480
|
36
|
8
|
64.50
|
0
|
5
|
|
#49
|
Porter, Wil
|
290
|
260
|
30
|
7
|
41.43
|
0
|
3
|
|
#50
|
Amaral, Priscilla
|
290
|
265
|
25
|
7
|
41.43
|
0
|
2
|
|
#48
|
Prosper sr, Kevin
|
304
|
275
|
29
|
7
|
43.43
|
0
|
4
|
|
#57
|
Rimer, Steve
|
223
|
200
|
23
|
6
|
37.17
|
0
|
2
|
|
#41
|
Chamoun, Jim
|
374
|
335
|
39
|
6
|
62.33
|
1
|
4
|
|
#37
|
Chiu, Eddy
|
410
|
380
|
30
|
6
|
68.33
|
0
|
5
|
|
#29
|
Kalemkeridis, Themis
|
492
|
450
|
42
|
6
|
82.00
|
0
|
5
|
|
#106
|
Rizza, Richard
|
50
|
50
|
0
|
5
|
10.00
|
0
|
|
|
#58
|
Gallagher, Patrick
|
221
|
200
|
21
|
5
|
44.20
|
0
|
2
|
|
#56
|
Miller, Steve
|
233
|
210
|
23
|
5
|
46.60
|
0
|
3
|
|
#45
|
Currie, Steve
|
311
|
275
|
36
|
5
|
62.20
|
0
|
4
|
|
#42
|
o'neil, bee
|
373
|
335
|
38
|
5
|
74.60
|
0
|
4
|
|
#38
|
Gardner, Jim
|
405
|
370
|
35
|
5
|
81.00
|
0
|
5
|
|
#109
|
Kumbatovic, Bob
|
40
|
40
|
0
|
4
|
10.00
|
0
|
|
|
#87
|
Parillo, Jeff
|
89
|
80
|
9
|
4
|
22.25
|
0
|
1
|
|
#64
|
Dasilva, Zach
|
142
|
135
|
7
|
4
|
35.50
|
0
|
1
|
|
#59
|
White, James
|
212
|
190
|
22
|
4
|
53.00
|
0
|
2
|
|
#55
|
Noonan, John
|
235
|
215
|
20
|
4
|
58.75
|
0
|
3
|
|
|
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
|
|
#54
|
Distefano, amy
|
252
|
230
|
22
|
4
|
63.00
|
0
|
3
|
|
#53
|
Dionne, Jacob
|
272
|
235
|
37
|
4
|
68.00
|
0
|
4
|
|
#47
|
Dussault, Mike
|
307
|
280
|
27
|
4
|
76.75
|
0
|
3
|
|
#112
|
Scalia, Nate
|
30
|
30
|
0
|
3
|
10.00
|
0
|
|
|
#113
|
Munichiello, Mike
|
30
|
30
|
0
|
3
|
10.00
|
0
|
|
|
#98
|
Scannell, Jim
|
57
|
50
|
7
|
3
|
19.00
|
0
|
1
|
|
#93
|
Hebert, Lenora
|
76
|
70
|
6
|
3
|
25.33
|
0
|
1
|
|
#89
|
O'Donnell, Susan
|
84
|
75
|
9
|
3
|
28.00
|
0
|
1
|
|
#90
|
Hernandez , Johnny
|
84
|
80
|
4
|
3
|
28.00
|
0
|
1
|
|
#86
|
Acerra, Bill "Milkshake"
|
91
|
85
|
6
|
3
|
30.33
|
0
|
1
|
|
#77
|
Kroll, Joe
|
111
|
100
|
11
|
3
|
37.00
|
0
|
1
|
|
#74
|
O'Malley, John
|
115
|
105
|
10
|
3
|
38.33
|
0
|
1
|
|
#62
|
Goncalves, Karen
|
158
|
135
|
23
|
3
|
52.67
|
0
|
2
|
|
#61
|
Cosmo, Jay
|
162
|
135
|
27
|
3
|
54.00
|
0
|
2
|
|
#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
|
|
|
#107
|
Politano, Jean
|
47
|
40
|
7
|
2
|
23.50
|
0
|
1
|
|
#108
|
Small, Chris
|
46
|
40
|
6
|
2
|
23.00
|
0
|
1
|
|
#103
|
O'Hare, Dennis
|
52
|
45
|
7
|
2
|
26.00
|
0
|
1
|
|
#105
|
McConnell, Matthew
|
50
|
45
|
5
|
2
|
25.00
|
0
|
1
|
|
#97
|
Collins, Tom
|
64
|
55
|
9
|
2
|
32.00
|
0
|
1
|
|
#95
|
Leblanc, Joseph
|
71
|
65
|
6
|
2
|
35.50
|
0
|
1
|
|
#82
|
Pantazolpoolos, Stelios
|
97
|
85
|
12
|
2
|
48.50
|
0
|
1
|
|
#76
|
O'Hare , Kelly
|
113
|
85
|
28
|
2
|
56.50
|
0
|
2
|
|
#73
|
Arcand, Albert
|
115
|
95
|
20
|
2
|
57.50
|
0
|
2
|
|
#72
|
Reid, Jay
|
118
|
105
|
13
|
2
|
59.00
|
0
|
1
|
|
#68
|
Alex, Chris
|
123
|
110
|
13
|
2
|
61.50
|
0
|
2
|
|
#69
|
Pattison, Jim
|
121
|
110
|
11
|
2
|
60.50
|
0
|
2
|
|
#67
|
Athanasiou, Dimitrios
|
133
|
120
|
13
|
2
|
66.50
|
0
|
2
|