0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0079 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-05-29'
AND `url` = 'https://www.maineventtravel.com/tour/ept'
ORDER BY `views` DESC

0.0122 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-05-29'
AND `url` = 'https://www.maineventtravel.com/tour/ept'

0.0004 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.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.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` = 'ept'

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

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

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

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

0.0003 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%individual-tour-stop%'
English
  1. Home
  2. Events
  3. EPT

EPT


The European Poker Tour (EPT) is returning to some of poker's most glamorous locations in 2024.

Thanks to their sponsor, PokerStars, the renewed commitment to promoting poker around the world, players of all levels can once again enjoy the EPT in all its glory.

 

Upcoming Tour Stops

Monday 18th - Sunday 31st August, 2025

EPT Barcelona

Casino de Barcelona, Calle Marina, 19-21, 08005 Barcelona, Spain

Stunning beaches. Vibrant nightlife. World-class cuisine. Legendary poker. Barcelona has been the perfect location for the European Poker Tour for over 20 years.

There’s a reason EPT Barcelona is the players’ favorite stop on the calendar. What can you expect from the 2025 edition in one of the most amazing cities in the world? It goes without saying the live action will be off the charts, from nail-biting showdowns between the world’s greatest players to unpredictable draws on the river.

Of course, EPT Barcelona is about more than poker. The stunning Catalonian capital opens up a world of possibilities when it comes to off-the-felt activities, so whether you’re on or off the table, you’ll never be bored.

Join us at the luxurious Casino Barcelona for the most unmissable EPT stop of the year. Will we see you there?

EPT Main Event: August 24-31 - €5,300
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Wednesday 1st - Sunday 12th October, 2025

EPT Malta

The Intercontinental Hotel, St. George's Bay St. Julian's, STJ 3310, Malta

Malta is quickly becoming a hotspot for the best poker players in the world, so it’s only right one of the biggest tours on the continent makes its return to this incredible island.

After nine years, the European Poker Tour (EPT) Malta is finally back where it belongs – among the vibrant culture and historic backdrop that only this Mediterranean destination can provide. Of course, that means you can mark your calendar for thrilling on-the-felt action that’s littered with the great and the good of the world’s poker community. After all, Malta is a must-visit stop for everyone from professionals to newcomers.

But it also means you should gear up for activities beyond the table, from the notorious nightlife, the unique beaches and the UNESCO World Heritage sites. No two days and nights are the same in Malta. Plus, add in the luxurious venue and its state-of-the-art facilities and you’ve got a premier event on the calendar that poker enthusiasts won’t want to miss. 

PokerStars Open

PokerStars Open Main Event: October 1-6

EPT

EPT Main Event: October 6-12
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Wednesday 3rd - Sunday 14th December, 2025

EPT Prague

Hilton Prague, Pobrežní 1, 186 00 Praha 8, Czech Republic

The charming European Poker Tour (EPT) Prague is back for another edition of brilliant action in Bohemia’s enchanting capital city.

Live EPT poker has been coming to the City of a Hundred Spires for almost two decades, and it’s not hard to see why when you land in this magical destination. It’s a winter wonderland that never fails to impress against the backdrop of the historic Gothic architecture, cobbled streets and vibrant arts scene. Don’t forget the local Czech cuisine, too.

The magic is in more than the surroundings of the Bohemian region, though. Prague has been well established on the poker map for years, making it the favorite winter stop for the top players from around the world. The prestige of EPT Prague attracts only the best and it shows on the tables because the action is always unmissable.

EPT Prague is calling – will you pick up?

PokerStars Open

PokerStars Open Main Event: December 3-8

EPT

EPT Main Event: December 8-14
    Find Hotels, Flights & More       Full Schedule Coming Soon  
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.