0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0064 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-23'
AND `url` = 'https://www.maineventtravel.com/tour/wsop-circuit-events'
ORDER BY `views` DESC

0.0092 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-23'
AND `url` = 'https://www.maineventtravel.com/tour/wsop-circuit-events'

0.0004 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0004 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0040 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

0.0004 SECONDS: 
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = 'wsop-circuit-events'

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `page_url` = 'wsop-circuit-events'

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '35'

0.0013 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '35'
ORDER BY `tour_stops`.`start_date` ASC

0.0074 SECONDS: 
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name`
FROM `news_articles`
LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id`
WHERE `news_articles`.`active` = '1'
ORDER BY `news_articles`.`date` DESC

0.0007 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0005 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0003 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%individual-tour-stop%'

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(3)
  • 888poker UK Poker League(0)
  • APAT(2)
  • APPT(1)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(0)
  • Aspers Casino Westfield Stratford City(3)
  • Battle Of Malta(0)
  • Borgata Poker(0)
  • Bratislava Poker Festival(0)
  • British Poker Series(5)
  • BSOP(1)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(3)
  • EPT(4)
  • Estrellas Poker Tour(0)
  • Eureka Poker Tour(1)
  • France Poker Series(0)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(5)
  • Grosvenor UK Poker Open(1)
  • Grosvenor's National Poker League(1)
  • GUKPT Grosvenor(10)
  • Hippodrome Casino(1)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(1)
  • Irish Poker Tour(8)
  • Kings of Tallinn(0)
  • Kings of Vilnius(1)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(13)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(1)
  • The Caribbean Poker Series(0)
  • The Festival(1)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • UKIPT(0)
  • Unibet DeepStack Open(3)
  • Venetian Deepstack Extravaganza(3)
  • Women's Winter Festival(1)
  • WPT(4)
  • WPT Prime(2)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(16)
  • WSOP International Circuit(4)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(0)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

1. Home
2. Events
3. WSOP Circuit Events

WSOP Circuit Events

The World Series of Poker (WSOP) Circuit Events are a series of poker tournaments hosted throughout the United States beginning in late July/early August each year and culminating the following May with a $1,000,000 National Championship televised on ESPN where the victor earns a WSOP gold bracelet as well.

WSOP Circuit Events are designed to give the recreational and amateur player an opportunity to participate in the WSOP experience at a more affordable price point and with less of a time commitment than the traditional WSOP in Las Vegas.

Upcoming Tour Stops

Wednesday 13th - Tuesday 26th November, 2024 Add

Commerce Casino

Commerce Casino, 6121 Telegraph Rd, Commerce, CA 90040, United States

WSOP has announced the return of its 20th season of the WSOPC!

#FinalTableFreeroll Eligible Event

    Find Hotels, Flights & More       View Complete Schedule  

---

Thursday 21st November - Tuesday 3rd December, 2024 Add

WSOP Las Vegas

Horseshoe & Paris, Las Vegas Boulevard, Las Vegas, 3645 S Las Vegas Blvd, Las Vegas

WSOP has announced the return of its 20th season of the WSOPC!

#FinalTableFreeroll Eligible Event

    Find Hotels, Flights & More       View Complete Schedule  

---

Thursday 28th November - Monday 9th December, 2024 Add

Harrah's Cherokee

Harrahs Cherokee Casino Resort, 777 Casino Drive Cherokee, NC 28719

WSOP has announced the return of its 20th season of the WSOPC!

#FinalTableFreeroll Eligible Event

    Find Hotels, Flights & More       View Complete Schedule  

---

Wednesday 8th - Saturday 18th January, 2025 Add

Choctaw Durant

Choctaw Resort Casino, 4216 S. Hwy 69/75, Durant , OK 74701 USA

WSOP has announced the return of its 20th season of the WSOPC!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

---

Thursday 16th - Monday 27th January, 2025 Add

Thunder Valley Casino

Thunder Valley Casino Resort, 1200 Athens Ave Lincoln, CA 95648

WSOP has announced the return of its 20th season of the WSOPC!

    Find Hotels, Flights & More       View Complete Schedule  

---

Thursday 23rd January - Monday 3rd February, 2025 Add

Horseshoe Tunica (Mississippi)

Horseshoe Casino Tunica, 1021 Casino Center Drive Robinsonville, MS US

WSOP has announced the return of its 20th season of the WSOPC!

#FinalTableFreeroll Eligible Event

    Find Hotels, Flights & More       View Complete Schedule  

---

Thursday 30th January - Monday 10th February, 2025 Add

Harrah's Pompano Beach

Isle Casino Pompano Park, 777 Isle of Capri Circle, Pompano Beach, FL, 33069

WSOP has announced the return of its 20th season of the WSOPC!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

---

Thursday 13th - Monday 24th February, 2025 Add

Harrah's Cherokee

Harrahs Cherokee Casino Resort, 777 Casino Drive Cherokee, NC 28719

WSOP has announced the return of its 20th season of the WSOPC!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

---

Thursday 20th February - Monday 3rd March, 2025 Add

Horseshoe Baltimore

Horseshoe Baltimore, 1525 Russell St, Baltimore, MD 21230

WSOP has announced the return of its 20th season of the WSOPC!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

---

Thursday 27th February - Monday 10th March, 2025 Add

Horseshoe Hammond

Horseshoe Hammond, 777 Casino Center Dr, Hammond, IN 46320

WSOP has announced the return of its 20th season of the WSOPC!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

---

Wednesday 5th - Monday 17th March, 2025 Add

Hard Rock Tulsa

Hard Rock Tulsa, 777 West Cherokee Street Catoosa, OK 74015

WSOP has announced the return of its 20th season of the WSOPC!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

---

Thursday 13th - Monday 24th March, 2025 Add

Turning Stone Resort Casino

Turning Stone Resort Casino, 5218 Patrick Rd. Verona, NY US

WSOP has announced the return of its 20th season of the WSOPC!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

---

Thursday 20th - Monday 31st March, 2025 Add

Horseshoe Las Vegas

Horseshoe & Paris, Las Vegas Boulevard, Las Vegas, 3645 S Las Vegas Blvd, Las Vegas

WSOP has announced the return of its 20th season of the WSOPC!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

---

Thursday 3rd - Monday 14th April, 2025 Add

Grand Victoria Casino

Grand Victoria Casino, 250 S Grove Ave, Elgin, IL 60120, United States

WSOP has announced the return of its 20th season of the WSOPC!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

---

Thursday 17th - Monday 28th April, 2025 Add

Horseshoe Tunica

Horseshoe Casino Tunica, 1021 Casino Center Drive Robinsonville, MS US

WSOP has announced the return of its 20th season of the WSOPC!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

---

Thursday 1st - Monday 12th May, 2025 Add

Harrah's Cherokee

Harrahs Cherokee Casino Resort, 777 Casino Drive Cherokee, NC 28719

WSOP has announced the return of its 20th season of the WSOPC!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter