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 = 31364

(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 = 31364 GROUP BY event_id) pts LEFT JOIN (SELECT event_id, SUM(points) AS points FROM participation_points WHERE player_id = 31364 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 = 31364 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/11/2016	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	74	9	N.SHR
01/28/2016	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
01/21/2016	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	137	1	N.SHR
01/14/2016	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
01/07/2016	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	52	13	N.SHR
12/15/2015	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
12/08/2015	Lakeside Tavern (TUES)- $300 Guaranteed	45	15	N.SHR
12/03/2015	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	135	1	N.SHR
11/12/2015	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	106	4	N.SHR
09/09/2015	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
09/02/2015	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
07/29/2015	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	93	7	N.SHR
07/15/2015	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	94	7	N.SHR
07/08/2015	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
07/01/2015	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	88	8	N.SHR
06/10/2015	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
05/27/2015	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
05/21/2015	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	38	16	N.SHR
04/14/2015	Lakeside Tavern (TUES)- $300 Guaranteed	106	5	N.SHR
01/22/2015	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
01/21/2015	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	41	15	N.SHR
01/20/2015	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
01/19/2015	K PUB \| $300 GTD \| BPO TOKENS	10	-	N.SHR
01/15/2015	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	85	8	N.SHR
01/14/2015	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
01/13/2015	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
01/07/2015	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	37	16	N.SHR
01/05/2015	K PUB \| $300 GTD \| BPO TOKENS	10	-	N.SHR
01/01/2015	New Year's Day-SUPER STACKED $1,000 GTD+ BPO HOTEL PKG!	10	-	N.SHR
12/30/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
12/29/2014	K PUB \| $300 GTD \| BPO TOKENS	100	7	N.SHR
12/27/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	10	-	N.SHR
12/23/2014	Lakeside Tavern (TUES)- $300 Guaranteed	64	11	N.SHR
12/22/2014	K PUB \| $300 GTD \| BPO TOKENS	10	-	N.SHR
12/16/2014	Lakeside Tavern (TUES)- $300 Guaranteed	96	6	N.SHR
12/15/2014	K PUB \| $300 GTD \| BPO TOKENS	10	-	N.SHR
12/13/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	93	6	N.SHR
12/10/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
12/09/2014	Lakeside Tavern (TUES)- $300 Guaranteed	48	14	N.SHR
12/03/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
11/28/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
11/26/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
11/25/2014	Lakeside Tavern (TUES)- $300 Guaranteed	73	9	N.SHR
11/21/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
11/19/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
11/15/2014	$30K FINALS CHAMPIONSHIP (POINTS)	10	-	CHAM
11/13/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
11/12/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
11/11/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
11/06/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
11/04/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
11/01/2014	BPO TRAVEL SATELLITE GRAND FINALE	10	-	CHAM
11/01/2014	$10,000 Monthly Championship	10	-	CHAM
10/31/2014	Fletcher Club Fridays- $400 GTD+ BPO Tokens!	69	10	LWLL
10/31/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
10/30/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	76	9	N.SHR
10/29/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
10/28/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
10/27/2014	K PUB \| $300 GTD \| BPO TOKENS	10	-	N.SHR
10/24/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
10/23/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
10/22/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	41	16	N.SHR
10/21/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
10/18/2014	$10,000 Monthly Championship	10	-	CHAM
10/17/2014	Fletcher Club Fridays- $400 GTD+ BPO Tokens!	10	-	LWLL
10/17/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
10/16/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	43	15	N.SHR
10/15/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	63	11	N.SHR
10/14/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
10/13/2014	K PUB \| $300 GTD \| BPO TOKENS	10	-	N.SHR
10/10/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
10/09/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	61	12	N.SHR
10/08/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	125	2	N.SHR
10/06/2014	K PUB \| $300 GTD \| BPO TOKENS	10	-	N.SHR
10/04/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	68	10	N.SHR
10/03/2014	Son's Of Italy $600 GTD FRIDAYS	63	12	N.SHR
10/02/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
10/01/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
09/29/2014	K PUB \| $300 GTD \| BPO TOKENS	10	-	N.SHR
09/27/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	10	-	N.SHR
09/26/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
09/25/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
09/24/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
09/23/2014	Lakeside Tavern (TUES)- $300 Guaranteed	123	2	N.SHR
09/22/2014	K PUB \| $300 GTD \| BPO TOKENS	10	-	N.SHR
09/18/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	93	7	N.SHR
09/17/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
09/16/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
09/13/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	114	3	N.SHR
09/11/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
09/10/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	45	15	N.SHR
09/09/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
09/08/2014	K PUB \| $300 GTD \| BPO TOKENS	10	-	N.SHR
09/06/2014	$10,000 Guaranteed Payout! 50K Finals Seat Added	46	14	CHAR
09/06/2014	BRENT DANIELS FUNDRAISER	110	4	CHAR
09/05/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
09/04/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	92	7	N.SHR
09/03/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
09/02/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
08/26/2014	Lakeside Tavern (TUES)- $300 Guaranteed	65	11	N.SHR
08/25/2014	K PUB \| $300 GTD \| BPO TOKENS	76	9	N.SHR
08/23/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	131	1	N.SHR
08/22/2014	Son's Of Italy $600 GTD FRIDAYS	115	4	N.SHR
08/21/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	103	5	N.SHR
08/20/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
08/19/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
08/15/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
08/14/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
08/13/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	37	-	N.SHR
08/09/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	37	16	N.SHR
08/08/2014	Son's Of Italy $600 GTD FRIDAYS	52	14	N.SHR
08/07/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
08/06/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
08/05/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
08/02/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	10	-	N.SHR
07/31/2014	HE Fletcher Club (Thursday) \| $300GTD + BPO TOKENS	10	-	LWLL
07/31/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
07/30/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
07/29/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
07/26/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	59	12	N.SHR
07/24/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
07/23/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
07/22/2014	Lakeside Tavern (TUES)- $300 Guaranteed	47	14	N.SHR
07/19/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	10	-	N.SHR
07/17/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
07/16/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
07/15/2014	Lakeside Tavern (TUES)- $300 Guaranteed	123	2	N.SHR
07/12/2014	$10,000 Monthly Championship	10	-	CHAM
07/11/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
07/11/2014	Fletcher Club Fridays- $400 GTD+ BPO Tokens!	104	5	LWLL
07/10/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
07/05/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	10	-	N.SHR
07/03/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	120	2	N.SHR
07/02/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
07/01/2014	Lakeside Tavern (TUES)- $300 Guaranteed	117	3	N.SHR
06/27/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
06/27/2014	Fletcher Club Fridays- $400 GTD+ BPO Tokens!	103	5	LWLL
06/26/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
06/25/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
06/24/2014	Lakeside Tavern (TUES)- $300 Guaranteed	88	7	N.SHR
06/21/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	75	9	N.SHR
06/18/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	42	-	N.SHR
06/17/2014	Lakeside Tavern (TUES)- $300 Guaranteed	58	12	N.SHR
06/13/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
06/12/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
06/11/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	55	13	N.SHR
06/10/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
06/06/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
06/05/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
06/04/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	102	5	N.SHR
06/03/2014	Lakeside Tavern (TUES)- $300 Guaranteed	91	7	N.SHR
05/31/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	10	-	N.SHR
05/30/2014	Son's Of Italy $600 GTD FRIDAYS	10	-	N.SHR
05/29/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	87	8	N.SHR
05/28/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
05/27/2014	Lakeside Tavern (TUES)- $300 Guaranteed	89	7	N.SHR
05/24/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	44	15	N.SHR
05/23/2014	Fletcher Club Fridays- $400 GTD+ BPO Tokens!	10	-	LWLL
05/22/2014	KOC #1829 \| Wednesdays \| $300 GTD + BPO TOKENS!	10	-	N.SHR
05/21/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	76	9	N.SHR
05/20/2014	Lakeside Tavern (TUES)- $300 Guaranteed	10	-	N.SHR
05/14/2014	Son's of Italy \| Thursdays \| $300 GTD + BPO Tokens	10	-	N.SHR
05/13/2014	Lakeside Tavern (TUES)- $300 Guaranteed	85	8	N.SHR
05/10/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	28	-	N.SHR
05/09/2014	Fletcher Club Fridays- $400 GTD+ BPO Tokens!	10	-	LWLL
04/26/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	52	-	N.SHR
04/19/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	44	16	N.SHR
04/12/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	10	-	N.SHR
04/11/2014	Fletcher Club Fridays- $400 GTD+ BPO Tokens!	10	-	LWLL
04/05/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	98	6	N.SHR
03/29/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	10	-	N.SHR
03/28/2014	Fletcher Club Fridays- $400 GTD+ BPO Tokens!	68	11	LWLL
03/22/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	59	13	N.SHR
03/21/2014	Fletcher Club Fridays- $400 GTD+ BPO Tokens!	10	-	LWLL
03/15/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	10	-	N.SHR
03/08/2014	Memorial Day 50K Special \| $1,000 GTD!!!! BPO TOKENS	10	-	N.SHR