0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0114 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-12-23' AND `url` = 'https://www.maineventtravel.com/tour/ept'

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.0037 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.0011 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.0125 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.0010 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.0007 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 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.