0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0085 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-07-21' AND `url` = 'https://www.maineventtravel.com/tour/wsop-circuit-events' ORDER BY `views` DESC

0.0221 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-07-21' 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.0005 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.0042 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.0003 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.0077 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.0004 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

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 16th - Sunday 27th July, 2025

Choctaw Durant

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

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 7th - Monday 18th August, 2025

Harrah's Cherokee (North Carolina)

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

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 14th - Monday 25th August, 2025

Harrah's Atlantic City

Harrahs Atlantic City, 777 Harrah's Blvd, Atlantic City, NJ 08401

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 14th - Monday 25th August, 2025

Graton Casino (Bay Area)

Graton Resort and Casino, 288 Golf Course Dr W, Rohnert Park, CA 94928, United States

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 21st August - Monday 1st September, 2025

Caesar's New Orleans

Caesars New Orleans, 228 Poydras St, New Orleans, LA 70130, United States

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 4th - Monday 15th September, 2025

Horseshoe Council Bluffs (Omaha/Iowa)

Horseshoe Council Bluffs, 2701 23rd Ave, Council Bluffs, IA 51501

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 11th - Monday 22nd September, 2025

Horseshoe Hammond

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

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 18th - Monday 29th September, 2025

Caesar's Southern Indiana

Caesars Southern Indiana, 11999 Casino Center Drive, Elizabeth, IN 47117

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 25th September - Monday 6th October, 2025

Thunder Valley Casino

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

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 2nd - Monday 13th October, 2025

Horseshoe Baltimore

Horseshoe Baltimore, 1525 Russell St, Baltimore, MD 21230

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 9th - Monday 20th October, 2025

Harrah's Pompano Beach

Harrah's Pompano Beach, 1800 SW 3rd St.

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 23rd October - Monday 3rd November, 2025

Caesars Republic Lake Tahoe

Caesars Republic Lake Tahoe, Highway 50 at Stateline Avenue, Lake Tahoe, NV 89449

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 29th October - Sunday 9th November, 2025

Choctaw Durant

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

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 6th - Monday 17th November, 2025

Grand Victoria Casino

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

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 12th - Tuesday 25th November, 2025

Commerce Casino

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

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 21st November - Wednesday 3rd December, 2025

Horseshoe Las Vegas

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

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 27th November - Monday 8th December, 2025

Harrah's Cherokee (North Carolina)

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

WSOP has announced dates for its US Circuit.

    Find Hotels, Flights & More       Full Schedule Coming Soon  
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.