(mysqli): SELECT * FROM cms LIMIT 1  
(mysqli): SELECT code FROM menus WHERE type ='tree'  
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 = 81  
(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 = 81 GROUP BY event_id) pts LEFT JOIN (SELECT event_id, SUM(points) AS points FROM participation_points WHERE player_id = 81 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 = 81 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
08/15/2025 $5,000 GTD @ MILLERVILLE CLUB **WITH DEALERS** 10 - CHAR
04/18/2025 $5,000 GTD @ MILLERVILLE CLUB **WITH DEALERS** 10 - CHAR
09/20/2024 $5,000 GTD @ MILLERVILLE CLUB **WITH DEALERS** 10 - CHAR
07/05/2024 $5,000 GTD @ MILLERVILLE CLUB **WITH DEALERS** 10 - C.MA
06/21/2024 $5,000 GTD @ MILLERVILLE CLUB **WITH DEALERS** 10 - C.MA
06/07/2024 $5,000 GTD @ MILLERVILLE CLUB **WITH DEALERS** 10 - C.MA
04/19/2024 $5,000 GTD @ MILLERVILLE CLUB **WITH DEALERS** 10 - CHAR
03/22/2024 $5,000 GTD @ MILLERVILLE CLUB **WITH DEALERS** 10 - C.MA
03/15/2024 $5,000 GTD @ MILLERVILLE CLUB **WITH DEALERS** 63 13 CHAR
03/08/2024 $5,000 GTD @ MILLERVILLE CLUB **WITH DEALERS** 10 - C.MA
02/16/2024 Millerville Club | $2,000 GTD | BPO TOKENS! 10 - CHAR
01/19/2024 Millerville Club | $2,000 GTD | BPO TOKENS! 10 - CHAR
03/17/2023 Millerville Club | $2,000 GTD | BPO TOKENS! 10 - CHAR
06/28/2022 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
07/05/2007 Balls Sports Bar 30 16 RI
06/14/2007 Balls Sports Bar 10 - RI
06/04/2007 Finnegan's Wake 105 3 RI
05/17/2007 Balls Sports Bar 50 12 RI
04/05/2007 Balls Sports Bar 10 - RI
03/29/2007 Balls Sports Bar 10 - RI
02/27/2007 Corner Pocket Billiards 10 - RI
02/09/2007 The Ground Round 10 - RI
01/26/2007 The Ground Round 110 2 RI
01/08/2007 Finnegan's Wake 10 - RI
12/15/2006 Corner Pocket Billiards 95 4 RI
12/04/2006 Finnegan's Wake 10 - RI
11/24/2006 Corner Pocket Billiards 35 15 RI
10/19/2006 Balls Sports Bar 10 - RI
10/12/2006 Balls Sports Bar 10 - RI
09/20/2006 Stephanie's Grill 10 - RI
09/14/2006 Balls Sports Bar 10 - RI
09/13/2006 Stephanie's Grill 65 9 RI
09/12/2006 Corner Pocket Billiards 10 - RI
09/10/2006 Rhode Island Indoor Sports 10 - RI
09/07/2006 Balls Sports Bar 10 - RI
09/06/2006 Stephanie's Grill 10 - RI
09/03/2006 Corner Pocket Billiards 95 4 RI
09/01/2006 Friday Nights @ Red's Kitchen-- $600 GTD PAYOUT + BPO TOKENS 10 - RI
08/31/2006 Balls Sports Bar 10 - RI
08/30/2006 Stephanie's Grill 10 - RI
08/27/2006 Rhode Island Indoor Sports 10 - RI
08/23/2006 Stephanie's Grill 10 - RI
08/20/2006 Box Seats 90 5 S.MA
08/18/2006 Friday Nights @ Red's Kitchen-- $600 GTD PAYOUT + BPO TOKENS 10 - RI
08/17/2006 Balls Sports Bar 10 - RI
08/15/2006 Corner Pocket Billiards 10 - RI
08/14/2006 Finnegan's Wake 10 - RI
08/13/2006 Rhode Island Indoor Sports 10 - RI
08/11/2006 Friday Nights @ Red's Kitchen-- $600 GTD PAYOUT + BPO TOKENS 90 5 RI
08/10/2006 Balls Sports Bar 10 - RI
08/09/2006 Stephanie's Grill 10 - RI
08/07/2006 Finnegan's Wake 10 - RI
08/04/2006 Friday Nights @ Red's Kitchen-- $600 GTD PAYOUT + BPO TOKENS 105 3 RI
08/03/2006 Balls Sports Bar 95 4 RI
08/02/2006 Stephanie's Grill 10 - RI
07/28/2006 Friday Nights @ Red's Kitchen-- $600 GTD PAYOUT + BPO TOKENS 10 - RI
07/27/2006 Balls Sports Bar 10 - RI
07/26/2006 Stephanie's Grill 10 - RI
07/25/2006 Corner Pocket Billiards 10 - RI
07/20/2006 Balls Sports Bar 10 - RI
07/19/2006 Stephanie's Grill 10 - RI
07/12/2006 Stephanie's Grill 10 - RI
07/11/2006 Corner Pocket Billiards 10 - RI
07/10/2006 Finnegan's Wake 55 11 RI
07/07/2006 Friday Nights @ Red's Kitchen-- $600 GTD PAYOUT + BPO TOKENS 10 - RI
07/06/2006 Balls Sports Bar 10 - RI
06/29/2006 Balls Sports Bar 10 - RI
06/26/2006 Finnegan's Wake 95 4 RI
06/23/2006 Friday Nights @ Red's Kitchen-- $600 GTD PAYOUT + BPO TOKENS 65 9 RI
06/21/2006 Stephanie's Grill 55 11 RI
06/16/2006 Stephanie's Grill 10 - RI
06/15/2006 Balls Sports Bar 10 - RI
06/14/2006 Stephanie's Grill 10 - RI
06/13/2006 Corner Pocket Billiards 120 1 RI
06/12/2006 Finnegan's Wake 10 - RI
06/09/2006 Friday Nights @ Red's Kitchen-- $600 GTD PAYOUT + BPO TOKENS 10 - RI
06/05/2006 Finnegan's Wake 65 9 RI
06/04/2006 Rhode Island Indoor Sports 10 - RI
06/01/2006 Balls Sports Bar 10 - RI
05/19/2006 Friday Nights @ Red's Kitchen-- $600 GTD PAYOUT + BPO TOKENS 80 7 RI
05/18/2006 Balls Sports Bar 10 - RI
05/17/2006 Stephanie's Grill 10 - RI
05/16/2006 Corner Pocket Billiards 10 - RI
05/15/2006 Finnegan's Wake 10 - RI
05/11/2006 Balls Sports Bar 10 - RI
04/30/2006 Rhode Island Indoor Sports 45 13 RI
04/25/2006 Corner Pocket Billiards 10 - RI
04/24/2006 Finnegan's Wake 10 - RI
04/09/2006 Rhode Island Indoor Sports 10 - RI
03/24/2006 Friday Nights @ Red's Kitchen-- $600 GTD PAYOUT + BPO TOKENS 120 1 RI
03/23/2006 Balls Sports Bar 65 9 RI