0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0087 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-07-16' 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.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0063 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.0005 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.0011 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.0065 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.0006 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.0004 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.

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”

Upcoming Tour Stops

Wednesday 17th - Sunday 28th July, 2024

Choctaw Casino Resort

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

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

#FinalTableFreeroll Eligible Event

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    Find Hotels, Flights & More       View Complete Schedule  

Thursday 1st - Monday 12th August, 2024

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

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    Find Hotels, Flights & More       View Complete Schedule  

Thursday 15th - Monday 26th August, 2024

Graton Resort and Casino

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

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

#FinalTableFreeroll Eligible Event

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 5th - Monday 16th September, 2024

Horseshoe Council Bluffs

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

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

#FinalTableFreeroll Eligible Event

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 19th - Monday 30th September, 2024

Horseshoe Hammond

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

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

#FinalTableFreeroll Eligible Event

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 26th September - Monday 7th October, 2024

Thunder Valley Casino Resort

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

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

#FinalTableFreeroll Eligible Event

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 10th - Monday 21st October, 2024

Isle of Capri

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!

#FinalTableFreeroll Eligible Event

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 17th - Monday 28th October, 2024

Caesars Southern Indiana

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

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

#FinalTableFreeroll Eligible Event

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 24th October - Monday 4th November, 2024

Harveys Lake Tahoe

Harvey's Lake Tahoe, Highway 50 at Stateline Avenue, Lake Tahoe, NV 89449

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

#FinalTableFreeroll Eligible Event

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 30th October - Monday 11th November, 2024

Choctaw Casino Resort

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

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

#FinalTableFreeroll Eligible Event

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 7th - Monday 18th November, 2024

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!

#FinalTableFreeroll Eligible Event

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 14th - Monday 25th November, 2024

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

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 28th November - Monday 9th December, 2024

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

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    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.