---

(mysqli): SELECT p.first, opt.nickname FROM player p LEFT JOIN player_opt opt ON p.id = opt.player_id WHERE p.id = 24081  

---

---

(mysqli): SELECT pts.points as points, bonus_p.points as ppts, bonus_b.points as bpts, pts.action, e.date as date, e.points_multiplier as points_multiplier, e.id as eid, e.name as ename, t.id as tid, t.nickname as tname, t.abbreviation as tabbr, l.id as lid, l.name as lname FROM (SELECT event_id, SUM(points) AS points, SUBSTRING_INDEX(GROUP_CONCAT(action ORDER BY points DESC, id ASC), ',', 1) AS action, MAX(id) AS sort_id FROM player_pts WHERE player_id = 24081 GROUP BY event_id) pts LEFT JOIN (SELECT event_id, SUM(points) AS points FROM participation_points WHERE player_id = 24081 GROUP BY event_id) bonus_p ON bonus_p.event_id = pts.event_id LEFT JOIN (SELECT event_id, SUM(points) AS points FROM bounty_points WHERE player_id = 24081 GROUP BY event_id) bonus_b ON bonus_b.event_id = pts.event_id LEFT JOIN event e ON e.id = pts.event_id LEFT JOIN tournament t ON t.id = e.tournament_id LEFT JOIN location l ON l.id = e.location_id ORDER BY e.date DESC, pts.sort_id DESC  

---

DATE	LOCATION	PTS	RNK	TOURNAMENT
02/20/2020	Walpole VFW	10	-	CHAR
02/15/2020	$150 DEEPSTACK!	100	5	CHAR
02/13/2020	Walpole VFW	85	8	CHAR
01/25/2020	$60 Cheapstack @ WALPOLE VFW	119	2	CHAR
01/25/2020	$150 DEEPSTACK!	10	-	CHAR
10/17/2019	Walpole VFW	10	-	CHAR
10/14/2019	$180 - Veteran's Deepstack	67	11	CHAR
09/02/2019	$180 - Veteran's Deepstack	10	-	CHAR
08/31/2019	$60 Cheapstack @ WALPOLE VFW	94	6	CHAR
08/31/2019	$150 DEEPSTACK!	10	-	CHAR
06/22/2019	$150 DEEPSTACK!	38	16	CHAR
05/27/2019	$180 - Veteran's Deepstack	10	-	CHAR
05/25/2019	$10,000 Guaranteed Payout! 50K Finals Seat Added	113	3	CHAR
03/28/2019	Walpole VFW	10	-	CHAR
01/03/2019	Walpole VFW	10	-	CHAR
01/01/2019	$10,000 GUARANTEED SUPERSTACKED EVENT!	10	-	CHAR
12/29/2018	$10,000 Guaranteed Payout! 50K Finals Seat Added	38	16	CHAR
11/23/2018	$10,000 GUARANTEED SUPERSTACKED EVENT!	81	11	CHAR
11/03/2018	$60 Cheapstack @ WALPOLE VFW	100	4	CHAR
11/03/2018	$10,000 Guaranteed Payout! 50K Finals Seat Added	10	-	CHAR
10/08/2018	$180 - Veteran's Deepstack	53	14	CHAR
09/01/2018	$10,000 Guaranteed Payout! 50K Finals Seat Added	10	-	CHAR
04/16/2018	$180 - Veteran's Deepstack	107	5	CHAR
01/15/2018	$80 Mini Mega -Memorial Day	35	16	CHAR
01/15/2018	$180 - Veteran's Deepstack	10	-	CHAR
01/01/2018	New Year's Day $10,000 GTD SUPERSTACK	10	-	CHAR
11/18/2017	$10,000 Monthly Championship	10	-	CHAR
10/14/2017	$10,000 Guaranteed Payout! 50K Finals Seat Added	142	1	CHAR
01/23/2017	Bar Poker Open $120 FINALE-5 PKGS GTD + WSOP Moneymaker Seat!!	116	3	CHAR
01/02/2017	$120 Fourth Of July Maxx Staxx	10	-	CHAR
09/05/2016	$180 - Veteran's Deepstack	10	-	CHAR
09/03/2016	$10,000 Guaranteed Payout! 50K Finals Seat Added	66	11	CHAR
07/11/2016	New Year's Day Bounty	10	-	CHAR
05/30/2016	BPO AC Travel Satellite	10	-	CHAR
03/30/2016	Walpole VFW	10	-	CHAR
03/28/2016	New Year's Day Bounty	10	-	CHAR
03/14/2016	New Year's Day Bounty	10	-	CHAR
03/07/2016	New Year's Day Bounty	10	-	CHAR
11/30/2015	New Year's Day Bounty	10	-	CHAR
11/27/2015	$10,000 GUARANTEED SUPERSTACKED EVENT!	10	-	CHAR
10/17/2015	$60 CHEAPSTACK	10	-	CHAR
10/12/2015	BPO AC Travel Satellite	10	-	CHAR
02/17/2014	Memorial Day $100 Maxx staxx	10	-	CHAR
02/10/2014	New Year's Day Bounty	10	-	CHAR
11/23/2012	$10,000 GUARANTEED SUPERSTACKED EVENT!	10	-	CHAR
10/01/2012	Bar Poker Open $120 FINALE-5 PKGS GTD + WSOP Moneymaker Seat!!	39	16	CHAR
09/17/2012	Bar Poker Open $120 FINALE-5 PKGS GTD + WSOP Moneymaker Seat!!	10	-	CHAR
09/10/2012	Bar Poker Open $120 FINALE-5 PKGS GTD + WSOP Moneymaker Seat!!	60	12	CHAR
09/03/2012	COLUMBUS DAY MINI-MEGA	10	-	CHAR
07/02/2012	Bar Poker Open $120 FINALE-5 PKGS GTD + WSOP Moneymaker Seat!!	10	-	CHAR
06/29/2012	FRIDAY NIGHT MINI-MEGA NORWOOD	10	-	CHAR
06/25/2012	Bar Poker Open $120 FINALE-5 PKGS GTD + WSOP Moneymaker Seat!!	10	-	CHAR