0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0104 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-11-23' 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.0005 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.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.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0039 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.0004 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.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` = 'page'

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

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

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

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

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

0.0003 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

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

Wednesday 4th - Sunday 15th December, 2024

EPT Prague

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

Thrilling live poker in the City of a Hundred Spires. End 2024 in style at EPT Prague.

The magic of Prague awaits. One of Europe’s oldest and most enchanting cities, Prague’s history, architecture and culture make it a truly beautiful place to visit, and the perfect place for the final European Poker Tour (EPT) stop of the year.

Eureka:

Eureka Main Event: December 4-9 - €1,100

Eureka Cup: December 7-8 - €550

Eureka High Roller: December 8-9 - €2,200

EPT:

EPT Main Event: December 9-15 - €5,300

EPT Mystery Bounty: December 11-13 - €3,000

EPT High Roller: December 13-15 - €10,30

#FinalTableFreeroll Eligible Event - Click Here for Details on How You Can Win Back 100% of Your Tournament Travel Costs

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 12th - Sunday 23rd February, 2025

EPT Paris

Palais des Congrès de Paris, 2 place de la Porte Maillot, 75017 Paris, France

It’s the time of year when more than romance is in the air in Paris. Yes, the European Poker Tour is set to take over this historic city for another round of epic live poker.

After the monumental success of the last two years, we know EPT Paris needs to be bigger and better to make it befitting of a stop of its stature in the heart of the French capital. That’s why you can expect massive, guaranteed prize pools in a range of events, from the EPT High Roller to the Main Event itself. Not only that, but don’t forget you can make it all the way to Le Palais des Congrès via Power Path, too.

Speaking of Le Palais des Congrès, we’re glad to confirm EPT Paris will return to the mesmerizing venue that elevated the event to new heights in 2023. So, expect 135 tournament tables in a spacious environment that contribute to an eclectic schedule with something for everyone.

EPT Main Event: February 17-23 - €5,300

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 30th April - Saturday 10th May, 2025

EPT Monte-Carlo

Sporting Monte-Carlo, 26 Avenue Princess Grace Monte Carlo 98000 Monaco

Is there a better combination than Monte-Carlo and the European Poker Tour?

After all, this year will be the 20th year since EPT Monte-Carlo first headed to the legendary Principality on the shores of the Mediterranean Sea. Two decades later and Monaco is now a mainstay of live poker for the best players in the world. And that’s not just because of the luxurious surroundings.

Nope, there’s more to it than that. There’s arguably the most beautiful poker room in the world – the Salle des Etoiles. There’s the pantheon of greats that can call themselves Main Event champions. And there’s the prize pools that can change a player’s life in an instant.

When you put it like that, there’s no reason you shouldn’t take your seat at the table.

EPT Main Event: May 4-10 - €5,300

    Find Hotels, Flights & More       Full Schedule Coming Soon  

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