0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0134 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-07-15' AND `url` = 'https://www.maineventtravel.com/festivals/festival/25' ORDER BY `views` DESC

0.0326 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-07-15' AND `url` = 'https://www.maineventtravel.com/festivals/festival/25'

0.0005 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.0003 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0007 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0004 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.0004 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0004 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.0044 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.0047 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` = '25'

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

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

0.0128 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.0008 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'

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!


World Series of Poker 2025

Tuesday 27th May - Wednesday 16th July, 2025
3645 S Las Vegas Blvd, Las Vegas

The series will run from May 27 to July 16, with poker’s undisputed world championship, also known as the Main Event beginning on July 2. The Main Event Final Table will occur July 15-16 inside the Horseshoe Events Center.

** Please note that bookings cannot be made for more than 28 days. Please make 2 bookings if you require more than 28 days **

    Find Hotels, Flights & More       View Complete Schedule  

WSOP Paradise

Thursday 4th - Thursday 18th December, 2025
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  
Latest News & Blogs

High Stakes and Summer Vibes: Irish Poker Tour Hits Dublin

The Irish Poker Tour returns to Dublin from July 23rd to 27th, bringing top-tier poker action, diverse tournaments, and a vibrant atmosphere to the city. With MainEventTravel simplifying trip bookings, players can focus on the game while enjoying everything Dublin has to offer this summer.

Barcelona Awaits: The European Poker Tour’s Hottest Summer Stop

EPT Barcelona returns this August with world-class poker, a €5,300 Main Event, and a packed festival schedule at Casino Barcelona. With sun, action, and seamless hotel options from Main Event Travel, it’s set to be the summer’s hottest poker destination.
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.