0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0262 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-04-03' 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.0005 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.0003 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.0003 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0072 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.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.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.0070 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.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

Starts This Week! Last-Minute Rooms for the Irish Open

The highly anticipated Irish Open kicks off this week, and if you haven’t sorted your accommodation yet, don’t worry—there are still last-minute rooms available!

Top Hotels for the WSOP 2025: 2 Months to Go – Have You Booked Yet? Lock in the Best Rates Today!

The World Series of Poker (WSOP) is just two months away, and if you haven’t already secured your accommodation, now is the time to act! The WSOP is one of the most prestigious poker events in the world, drawing thousands of players and fans to Las Vegas for weeks of thrilling action.
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.