(mysqli): SELECT id, name, city FROM location WHERE active = 1 ORDER BY name ASC
(mysqli): SELECT id, name, state FROM tournament WHERE 1 ORDER BY name ASC
(mysqli): SELECT * FROM location WHERE id = 131
(mysqli): SELECT COUNT(pts.player_id) as num_players FROM event e INNER JOIN player_pts pts ON pts.event_id = e.id WHERE e.location_id = 131 AND pts.action = 'CHECK_IN' AND date <= 1792785585 AND active = 1 GROUP BY pts.event_id ORDER BY e.date ASC
(mysqli): SELECT SUM(money_collected) as money_collected_sum FROM event e WHERE location_id = 131 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM event e WHERE location_id = 131 AND date >= 1792713600 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM location_photo WHERE location_id = 131
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'location' AND _id = 131
(mysqli): SELECT id FROM location_photo WHERE location_id = 131 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM location_photo WHERE location_id = 131 AND dflt = 1 LIMIT 1
(mysqli): SELECT p.id as trash, SUM(pts.points) as pts, pts.player_id, CONCAT(p.last,', ',p.first) as name FROM event e INNER JOIN player_pts pts ON pts.event_id = e.id INNER JOIN player p ON p.id = pts.player_id WHERE e.location_id = 131 GROUP BY pts.player_id ORDER BY pts DESC LIMIT 200
(mysqli): SELECT ppts.player_id AS id, SUM(ppts.points) as pts FROM participation_points ppts INNER JOIN event e ON e.id = ppts.event_id WHERE e.location_id = 131 GROUP BY ppts.player_id
(mysqli): SELECT bpts.player_id AS id, SUM(bpts.points) as pts FROM bounty_points bpts INNER JOIN event e ON e.id = bpts.event_id WHERE e.location_id = 131 GROUP BY bpts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(pts.event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 131 GROUP BY pts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 131 AND action = 1 GROUP BY pts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 131 AND (action = 1 OR action = 2 OR action = 3) GROUP BY pts.player_id
(mysqli): SELECT pts.player_id, COUNT(DISTINCT(event_id)) as cnt FROM player_pts pts INNER JOIN event e ON e.id = pts.event_id WHERE e.location_id = 131 AND action != 'CHECK_IN' GROUP BY pts.player_id
LOCATION DETAILS
Benefit Tournament- In Loving Memory of Radames Lopez
28 Rossevelt Street
VFW Tuttle Post
Acushnet, MA
3:00 PM START TIME
$40 Donation
40,000 Chips
$40 Rebuys
With the help of the VFW Tuttle Post, Jeff Maynard, Rita Estavao and a few others, we have been working to get this event on the calendar to help the Lopez Family. Radames was a huge part of the Eastern Poker Tour family. A regular player in the south coast region, and known by many in all the regions, as he was quite the character! Radames was a loyal, long time player of Eastern Poker Tour, and a great supporter. Many of our players have been asking how they can help. We have sent out the GO FUND ME, and we hope this will be an extra way to help the family by memorializing Radames and his loving wife, Eneida.
100% of gross proceeds will be donated to the Lopez Family in memory of Radames and his loving wife, Enieda. Eastern Poker Tour is donating the $1000 Payout, and all gross proceeds will be donated to the Lopez family.
Donations, raffles, photos, stories are all accepted and encouraged. We truly want this day to be about Radames. Please bring your memories with you and play in his honor. He was a great part of our community.
Please feel free to write a note, bring a card, or photo that we can pass along to Radames family.
(mysqli): SELECT id, name, city FROM location WHERE active = 1 ORDER BY name ASC
(mysqli): SELECT id, name, state FROM tournament WHERE 1 ORDER BY name ASC
