0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

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.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 * 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.0041 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.0003 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.0002 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.0012 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.0075 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'

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  
Latest News & Blogs

One Month To Go WSOP – Book Now to Secure the Action!

The countdown is well and truly on! In just one month, the 2025 World Series of Poker returns to Las Vegas for another unforgettable summer of high-stakes drama, life-changing prize pools, and the electric atmosphere that only the WSOP can deliver. Whether you’re chasing a coveted gold bracelet, grinding the daily events, or planning your very first trip to the poker capital of the world, now is the time to lock in your travel plans – and there’s no better way to do it than with Main Event Travel.

May Getaways: Poker Takes Centre Stage in Monte Carlo and Barcelona

Spring sunshine, iconic cities, and world-class poker — it’s time to plan your next escape
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.