---

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

---

---

(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 = 28310 GROUP BY event_id) pts LEFT JOIN (SELECT event_id, SUM(points) AS points FROM participation_points WHERE player_id = 28310 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 = 28310 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
05/07/2022	Walpole VFW	108	6	CHAR
01/08/2022	$150 DEEPSTACK!	61	12	CHAR
11/26/2021	$25,000 GUARANTEED BLACK FRIDAY EVENT	10	-	CHAR
10/02/2021	$150 DEEPSTACK!	57	13	CHAR
11/17/2018	TEAM POKER CHAMPIONSHIP 11 - $15,000 GTD!	10	-	CHAR
11/15/2018	Walpole VFW	10	-	CHAR
11/01/2018	Walpole VFW	10	-	CHAR
10/28/2017	TEAM POKER CHAMPIONSHIP 11 - $15,000 GTD!	10	-	CHAR
08/05/2017	$10,000 Guaranteed Payout! 50K Finals Seat Added	72	10	CHAR
12/17/2016	$120 Fourth Of July Maxx Staxx	65	14	CHAR
10/08/2016	TEAM POKER CHALLENGE 8 - $20,000 GUARANTEED!	10	-	CHAR
10/01/2016	$10,000 GTD + WSOP CARIBBEAN PKG ADDED! (80%+ WSOP PAYOUT)	10	-	CHAR
09/10/2016	No event this week	10	-	CHAR
09/03/2016	$10,000 Guaranteed Payout! 50K Finals Seat Added	121	3	CHAR
08/22/2015	$10,000 Guaranteed Payout! 50K Finals Seat Added	10	-	CHAR
11/12/2014	Walpole VFW	10	-	CHAR
02/17/2014	Memorial Day $100 Maxx staxx	10	-	CHAR
02/12/2014	Walpole VFW	10	-	CHAR
09/14/2013	$10,000 Guaranteed Payout! 50K Finals Seat Added	42	15	CHAR
09/14/2013	TEAM POKER CHALLENGE 8 - $20,000 GUARANTEED!	10	-	CHAR
09/07/2013	Memorial Day $100 Maxx staxx	10	-	CHAR
09/02/2013	Columbus Day $80 Mini Mega	10	-	CHAR
08/31/2013	$10,000 Guaranteed Payout! 50K Finals Seat Added	39	16	CHAR
08/14/2013	Walpole VFW	10	-	CHAR
08/03/2013	$6,000 GTD - $160 SUPERSTACK (80%)	118	3	CHAR
07/20/2013	Memorial Day $100 Maxx staxx	10	-	CHAR
07/15/2013	Bar Poker Open $120 FINALE-5 PKGS GTD + WSOP Moneymaker Seat!!	10	-	CHAR
07/13/2013	$150 SUPERSTACK 80% PAYOUT	53	13	CHAR
06/29/2013	$10,000 Guaranteed Payout! 50K Finals Seat Added	10	-	CHAR
06/08/2013	WSOP QUALIFIER (2 x $12K PKGS GUARANTEED)	10	-	CHAR
05/25/2013	$150 SUPERSTACK	66	10	CHAR
03/13/2013	Walpole VFW	10	-	CHAR
02/06/2013	Walpole VFW	108	5	CHAR