(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 id, name, state FROM tournament t WHERE active = 1 AND t.name NOT LIKE '%charity%' ORDER BY name ASC
(mysqli): SELECT l.id, l.name, l.city, l.state, l.day, ( SELECT se.time FROM event se WHERE se.location_id = l.id AND se.active = 1 AND se.tournament_id = 11 AND se.date >= 1775779200 AND se.date <= 1806451200 ORDER BY se.date ASC, se.id ASC LIMIT 1 ) as time, l.default_time, COUNT(e.id) as event_count FROM location l INNER JOIN event e ON e.location_id = l.id WHERE e.active = 1 AND e.tournament_id = 11 AND e.date >= 1775779200 AND e.date <= 1806451200 AND l.active = 1 GROUP BY l.id, l.name, l.city, l.state, l.day, l.default_time ORDER BY l.day, l.default_time, l.name ASC
(mysqli): SELECT l.id, l.name, l.city, l.state, l.day, ( SELECT se.time FROM event se WHERE se.location_id = l.id AND se.active = 1 AND se.tournament_id = 14 AND se.date >= 1775779200 AND se.date <= 1806451200 ORDER BY se.date ASC, se.id ASC LIMIT 1 ) as time, l.default_time, COUNT(e.id) as event_count FROM location l INNER JOIN event e ON e.location_id = l.id WHERE e.active = 1 AND e.tournament_id = 14 AND e.date >= 1775779200 AND e.date <= 1806451200 AND l.active = 1 GROUP BY l.id, l.name, l.city, l.state, l.day, l.default_time ORDER BY l.day, l.default_time, l.name ASC
(mysqli): SELECT l.id, l.name, l.city, l.state, l.day, ( SELECT se.time FROM event se WHERE se.location_id = l.id AND se.active = 1 AND ( se.tournament_id = 6 OR ( se.tournament_id = 24 AND se.location_id IN (418, 619) ) ) AND se.date >= 1775779200 AND se.date <= 1806451200 ORDER BY se.date ASC, se.id ASC LIMIT 1 ) as time, l.default_time, COUNT(e.id) as event_count FROM location l INNER JOIN event e ON e.location_id = l.id WHERE e.active = 1 AND ( e.tournament_id = 6 OR ( e.tournament_id = 24 AND e.location_id IN (418, 619) ) ) AND e.date >= 1775779200 AND e.date <= 1806451200 AND l.active = 1 GROUP BY l.id, l.name, l.city, l.state, l.day, l.default_time ORDER BY l.day, l.default_time, l.name ASC
(mysqli): SELECT l.id, l.name, l.city, l.state, l.day, ( SELECT se.time FROM event se WHERE se.location_id = l.id AND se.active = 1 AND se.tournament_id = 24 AND se.date >= 1775779200 AND se.date <= 1806451200 ORDER BY se.date ASC, se.id ASC LIMIT 1 ) as time, l.default_time, COUNT(e.id) as event_count FROM location l INNER JOIN event e ON e.location_id = l.id WHERE e.active = 1 AND e.tournament_id = 24 AND e.date >= 1775779200 AND e.date <= 1806451200 AND l.active = 1 GROUP BY l.id, l.name, l.city, l.state, l.day, l.default_time ORDER BY l.day, l.default_time, l.name ASC
(mysqli): SELECT l.id, l.name, l.city, l.state, l.day, ( SELECT se.time FROM event se WHERE se.location_id = l.id AND se.active = 1 AND se.tournament_id = 27 AND se.date >= 1775779200 AND se.date <= 1806451200 ORDER BY se.date ASC, se.id ASC LIMIT 1 ) as time, l.default_time, COUNT(e.id) as event_count FROM location l INNER JOIN event e ON e.location_id = l.id WHERE e.active = 1 AND e.tournament_id = 27 AND e.date >= 1775779200 AND e.date <= 1806451200 AND l.active = 1 GROUP BY l.id, l.name, l.city, l.state, l.day, l.default_time ORDER BY l.day, l.default_time, l.name ASC
(mysqli): SELECT l.id, l.name, l.city, l.state, l.day, ( SELECT se.time FROM event se WHERE se.location_id = l.id AND se.active = 1 AND se.tournament_id = 1 AND se.date >= 1775779200 AND se.date <= 1806451200 ORDER BY se.date ASC, se.id ASC LIMIT 1 ) as time, l.default_time, COUNT(e.id) as event_count FROM location l INNER JOIN event e ON e.location_id = l.id WHERE e.active = 1 AND e.tournament_id = 1 AND e.date >= 1775779200 AND e.date <= 1806451200 AND l.active = 1 GROUP BY l.id, l.name, l.city, l.state, l.day, l.default_time ORDER BY l.day, l.default_time, l.name ASC
(mysqli): SELECT l.id, l.name, l.city, l.state, l.day, ( SELECT se.time FROM event se WHERE se.location_id = l.id AND se.active = 1 AND se.tournament_id = 23 AND se.date >= 1775779200 AND se.date <= 1806451200 ORDER BY se.date ASC, se.id ASC LIMIT 1 ) as time, l.default_time, COUNT(e.id) as event_count FROM location l INNER JOIN event e ON e.location_id = l.id WHERE e.active = 1 AND e.tournament_id = 23 AND e.date >= 1775779200 AND e.date <= 1806451200 AND l.active = 1 GROUP BY l.id, l.name, l.city, l.state, l.day, l.default_time ORDER BY l.day, l.default_time, l.name ASC
(mysqli): SELECT l.id, l.name, l.city, l.state, l.day, ( SELECT se.time FROM event se WHERE se.location_id = l.id AND se.active = 1 AND se.tournament_id = 2 AND se.date >= 1775779200 AND se.date <= 1806451200 ORDER BY se.date ASC, se.id ASC LIMIT 1 ) as time, l.default_time, COUNT(e.id) as event_count FROM location l INNER JOIN event e ON e.location_id = l.id WHERE e.active = 1 AND e.tournament_id = 2 AND e.date >= 1775779200 AND e.date <= 1806451200 AND l.active = 1 GROUP BY l.id, l.name, l.city, l.state, l.day, l.default_time ORDER BY l.day, l.default_time, l.name ASC
LOCATIONS
Central Mass Tour Locations
Framingham Tour Locations
Greater Lowell Tour Locations
* Registration times are listed above. First hand goes out promptly 30 minutes after registration time.
North Shore Tour Locations
Online Tour Locations
Rhode Island Tour Locations
South Coast Tour Locations
Southern Massachusetts Tour Locations
|
40K SUPERSTACKED & $500 GTD | PNC CLUB + BPO TOKENS
- Stoughton, MA
|
Every Sunday at 12:30 PM |
|
PNC Club @ SUNDAY | $300 GTD | 4:00PM FREE WEEK ADDED
- Stoughton, MA
|
Every Sunday at 4:00 PM |
|
Taunton Elks | $300 GTD + BPO TOKENS
- Taunton, MA
|
Every Monday at 6:30 PM |
|
Amvets POST 51 | TUESDAY I $300 GTD + BPO TOKENS!
- Randolph, MA
|
Every Tuesday at 6:30 PM |
|
American Civic League | WED| $300 GTD +BPO TOKENS
- Lowell, MA
|
Every Wednesday at 6:30 PM |
|
CONRAD'S ALEHOUSE | WEDNESDAY | $300 GTD +BPO TOKENS
- Foxboro, MA
|
Every Wednesday at 6:30 PM |
|
PNC CLUB | THURSDAYS | $300 GTD + BPO TOKENS
- Stoughton, MA
|
Every Thursday at 6:30 PM |
|
THE RALLY | $300 GTD | BPO TOKENS
- Warwick, RI
|
Every Thursday at 6:30 PM |
|
$400 GTD PUB EVENT | TOP 3 win BPO tokens!
- Stoughton, MA
|
Every Friday at 6:30 PM |
|
Saturday @ PNC Club 12:30-$300 GTD PAYOUT + BPO Tokens!
- Stoughton, MA
|
Every Saturday at 12:30 PM |
|
Saturday @ PNC CLUB- 4PM- $300 GTD PAYOUT
- Stoughton, MA
|
Every Saturday at 4:00 PM |
