0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0150 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-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.0038 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.0003 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.0021 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.0010 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.0006 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.0004 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%individual-tour-stop%'
English
  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 8th - Saturday 18th January, 2025

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       View Complete Schedule  
Thursday 16th - Monday 27th January, 2025

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

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

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       View Complete Schedule  
Thursday 13th - Monday 24th February, 2025

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

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

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

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

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

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

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

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

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
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.