(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 = 406
(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 = 406 AND pts.action = 'CHECK_IN' AND date <= 1792777191 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 = 406 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM event e WHERE location_id = 406 AND date >= 1792713600 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM location_photo WHERE location_id = 406
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'location' AND _id = 406
(mysqli): SELECT id FROM location_photo WHERE location_id = 406 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM location_photo WHERE location_id = 406 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 = 406 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 = 406 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 = 406 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 = 406 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 = 406 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 = 406 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 = 406 AND action != 'CHECK_IN' GROUP BY pts.player_id
LOCATION DETAILS
Knockout Challenge
VFW Post 486
486 Bedford St
Fall River
02721
South Coast region's EXCLUSIVE tournament for seasonal qualifiers.
Season 22 Qualifiers
Geoffrey D Alexander, Tom Amato, Bob Alves, Paulo Andrade, Matt Baier, Jorge Baptista, Fernando Batista, Katie Bobola, Erik Borges, Wally Britto, James Caisse, Dana ThelastReal Carmo, Joseph Carvalho, Nuno Carvalho, Paul J. Charette, Joseph Colton, J'Quan Colton, Alby Crepeau, Chris DaPonte, Dave Dasilva, Emily Davila, Jeff DeCosta, Ronnie DeCosta, Ashkan Delfanazari, Janice Delisle, Jeff Desousa, Jackie Faith, Mark Feghaly, Michael Friedlander, Marc Garant, Darren Hebert, Bob Higgins, Charles Holmes, Phil Imprescia, Jason Koczera, Chris Lane, Julio Lopez, Radanes Lopez, Leonard Medeiros, Dorene Menezes, Cindy Pacheco, Kerri Pankowski, Angel Pantoja, James Peters, Christopher Prien, Ray Quintin, Sherilyn Rienstra, Lisa Roberts, John Roderiques, Dave Rogers, Keith Soares, Lance Stevens Sr., Sean Sweeney, Michael Turner, Paula Vieira, Greg Winnett, Keith Wooley
$500 Winner Take All Free Roll
VFW Post 486
486 Bedford St
Fall River, MA 02721
11:00 am Registration
11:30 am First Deal
(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
