0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0096 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-03-29' AND `url` = 'https://www.maineventtravel.com/tour/wsop-circuit-events'

0.0003 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.0039 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.0013 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.0015 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.0101 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%'

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

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       View Complete Schedule  

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       View Complete Schedule  

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  

Thursday 8th - Monday 19th May, 2025

Caesars Southern Indiana

Caesars Southern Indiana, 11999 Casino Center Drive, Elizabeth, IN 47117
    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.