Eastern Poker Tour

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

(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 = 30563 GROUP BY event_id) pts LEFT JOIN (SELECT event_id, SUM(points) AS points FROM participation_points WHERE player_id = 30563 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 = 30563 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
01/17/2020	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
06/22/2019	$10,000 Monthly Championship	10	-	CHAM
06/14/2019	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	101	6	S.MA
05/03/2019	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	153	1	S.MA
04/20/2019	$10,000 Guaranteed Payout! 50K Finals Seat Added	10	-	CHAR
04/19/2019	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
04/12/2019	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
03/14/2019	Walpole VFW	10	-	CHAR
03/08/2019	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
02/18/2019	$100 PREZ DAY MAXX STAXX	10	-	CHAR
01/11/2019	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
12/20/2018	Walpole VFW	10	-	CHAR
12/17/2018	Knights Of Columbus- $300 GTD + BPO TOKENS	10	-	S.MA
12/07/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
11/30/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
11/15/2018	Walpole VFW	10	-	CHAR
11/08/2018	Walpole VFW	69	10	CHAR
11/02/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
10/30/2018	7/12 PNC TUESDAYS- $300 Guaranteed! BPO Tokens	10	-	S.MA
10/25/2018	Walpole VFW	10	-	CHAR
10/19/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
10/13/2018	Saturday @ PNC Club 12:30-$300 GTD PAYOUT + BPO Tokens!	10	-	S.MA
10/12/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
09/28/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	58	14	S.MA
09/21/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
09/14/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
08/16/2018	Mitchell Club I $300 GTD + BPO TOKENS! THURS	77	9	S.MA
08/11/2018	$10,000 Monthly Championship	10	-	CHAM
08/09/2018	Mitchell Club I $300 GTD + BPO TOKENS! THURS	10	-	S.MA
08/04/2018	$10,000 Guaranteed Payout! 50K Finals Seat Added	10	-	CHAR
08/03/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
07/27/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	155	1	S.MA
07/13/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
06/28/2018	Walpole VFW	10	-	CHAR
06/21/2018	Walpole VFW	10	-	CHAR
06/15/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	51	15	S.MA
06/09/2018	$60 Cheapstack @ WALPOLE VFW	10	-	CHAR
06/01/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
05/18/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
05/11/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
04/27/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
04/20/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	45	16	S.MA
04/07/2018	$40 BPO TRAVEL SATELLITE @ Walpole VFW	10	-	CHAR
04/06/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
04/01/2018	PNC Club @ SUNDAY \| $300 GTD \| 4:00PM FREE WEEK ADDED	127	3	S.MA
03/24/2018	$10,000 Guaranteed Payout! 50K Finals Seat Added	10	-	CHAR
03/23/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
03/09/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
03/01/2018	Walpole VFW	10	-	CHAR
02/23/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	56	15	S.MA
02/16/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
02/09/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
02/08/2018	Walpole VFW	70	10	CHAR
02/03/2018	$60 Cheapstack @ WALPOLE VFW	10	-	CHAR
02/02/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
01/26/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
01/20/2018	$10,000 Guaranteed Payout! 50K Finals Seat Added	10	-	CHAR
01/12/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	73	11	S.MA
01/05/2018	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
01/01/2018	$80 Mini Mega -Memorial Day	10	-	CHAR
12/30/2017	$60 Cheapstack @ WALPOLE VFW	10	-	CHAR
12/29/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
12/22/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
12/01/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
11/24/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
11/18/2017	$60 Cheapstack @ Norwood Elks	10	-	CHAR
11/17/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
11/10/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
11/02/2017	Mitchell Club I $300 GTD + BPO TOKENS! THURS	49	14	S.MA
10/27/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	77	10	S.MA
10/14/2017	$10,000 Monthly Championship	10	-	CHAR
10/13/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	63	13	S.MA
09/22/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	104	6	S.MA
09/20/2017	Walpole VFW	10	-	CHAR
09/15/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	102	7	S.MA
09/13/2017	Walpole VFW	107	4	CHAR
09/09/2017	$10,000 Guaranteed Payout! 50K Finals Seat Added	134	1	CHAR
09/08/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
09/07/2017	Mitchell Club I $300 GTD + BPO TOKENS! THURS	107	4	S.MA
09/04/2017	$180 - Veteran's Deepstack	10	-	CHAR
09/01/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	137	2	S.MA
08/25/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	156	1	S.MA
08/18/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
08/05/2017	$60 Cheapstack @ Norwood Elks	10	-	CHAR
07/29/2017	Italian American Club (Walpole)	64	11	CHAR
07/21/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
07/14/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
07/07/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
06/24/2017	$60 Cheapstack @ Norwood Elks	10	-	CHAR
06/23/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
06/17/2017	$150 SUPERSTACK 80% PAYOUT	10	-	CHAR
06/16/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
05/29/2017	$120 Fourth Of July Maxx Staxx	10	-	CHAR
04/28/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
04/21/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
03/31/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
02/17/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	97	8	S.MA
02/11/2017	$150 SUPERSTACK	10	-	CHAR
02/04/2017	$60 Cheapstack @ WALPOLE VFW	10	-	CHAR
02/03/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
01/28/2017	$60 Cheapstack @ Norwood Elks	10	-	CHAR
01/27/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
01/20/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
01/06/2017	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
12/23/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
12/17/2016	$120 Fourth Of July Maxx Staxx	10	-	CHAR
12/16/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
12/09/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
12/02/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	131	2	S.MA
11/11/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
11/05/2016	$30K FINALS CHAMPIONSHIP (POINTS)	10	-	CHAM
11/04/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
10/22/2016	$10,000 Guaranteed Payout! 50K Finals Seat Added	10	-	CHAR
10/21/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
10/03/2016	Bar Poker Open $120 FINALE-5 PKGS GTD + WSOP Moneymaker Seat!!	10	-	CHAR
09/23/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
09/22/2016	Mitchell Club I $300 GTD + BPO TOKENS! THURS	10	-	S.MA
09/12/2016	New Year's Day Bounty	10	-	CHAR
09/02/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	120	5	S.MA
08/18/2016	Mitchell Club I $300 GTD + BPO TOKENS! THURS	10	-	S.MA
08/12/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
08/05/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
07/25/2016	New Year's Day Bounty	10	-	CHAR
07/15/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	73	11	S.MA
07/09/2016	$150 SUPERSTACK 80% PAYOUT	10	-	CHAR
06/27/2016	New Year's Day Bounty	102	5	CHAR
06/24/2016	Friday Night 80/80/40	10	-	CHAR
06/17/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
06/10/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
06/06/2016	New Year's Day Bounty	10	-	CHAR
06/03/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
05/30/2016	BPO AC Travel Satellite	10	-	CHAR
05/28/2016	$60 Cheapstack @ Norwood Elks	134	1	CHAR
05/20/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
05/13/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
05/06/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
05/02/2016	New Year's Day Bounty	10	-	CHAR
04/30/2016	$30K FINALS CHAMPIONSHIP (POINTS)	10	-	CHAM
04/29/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	51	13	S.MA
04/22/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
04/15/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
04/08/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
04/01/2016	Friday $3,000 Guarantee	10	-	CHAR
03/28/2016	New Year's Day Bounty	10	-	CHAR
03/25/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
03/14/2016	New Year's Day Bounty	10	-	CHAR
03/07/2016	New Year's Day Bounty	10	-	CHAR
03/04/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
02/29/2016	New Year's Day Bounty	10	-	CHAR
02/15/2016	BPO AC Travel Satellite	10	-	CHAR
02/05/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
02/01/2016	New Year's Day Bounty	103	4	CHAR
01/15/2016	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
01/08/2016	Friday $3,000 Guarantee	10	-	CHAR
12/26/2015	$150 SUPERSTACK 80% PAYOUT	10	-	CHAR
12/04/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	144	1	S.MA
11/28/2015	$150 SUPERSTACK 80% PAYOUT	10	-	CHAR
11/27/2015	$10,000 GUARANTEED SUPERSTACKED EVENT!	10	-	CHAR
11/25/2015	Walpole VFW	57	12	CHAR
11/20/2015	PNC Club @ SUNDAY \| $300 GTD \| 4:00PM FREE WEEK ADDED	10	-	S.MA
11/13/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
10/30/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
10/19/2015	New Year's Day Bounty	10	-	CHAR
10/16/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
10/12/2015	BPO AC Travel Satellite	10	-	CHAR
10/09/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
10/02/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	74	10	S.MA
09/25/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
09/18/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	73	10	S.MA
09/04/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
08/24/2015	New Year's Day Bounty	10	-	CHAR
08/21/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	73	9	S.MA
08/19/2015	Weds Night Deepstack	10	-	CHAR
08/17/2015	New Year's Day Bounty	10	-	CHAR
08/14/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
07/31/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
07/24/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	45	15	S.MA
07/17/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
06/19/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
06/12/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
06/05/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	122	2	S.MA
05/30/2015	$30K FINALS CHAMPIONSHIP (POINTS)	10	-	CHAM
05/25/2015	$180 - Veteran's Deepstack	136	1	CHAR
05/16/2015	New Year's Day $10,000 GTD SUPERSTACK	10	-	CHAR
05/15/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	61	12	S.MA
05/08/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	55	13	S.MA
05/01/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
04/27/2015	New Year's Day Bounty	10	-	CHAR
04/24/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
04/20/2015	BPO AC Travel Satellite	10	-	CHAR
04/17/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	136	1	S.MA
03/27/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	65	-	S.MA
03/20/2015	PNC CLUB\| $400 GTD + BPO TOKENS \| FRIDAY NIGHT	10	-	S.MA
03/06/2015	$2K GTD! MINI MEGA- WALPOLE	10	-	CHAR
02/07/2015	$60 Cheapstack @ Norwood Elks	10	-	CHAR
01/31/2015	$60 Cheapstack @ Norwood Elks	10	-	CHAR
01/19/2015	$180 - Veteran's Deepstack	10	-	CHAR
01/10/2015	$10,000 Guaranteed Payout! 50K Finals Seat Added	10	-	CHAR
01/03/2015	Italian American Club (Walpole)	116	3	CHAR
12/27/2014	$150 SUPERSTACK 80% PAYOUT	10	-	CHAR
12/20/2014	HOLIDAY CHEAPSTACK $2,000 GUARANTEED!	10	-	CHAR
10/27/2014	New Year's Day Bounty	119	3	CHAR
08/30/2014	$10,000 Guaranteed Payout! 50K Finals Seat Added	45	14	CHAR
08/18/2014	New Year's Day Bounty	10	-	CHAR
07/28/2014	New Year's Day Bounty	10	-	CHAR
05/04/2014	Memorial Day $80 MINI-MEGA	10	-	CHAR
05/03/2014	$120 Deepstack @ 5PM	93	7	CHAR
04/28/2014	New Year's Day Bounty	120	3	CHAR
03/15/2014	$60 Cheapstack @ Norwood Elks	10	-	CHAR
02/24/2014	Bar Poker Open $120 FINALE-5 PKGS GTD + WSOP Moneymaker Seat!!	91	7	CHAR
02/17/2014	Memorial Day $100 Maxx staxx	10	-	CHAR
02/07/2014	Friday $3,000 Guarantee	10	-	CHAR
11/15/2013	Friday $3,000 Guarantee	10	-	CHAR