(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 = 28389  
(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 = 28389 GROUP BY event_id) pts LEFT JOIN (SELECT event_id, SUM(points) AS points FROM participation_points WHERE player_id = 28389 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 = 28389 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
10/26/2015 New Year's Day Bounty 10 - CHAR
10/09/2015 Friday $3,000 Guarantee 92 8 CHAR
10/03/2015 $150 SUPERSTACK- 80% PAYOUT! 129 2 CHAR
09/07/2015 New Year's Day Bounty 10 - CHAR
09/07/2015 BPO AC Travel Satellite 10 - CHAR
08/15/2015 New Year's Day $10,000 GTD SUPERSTACK 10 - CHAR
08/07/2015 Friday $3,000 Guarantee 37 16 CHAR
07/29/2015 Walpole VFW 10 - CHAR
07/24/2015 Friday $3,000 Guarantee 10 - CHAR
07/22/2015 Walpole VFW 10 - CHAR
07/18/2015 Italian American Club (Walpole) 10 - CHAR
07/18/2015 $10,000 Guaranteed Payout! 50K Finals Seat Added 10 - CHAR
07/10/2015 Friday $3,000 Guarantee 10 - CHAR
07/01/2015 Walpole VFW 102 5 CHAR
06/12/2015 $3000 GTD Holiday Mini-Mega 104 4 CHAR
05/25/2015 Memorial Day $100 Maxx staxx 130 3 CHAR
05/23/2015 $10,000 Guaranteed Payout! 50K Finals Seat Added 70 10 CHAR
05/23/2015 Italian American Club (Walpole) 10 - CHAR
05/22/2015 $3000 GTD Holiday Mini-Mega 103 6 CHAR
05/16/2015 New Year's Day $10,000 GTD SUPERSTACK 10 - CHAR
05/06/2015 Walpole VFW 10 - CHAR
05/02/2015 $10,000 Guaranteed Payout! 50K Finals Seat Added 52 14 CHAR
05/01/2015 $3000 GTD Holiday Mini-Mega 124 2 CHAR
04/25/2015 $60 Cheapstack @ Norwood Elks 10 - CHAR
04/25/2015 $150 SUPERSTACK 80% PAYOUT 10 - CHAR
04/22/2015 Walpole VFW 10 - CHAR
04/11/2015 Italian American Club (Walpole) 44 16 CHAR
04/11/2015 $10,000 Guaranteed Payout! 50K Finals Seat Added 10 - CHAR
04/01/2015 Walpole VFW 10 - CHAR
03/28/2015 $10,000 Guaranteed Payout! 50K Finals Seat Added 103 6 CHAR
03/14/2015 $60 Cheapstack @ Norwood Elks 10 - CHAR
03/14/2015 $150 SUPERSTACK 80% PAYOUT 10 - CHAR
03/07/2015 $150 SUPERSTACK 80% PAYOUT 133 3 CHAR
02/28/2015 Italian American Club (Walpole) 10 - CHAR
02/28/2015 $10,000 Guaranteed Payout! 50K Finals Seat Added 10 - CHAR
11/04/2014 Lakeside Tavern (TUES)- $300 Guaranteed 10 - N.SHR
10/28/2014 Lakeside Tavern (TUES)- $300 Guaranteed 10 - N.SHR
10/14/2014 Lakeside Tavern (TUES)- $300 Guaranteed 10 - N.SHR
01/29/2014 Walpole VFW 79 9 CHAR
11/23/2013 $150 SUPERSTACK 80% PAYOUT 47 15 CHAR
11/23/2013 Italian American Club (Walpole) 10 - CHAR
11/09/2013 Italian American Club (Walpole) 10 - CHAR
11/09/2013 $150 SUPERSTACK 80% PAYOUT 10 - CHAR
11/04/2013 President’s Day Bounty 62 11 CHAR
10/26/2013 Italian American Club (Walpole) 50 13 CHAR
10/26/2013 $150 SUPERSTACK 43 15 CHAR
10/23/2013 Walpole VFW 98 6 CHAR
10/19/2013 $150 SUPERSTACK 80% PAYOUT 10 - CHAR
10/16/2013 Walpole VFW 10 - CHAR
10/14/2013 President’s Day Bounty 10 - CHAR
10/02/2013 Walpole VFW 76 10 CHAR
09/02/2013 MNB - DEDHAM LEGION THIS WEEK!! 10 - CHAR
09/02/2013 Columbus Day $80 Mini Mega 10 - CHAR
08/24/2013 $150 SUPERSTACK 80% PAYOUT 41 16 CHAR
08/17/2013 $150 SUPERSTACK 80% PAYOUT 102 5 CHAR
07/29/2013 MNB - DEDHAM LEGION THIS WEEK!! 10 - CHAR
07/24/2013 Walpole VFW 10 - CHAR
07/13/2013 $150 SUPERSTACK 80% PAYOUT 87 8 CHAR
07/10/2013 Walpole VFW 10 - CHAR
07/03/2013 Walpole VFW 10 - CHAR
06/26/2013 Walpole VFW 123 2 CHAR
06/19/2013 Walpole VFW 10 - CHAR
06/15/2013 $150 SUPERSTACK- 80% PAYOUT! 10 - CHAR
06/12/2013 Walpole VFW 10 - CHAR
06/08/2013 $150 SUPERSTACK- 80% PAYOUT! 92 7 CHAR
05/29/2013 Walpole VFW 41 16 CHAR
05/27/2013 Bar Poker Open $120 FINALE-5 PKGS GTD + WSOP Moneymaker Seat!! 61 11 CHAR
05/27/2013 $80 Mini Mega -Memorial Day 10 - CHAR
05/22/2013 Walpole VFW 118 3 CHAR
05/15/2013 Walpole VFW 74 9 CHAR
05/11/2013 $150 SUPERSTACK- 80% PAYOUT! 120 2 CHAR
05/01/2013 Walpole VFW 10 - CHAR
04/24/2013 Walpole VFW 76 9 CHAR
04/06/2013 $150 SUPERSTACK 10 - CHAR
03/30/2013 $150 SUPERSTACK 116 3 CHAR
03/27/2013 Walpole VFW 105 5 CHAR
03/13/2013 Walpole VFW 10 - CHAR
03/06/2013 Walpole VFW 10 - CHAR
02/27/2013 Dedham VFW 10 - CHAR
02/19/2013 Lakeside Tavern (TUES)- $300 Guaranteed 10 - N.SHR
02/18/2013 Veteran's Day Mini Mega 109 4 CHAR
02/18/2013 PRESIDENT'S DAY MINI-MEGA 10 - CHAR
02/13/2013 Walpole VFW 10 - CHAR