(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 = 64
(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 = 64 AND pts.action = 'CHECK_IN' AND date <= 1792776311 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 = 64 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM event e WHERE location_id = 64 AND date >= 1792713600 AND active = 1
(mysqli): SELECT COUNT(id) as cnt FROM location_photo WHERE location_id = 64
(mysqli): SELECT COUNT(id) as cnt FROM comment WHERE type = 'location' AND _id = 64
(mysqli): SELECT id FROM location_photo WHERE location_id = 64 AND dflt = 1
(mysqli): SELECT photo_name, thumb_name FROM location_photo WHERE location_id = 64 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 = 64 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 = 64 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 = 64 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 = 64 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 = 64 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 = 64 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 = 64 AND action != 'CHECK_IN' GROUP BY pts.player_id
LOCATION DETAILS
Cafe Romanzo
495 Washington St
Coventry, RI
02816
(401) 821-8720
Cafè Romanzo has always been known for its excellent food. With it's new upstairs lounge addition capable of holding 100+ people they are more then happy to include EPT to their line-up every week. Expect a great atmosphere, wonderful food, and a great tournament every tuesday night!
--> review by tasteri.com "Cafe Romanzo, a cozy, mom-and-pop type nook, is the quintessential Rhode Island restaurant. The menu is heavy with Italian influence, but with lots of creative flourishes, especially in the daily specials and appetizers.Most everything at Cafe Romanzo is above par, and the desserts are no exception."
(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
