0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0066 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-08-01' AND `url` = 'https://www.maineventtravel.com/tour/wsop' ORDER BY `views` DESC

0.0170 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-08-01' AND `url` = 'https://www.maineventtravel.com/tour/wsop'

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.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.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0037 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'

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

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

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` = '25' ORDER BY `tour_stops`.`start_date` ASC

0.0115 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.0116 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.0002 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

WSOP


The World Series of Poker® is the largest, longest, and most prestigious gaming event in the world, dating back to 1970. 

In 2019, the event attracted 187,298 entrants from 118 different countries awarding more than $293 million in prize money. 2020 WSOP was moved online due to Covid. In 2021, numbers were still affected with 42,241 entries.

However, the 2022 WSOP drew an astonishing 182,662 entrants with the Main Event pulling in 8,663 entrants for a total prize pool of $80,782,475.

The 2025 WSOP is expected to be bigger than ever!

Upcoming Tour Stops

Thursday 4th - Thursday 18th December, 2025

WSOP Paradise

Atlantis Casino, Atlantis Resort & Casino, Paradise Island, Bahamas

The World Series of Poker revealed electrifying details of its highly anticipated WSOP Paradise winter tournament series, headlined by the $60,000,000-guaranteed Super Main Event - the largest prize guarantee in live poker tournament history. This monumental series is set to transform Atlantis Paradise Island in the Bahamas into poker’s ultimate winter playground hosted in exclusive partnership with GGPoker, the World’s Biggest Poker Room, and Triton, the leading high-stakes tournament organiser. 

This third annual iteration of the WSOP Paradise festival will again showcase an unparalleled set of high roller and super high roller events. The tournament schedule will be jointly curated and hosted by WSOP and Triton Poker, ensuring a world-class experience for all players. 

Other festival highlights include:

  • Event #1: WSOP Circuit Championship Mystery Bounty (Dec. 4) - $2,500 buy-in (all WSOP Circuit ring event winners from July 1 through Dec 2. will receive an exclusive $5K Ticket to Paradise package that includes entry to Event #1)

  • Event #3: Triton Pot Limit Omaha Main Event (Dec. 5) - $100K buy-in

  • Event #5: Triton Invitational (Dec. 7) - $250K buy-in (the field will be evenly split between invited players from the worlds of business and entertainment, and their professional poker player guests)

  • Event #9: Triton No Limit Hold’em Main Event (Dec. 9) - $100K buy-in 

  • Event #14: GGMillion$ (Dec. 15) - $25K buy-in - $10M prize guarantee

    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.