0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0081 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-05-19' 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.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.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.0064 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.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.0066 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

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 26th August - Sunday 8th September, 2024

EPT Barcelona

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

Stunning beaches. Vibrant nightlife. World-class cuisine. Barcelona has it all – making it a perfect stop to return to for the European Poker Tour (EPT) 2024.

Featuring world-class poker action and some of the best off-the-felt activities around, it’s sure to be an unmissable player experience from the first hand to the last.  

ESPT:

ESPT Main Event: August 26- September 1- €1,100

ESPT Cup: Dates TBC - €550

ESPT High Roller: Dates TBC - €2,200

EPT:

EPT Super High Roller: Dates TBC - €100,000

EPT Main Event: September 1-8 - €5,300

EPT Mystery Bounty: Dates TBC - €3,000

EPT High Roller: Dates TBC - €10,300

Win Back Up to 100% of Your Tournament Travel Costs - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 9th - Sunday 20th October, 2024

EPT Cyprus

Merit Royal Diamond, Mersin, Alsancak Mevkii Girne KKTC, 99350

Are you ready for more world class poker?

The European Poker Tour (EPT) is coming back to Cyprus after the massive success of the inaugural event in 2023, with everything from huge hands, late-night Main Event controversy and an eclectic pool of winners.

The 2024 version is set to be no different. Hosted at the mesmerising five-star Merit Royal Diamond Hotel Casino & Spa, it’s the place to be if you’re looking for the thrill of live poker on the shores of the Mediterranean.

It’s time to experience the red-hot action of EPT Cyprus.

Key EPT and Eureka tournament dates.

Eureka:

Eureka Main Event: Dates TBC - $1,100

Eureka Cup: Dates TBC - $550

Eureka High Roller: Dates TBC - $2,200

EPT:

EPT Super High Roller: Dates TBC - $50,000

EPT Main Event: Dates TBC - $5,300

EPT Mystery Bounty: Dates TBC - $3,000

EPT High Roller:  Dates TBC - $10,300

Check back for the full schedule. 

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       Full Schedule Coming Soon  

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: Dates TBC - €1,100

Eureka Cup: Dates TBC - €550

Eureka High Roller: Dates TBC - €2,200

EPT:

EPT Main Event: Dates TBC - €5,300

EPT Mystery Bounty: Dates TBC - €3,000

EPT High Roller: Dates TBC - €10,300

Check back for full details. 

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

    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.