(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 = 19
(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 = 19 AND pts.action = 'CHECK_IN' AND date <= 1792776321 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 = 19 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM event e WHERE location_id = 19 AND date >= 1792713600 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM location_photo WHERE location_id = 19
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'location' AND _id = 19
(mysqli): SELECT id FROM location_photo WHERE location_id = 19 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM location_photo WHERE location_id = 19 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 = 19 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 = 19 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 = 19 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 = 19 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 = 19 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 = 19 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 = 19 AND action != 'CHECK_IN' GROUP BY pts.player_id
LOCATION DETAILS
Reflections Sports Bar
67 Parkhurst Rd.
Chelmsford, MA
01824
978-934-9325
Reflections Lounge is the largest sports bar in Northern Massachusetts with 22 TV's, three of them are 10ft Jumbo screens. We have 10 satellites so you can get all the sports action here. We can host up to 200 Texas Hold'em players for the Eastern Poker Tour!!!
(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
