0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0110 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-07-08'
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.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.0038 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.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
  1. Home
  2. Festivals
  3. WSOP

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

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.
UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
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.