(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 = 23506  
(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 = 23506 GROUP BY event_id) pts LEFT JOIN (SELECT event_id, SUM(points) AS points FROM participation_points WHERE player_id = 23506 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 = 23506 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/01/2024 Walpole VFW 10 - CHAR
12/19/2023 Italian American Club (Walpole) 10 - CHAR
11/24/2023 Walpole VFW 35 16 CHAR
10/14/2023 Walpole VFW 10 - CHAR
10/02/2023 Italian American Club (Walpole) 10 - CHAR
09/30/2023 Walpole VFW 125 2 CHAR
09/23/2023 Walpole VFW 10 - CHAR
09/16/2023 Walpole VFW 144 1 CHAR
09/16/2023 Walpole VFW 10 - CHAR
09/09/2023 Walpole VFW 10 - CHAR
09/07/2023 Walpole VFW 109 4 CHAR
09/04/2023 Italian American Club (Walpole) 10 - CHAR
08/24/2023 Walpole VFW 10 - CHAR
08/05/2023 Walpole VFW 10 - CHAR
07/27/2023 Walpole VFW 10 - CHAR
07/20/2023 Walpole VFW 10 - CHAR
07/08/2023 Walpole VFW 10 - CHAR
06/24/2023 Walpole VFW 105 5 CHAR
05/27/2023 Walpole VFW 10 - CHAR
05/06/2023 Walpole VFW 10 - CHAR
04/29/2023 Walpole VFW 10 - CHAR
04/15/2023 Walpole VFW 10 - CHAR
04/15/2023 Walpole VFW 10 - CHAR
04/02/2023 2023 Eastern Poker Open 10 - CHAR
04/01/2023 2023 Eastern Poker Open 10 - CHAM
03/31/2023 2023 Eastern Poker Open 124 2 CHAR
03/31/2023 2023 Eastern Poker Open 10 - CHAR
03/18/2023 Walpole VFW 10 - CHAR
02/26/2023 *10/18* THE RALLY l SUNDAY |$300 GTD | 4:00PM FREE WEEK ADDED 68 10 RI
02/20/2023 Italian American Club (Walpole) 110 5 CHAR
02/11/2023 Walpole VFW 10 - CHAR
02/11/2023 $10,000 Monthly Championship 10 - CHAM
02/09/2023 Walpole VFW 87 8 CHAR
02/05/2023 *10/18* THE RALLY l SUNDAY |$300 GTD | 4:00PM FREE WEEK ADDED 62 11 RI
01/28/2023 Walpole VFW 109 4 CHAR
01/27/2023 Millerville Club | $2,000 GTD | BPO TOKENS! 10 - C.MA
01/21/2023 Walpole VFW 10 - CHAR
01/19/2023 Walpole VFW 107 4 CHAR
01/14/2023 $10,000 Monthly Championship 10 - CHAM
01/12/2023 Walpole VFW 116 3 CHAR
12/17/2022 Knights of Columbus- Stoughton 142 1 CHAR
11/05/2022 Walpole VFW 95 7 CHAR
09/17/2022 Walpole VFW 46 15 CHAR
09/17/2022 Walpole VFW 10 - CHAR
09/15/2022 Walpole VFW 88 8 CHAR
09/10/2022 Walpole VFW 10 - CHAR
09/03/2022 Walpole VFW 10 - CHAR
08/25/2022 Walpole VFW 10 - CHAR
08/20/2022 $60 CHEAPSTACK 119 3 CHAR
08/20/2022 Walpole VFW 41 16 CHAR
08/06/2022 Walpole VFW 10 - CHAR
07/16/2022 Walpole VFW 46 15 CHAR
04/10/2022 Milford DoubleTree Championships 10 - CHAR
04/10/2022 Milford DoubleTree Championships 10 - CHAM
04/09/2022 Milford DoubleTree Championships 10 - CHAR
03/19/2022 $150 DEEPSTACK! 10 - CHAR
02/12/2022 $150 DEEPSTACK! 10 - CHAR
02/03/2022 Walpole VFW 59 12 CHAR
01/22/2022 $10,000 Monthly Championship 10 - CHAM
01/17/2022 $80 Mini Mega -Memorial Day 123 1 CHAR
01/17/2022 $100 Deepstack 10 - CHAR
01/13/2022 Walpole VFW 10 - CHAR
01/08/2022 $150 DEEPSTACK! 10 - CHAR
01/01/2022 $20,022 GUARANTEED NEW YEAR'S SPECIAL 10 - CHAR
12/30/2021 Walpole VFW 10 - CHAR
12/23/2021 Walpole VFW 10 - CHAR
12/18/2021 $150 DEEPSTACK! 10 - CHAR
12/16/2021 Walpole VFW 10 - CHAR
12/14/2021 $300 GTD @ Sports Legends Pub- BPO TOKENS! 49 15 RI
12/13/2021 Marasco's Bar & Grill $300 GTD + BPO TOKENS! 10 - RI
12/09/2021 Walpole VFW 10 - CHAR
12/06/2021 Marasco's Bar & Grill $300 GTD + BPO TOKENS! 76 9 RI
12/04/2021 $20,022 GUARANTEED NEW YEAR'S SPECIAL 10 - CHAR
12/02/2021 Walpole VFW 43 15 CHAR
11/27/2021 $150 DEEPSTACK! 140 1 CHAR
11/26/2021 $25,000 GUARANTEED BLACK FRIDAY EVENT 10 - CHAR
11/20/2021 $150 DEEPSTACK! 127 3 CHAR
11/18/2021 Walpole VFW 10 - CHAR
11/06/2021 $10,000 Guaranteed Payout! 50K Finals Seat Added 113 6 CHAR
10/30/2021 $150 DEEPSTACK! 10 - CHAR
10/14/2021 Walpole VFW 10 - CHAR
10/09/2021 $150 DEEPSTACK! 10 - CHAR
10/07/2021 Walpole VFW 10 - CHAR
10/02/2021 $150 DEEPSTACK! 10 - CHAR
09/18/2021 $10,000 Guaranteed Payout! 50K Finals Seat Added 10 - CHAR
09/16/2021 Walpole VFW 40 16 CHAR
09/11/2021 $150 DEEPSTACK! 100 7 CHAR
09/06/2021 Columbus Day - $180 MAXX STAXX 74 10 CHAR
09/04/2021 $150 DEEPSTACK! 116 3 CHAR
08/26/2021 Walpole VFW 121 3 CHAR
08/19/2021 Walpole VFW 46 15 CHAR
08/12/2021 Walpole VFW 10 - CHAR
07/31/2021 $150 DEEPSTACK! 41 16 CHAR
07/29/2021 Walpole VFW 10 - CHAR
07/24/2021 $150 DEEPSTACK! 10 - CHAR
07/17/2021 $150 DEEPSTACK! 102 6 CHAR
07/15/2021 Walpole VFW 10 - CHAR
07/05/2021 $180 - Veteran's Deepstack 154 1 CHAR
02/27/2020 Walpole VFW 10 - CHAR
02/13/2020 Walpole VFW 95 6 CHAR
02/06/2020 Walpole VFW 10 - CHAR
01/23/2020 Walpole VFW 10 - CHAR
01/16/2020 Walpole VFW 10 - CHAR
01/09/2020 Walpole VFW 119 2 CHAR
01/01/2020 $100 PREZ DAY MAXX STAXX 82 9 CHAR
12/22/2019 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 10 - RI
11/29/2019 $10,000 GUARANTEED SUPERSTACKED EVENT! 10 - CHAR
11/18/2019 THE RALLY | $300 GTD | BPO TOKENS 10 - RI
11/11/2019 VETERAN'S DAY SPECIAL Mega Staxxx 10 - CHAR
11/03/2019 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 68 11 RI
10/14/2019 $180 - Veteran's Deepstack 102 6 CHAR
09/21/2019 $150 SUPERSTACK-NORWOOD ELKS 76 10 CHAR
09/02/2019 $180 - Veteran's Deepstack 10 - CHAR
08/15/2019 Walpole VFW 10 - CHAR
05/27/2019 $180 - Veteran's Deepstack 10 - CHAR
05/16/2019 Walpole VFW 10 - CHAR
05/13/2019 THE RALLY | $300 GTD | BPO TOKENS 94 8 RI
04/25/2019 Walpole VFW 53 13 CHAR
04/06/2019 $30K FINALS CHAMPIONSHIP (POINTS) 10 - CHAM
03/31/2019 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 10 - RI
03/21/2019 Walpole VFW 10 - CHAR
02/25/2019 THE RALLY | $300 GTD | BPO TOKENS 10 - RI
02/18/2019 $100 PREZ DAY MAXX STAXX 10 - CHAR
01/28/2019 THE RALLY | $300 GTD | BPO TOKENS 54 14 RI
01/27/2019 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 10 - RI
01/19/2019 $10,000 Guaranteed Payout! 50K Finals Seat Added 10 - CHAR
01/10/2019 Walpole VFW 10 - CHAR
01/03/2019 Walpole VFW 90 8 CHAR
12/01/2018 $10,000 Guaranteed Payout! 50K Finals Seat Added 10 - CHAR
11/01/2018 Walpole VFW 125 2 CHAR
10/18/2018 Walpole VFW 10 - CHAR
10/08/2018 $180 - Veteran's Deepstack 123 3 CHAR
10/04/2018 Walpole VFW 94 6 CHAR
09/09/2018 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 10 - RI
08/30/2018 Walpole VFW 105 5 CHAR
08/28/2018 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
08/23/2018 Walpole VFW 10 - CHAR
08/09/2018 Walpole VFW 10 - CHAR
08/07/2018 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
07/29/2018 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 10 - RI
07/19/2018 The Islander- $800 Guaranteed Payout! 10 - RI
07/16/2018 VFW 486- Monday - $300 GTD + BPO TOKENS 75 9 S.CST
07/13/2018 Friday Nights @ Red's Kitchen-- $600 GTD PAYOUT + BPO TOKENS 132 3 RI
07/10/2018 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
06/19/2018 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
06/07/2018 Walpole VFW 10 - CHAR
05/28/2018 $180 - Veteran's Deepstack 63 13 CHAR
05/24/2018 Walpole VFW 10 - CHAR
05/17/2018 Walpole VFW 139 1 CHAR
04/16/2018 $180 - Veteran's Deepstack 10 - CHAR
04/05/2018 Walpole VFW 10 - CHAR
03/04/2018 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 10 - RI
03/03/2018 $10,000 Guaranteed Payout! 50K Finals Seat Added 10 - CHAR
02/19/2018 $180 - Veteran's Deepstack 10 - CHAR
02/11/2018 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 10 - RI
02/08/2018 Walpole VFW 10 - CHAR
01/15/2018 $180 - Veteran's Deepstack 10 - CHAR
01/01/2018 New Year's Day $10,000 GTD SUPERSTACK 10 - CHAR
12/16/2017 $150 SUPERSTACK 80% PAYOUT 46 15 CHAR
11/24/2017 $10,000 GUARANTEED SUPERSTACKED EVENT! 10 - CHAR
10/18/2017 Walpole VFW 10 - CHAR
10/16/2017 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 10 - RI
10/10/2017 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
10/09/2017 $180 - Veteran's Deepstack 10 - CHAR
09/30/2017 $10,000 Guaranteed Payout! 50K Finals Seat Added 76 9 CHAR
09/28/2017 The Islander- $800 Guaranteed Payout! 10 - RI
09/26/2017 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
09/14/2017 The Islander- $800 Guaranteed Payout! 10 - RI
09/04/2017 $180 - Veteran's Deepstack 126 3 CHAR
08/31/2017 The Islander- $800 Guaranteed Payout! 10 - RI
08/22/2017 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
06/11/2017 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 141 1 RI
06/08/2017 The Islander- $800 Guaranteed Payout! 10 - RI
05/29/2017 $120 Fourth Of July Maxx Staxx 84 9 CHAR
05/17/2017 Walpole VFW 53 13 CHAR
04/17/2017 $100 PREZ DAY MAXX STAXX 94 8 CHAR
03/28/2017 $300 GTD @ Sports Legends Pub- BPO TOKENS! 125 4 RI
03/21/2017 $300 GTD @ Sports Legends Pub- BPO TOKENS! 62 14 RI
03/04/2017 $60 Cheapstack @ Norwood Elks 47 14 CHAR
03/04/2017 $150 SUPERSTACK 80% PAYOUT 10 - CHAR
02/26/2017 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 63 12 RI
02/25/2017 $150 SUPERSTACK 10 - CHAR
02/20/2017 $100 PREZ DAY MAXX STAXX 10 - CHAR
02/11/2017 $150 SUPERSTACK 10 - CHAR
02/06/2017 New Year's Day Bounty 69 9 CHAR
02/05/2017 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 140 1 RI
01/31/2017 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
01/16/2017 $100 PREZ DAY MAXX STAXX 10 - CHAR
01/14/2017 $10,000 Guaranteed Payout! 50K Finals Seat Added 88 8 CHAR
12/26/2016 $100 PREZ DAY MAXX STAXX 74 12 CHAR
12/14/2016 Walpole VFW 139 1 CHAR
12/06/2016 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
11/30/2016 Walpole VFW 107 4 CHAR
11/28/2016 New Year's Day Bounty 118 3 CHAR
11/26/2016 $150 SUPERSTACK- 80% PAYOUT! 146 1 CHAR
11/20/2016 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 53 14 RI
11/14/2016 Bar Poker Open $120 FINALE-5 PKGS GTD + WSOP Moneymaker Seat!! 10 - CHAR
11/06/2016 $30K CHAMPIONSHIP (FINALS) 10 - CHAM
10/30/2016 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 98 7 RI
10/23/2016 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 10 - RI
10/17/2016 New Year's Day Bounty 10 - CHAR
10/10/2016 $180 - Veteran's Deepstack 146 1 CHAR
10/09/2016 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 10 - RI
10/02/2016 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 10 - RI
09/29/2016 The Islander- $800 Guaranteed Payout! 125 4 RI
09/24/2016 $10,000 Guaranteed Payout! 50K Finals Seat Added 10 - CHAR
09/20/2016 $300 GTD @ Sports Legends Pub- BPO TOKENS! 136 3 RI
09/19/2016 New Year's Day Bounty 91 7 CHAR
09/16/2016 Friday Night 80/80/40 130 1 CHAR
09/12/2016 New Year's Day Bounty 10 - CHAR
09/05/2016 $180 - Veteran's Deepstack 10 - CHAR
08/21/2016 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 10 - RI
08/15/2016 New Year's Day Bounty 10 - CHAR
08/08/2016 New Year's Day Bounty 10 - CHAR
07/25/2016 New Year's Day Bounty 10 - CHAR
07/11/2016 New Year's Day Bounty 10 - CHAR
06/26/2016 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 148 1 RI
06/18/2016 $150 SUPERSTACK 106 4 CHAR
06/13/2016 New Year's Day Bounty 135 1 CHAR
06/11/2016 $10,000 Guaranteed Payout! 50K Finals Seat Added 149 1 CHAR
05/30/2016 BPO AC Travel Satellite 10 - CHAR
05/23/2016 New Year's Day Bounty 10 - CHAR
05/09/2016 New Year's Day Bounty 124 2 CHAR
05/01/2016 $30K CHAMPIONSHIP (FINALS) 10 - CHAM
04/03/2016 *10/18* 40K SUPERSTACKED & $500 GTD | THE RALLY + BPO TOKENS 10 - RI
03/29/2016 $300 GTD @ Sports Legends Pub- BPO TOKENS! 102 8 RI
03/28/2016 New Year's Day Bounty 10 - CHAR
03/22/2016 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
03/21/2016 New Year's Day Bounty 71 10 CHAR
03/18/2016 Friday $3,000 Guarantee 10 - CHAR
03/11/2016 Friday $3,000 Guarantee 10 - CHAR
03/07/2016 New Year's Day Bounty 124 3 CHAR
02/27/2016 $10,000 Guaranteed Payout! 50K Finals Seat Added 70 11 CHAR
02/20/2016 $10,000 Guaranteed Payout! 50K Finals Seat Added 10 - CHAR
02/19/2016 Friday $3,000 Guarantee 92 8 CHAR
02/13/2016 Italian American Club (Walpole) 10 - CHAR
02/13/2016 $10,000 Guaranteed Payout! 50K Finals Seat Added 10 - CHAR
02/12/2016 Friday $3,000 Guarantee 10 - CHAR
02/06/2016 No event this week 69 11 CHAR
01/01/2016 BPO AC Travel Satellite 10 - CHAR
11/28/2015 $60 Cheapstack @ Norwood Elks 10 - CHAR
11/28/2015 $150 SUPERSTACK 80% PAYOUT 10 - CHAR
11/20/2015 Friday $3,000 Guarantee 10 - CHAR
11/14/2015 $150 SUPERSTACK 80% PAYOUT 125 3 CHAR
11/10/2015 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
10/30/2015 Friday $3,000 Guarantee 149 1 CHAR
10/16/2015 Friday $3,000 Guarantee 10 - CHAR
10/09/2015 Friday $3,000 Guarantee 10 - CHAR
10/02/2015 Friday $3,000 Guarantee 63 12 CHAR
09/18/2015 Friday $3,000 Guarantee 10 - CHAR
09/11/2015 Friday $3,000 Guarantee 10 - CHAR
09/04/2015 Friday $3,000 Guarantee 10 - CHAR
08/28/2015 Friday $3,000 Guarantee 10 - CHAR
08/24/2015 New Year's Day Bounty 10 - CHAR
05/16/2015 New Year's Day $10,000 GTD SUPERSTACK 128 6 CHAR
04/28/2015 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
03/21/2015 $10,000 Guaranteed Payout! 50K Finals Seat Added 10 - CHAR
03/12/2015 The Islander- $800 Guaranteed Payout! 10 - RI
02/21/2015 $10,000 Guaranteed Payout! 50K Finals Seat Added 10 - CHAR
09/23/2014 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
08/16/2014 TEAM POKER CHALLENGE 8 - $20,000 GUARANTEED! 10 - CHAR
05/26/2014 Bar Poker Open $120 FINALE-5 PKGS GTD + WSOP Moneymaker Seat!! 10 - CHAR
05/09/2014 Friday $3,000 Guarantee 10 - CHAR
04/26/2014 $60 Cheapstack @ Norwood Elks 10 - CHAR
02/19/2014 Walpole VFW 10 - CHAR
11/26/2013 $300 GTD @ Sports Legends Pub- BPO TOKENS! 83 9 RI
11/15/2013 Friday Nights @ Red's Kitchen-- $600 GTD PAYOUT + BPO TOKENS 10 - RI
11/12/2013 $300 GTD @ Sports Legends Pub- BPO TOKENS! 115 5 RI
11/09/2013 Italian American Club (Walpole) 10 - CHAR
10/29/2013 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
10/28/2013 THE RALLY | $300 GTD | BPO TOKENS 119 2 RI
10/22/2013 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
10/21/2013 THE RALLY | $300 GTD | BPO TOKENS 10 - RI
10/13/2013 $30K CHAMPIONSHIP (FINALS) 229 4 CHAM
10/11/2013 TEAM POKER CHAMPIONSHIP 11 - $15,000 GTD! 10 - CHAM
10/08/2013 $300 GTD @ Sports Legends Pub- BPO TOKENS! 59 14 RI
09/30/2013 THE RALLY | $300 GTD | BPO TOKENS 10 - RI
09/27/2013 Friday $3,000 Guarantee 87 8 CHAR
09/17/2013 $300 GTD @ Sports Legends Pub- BPO TOKENS! 10 - RI
09/14/2013 $30 GAPC -- Travel Satellite 151 2 CHAR
09/14/2013 TEAM POKER CHALLENGE 8 - $20,000 GUARANTEED! 10 - CHAR
09/13/2013 Friday $3,000 Guarantee 10 - CHAR
07/12/2013 Friday $3,000 Guarantee 151 1 CHAR
06/07/2013 2nd Anniversary Extravaganza - $1,200 in prizes GTD 10 - S.CST
05/11/2013 Italian American Club (Walpole) 10 - CHAR
03/16/2013 $60 CHEAPSTACK! 10 - CHAR
01/16/2013 Walpole VFW 10 - CHAR
09/30/2012 Seabrook Sundays 10 - SBRK
09/03/2012 Seabrook Mondays 10 - SBRK
09/01/2012 Seabrook Saturdays 10 - SBRK
07/04/2012 Seabrook Wednesdays 10 - SBRK
04/14/2012 Rockingham Saturdays 10 - ROCK