(mysqli): SELECT name FROM tournament WHERE id = 27
(mysqli): SELECT r.player_id, p.last, p.first, opt.nickname, p.phone, p.email, r.rank_w_addl_pts AS `rank`, r.rank_out_of, (r.pri_event_points + r.pri_bonus_points + r.neu_event_points + r.neu_bonus_points + r.sec_event_points + r.sec_bonus_points) AS total, (r.pri_event_count + r.neu_event_count + r.sec_event_count) as event_count, ROUND(((r.pri_event_points + r.pri_bonus_points + r.neu_event_points + r.neu_bonus_points + r.sec_event_points + r.sec_bonus_points) / (r.pri_event_count + r.neu_event_count + r.sec_event_count)), 2) AS average, (r.pri_wins + r.neu_wins + r.sec_wins) AS wins, (r.pri_top_16s + r.neu_top_16s + r.sec_top_16s) AS top16 FROM rankings AS r LEFT JOIN player AS p ON p.id = r.player_id LEFT JOIN player_opt AS opt ON opt.player_id = p.id WHERE r.rank_type = 'Monthly' AND r.rank_period = '202610' AND r.tournament_id = '27' AND r.rank_basic != '0' AND r.rank_w_addl_pts != '0' ORDER BY r.rank_w_addl_pts ASC, p.last ASC, p.first ASC
Qualified for $10,000 Monthly Championship:
3 out of 19
|
Rank
|
Name
|
Points
|
Avg
|
Wins
|
Top 16s
|
Events
|
|
#1
|
Dickinson, Spencer
|
425
|
85.00
|
2
|
4
|
5
|
|
#2
|
Hebert, Lenora
|
217
|
108.50
|
0
|
2
|
2
|
|
#3
|
Mathur, Michael
|
187
|
93.50
|
0
|
2
|
2
|
|
|
The 3 players above this line are currently qualified for the October 2026 $10,000 Monthly Championship.
|
|
|
#4
|
Chan, Chris
|
160
|
80.00
|
0
|
2
|
2
|
|
#5
|
Rose, David
|
140
|
70.00
|
0
|
2
|
2
|
|
#6
|
Loconto, Michael
|
137
|
45.67
|
0
|
3
|
3
|
|
#7
|
Ambrose, Eric
|
116
|
116.00
|
0
|
1
|
1
|
|
#8
|
Connor, Ed
|
96
|
96.00
|
0
|
1
|
1
|
|
#9
|
Smith, Carole
|
96
|
48.00
|
0
|
1
|
2
|
|
#10
|
Baker, Kevin
|
91
|
45.50
|
0
|
1
|
2
|
|
#11
|
Zwinklis, Dave
|
91
|
91.00
|
0
|
1
|
1
|
|
#12
|
Aguiar, Patrick
|
81
|
81.00
|
0
|
1
|
1
|
|
#13
|
Giroux, Paul
|
69
|
34.50
|
0
|
1
|
2
|
|
#14
|
Mariano, Marc
|
64
|
64.00
|
0
|
1
|
1
|
|
#15
|
Murphy, Shaun
|
64
|
64.00
|
0
|
1
|
1
|
|
#16
|
DeSantis, Nick
|
59
|
29.50
|
0
|
1
|
2
|
|
#17
|
Germano, John
|
54
|
27.00
|
0
|
1
|
2
|
|
#18
|
Hassell, Matt
|
54
|
54.00
|
0
|
1
|
1
|
|
#19
|
Thibodeau, Sheldon
|
49
|
49.00
|
0
|
1
|
1
|