0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0153 SECONDS:
DELETE FROM `page_views` WHERE `views` < 15 AND `date` != '2023-12-07'

0.0155 SECONDS:
DELETE FROM `page_views` WHERE `date` < '2022-10-13'

0.0083 SECONDS:
SELECT `views` FROM `page_views` WHERE `date` = '2023-12-07' AND `url` = 'https://www.maineventtravel.com/tour/ept' LIMIT 1

0.0175 SECONDS:
UPDATE `page_views` SET `views` = 4 WHERE `date` = '2023-12-07' AND `url` = 'https://www.maineventtravel.com/tour/ept'

0.0006 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.0003 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0691 SECONDS:
SELECT `tours`.*, (select COUNT(*) from tour_stops where tour_stops.tour_id=tours.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

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` = 'tour'

0.0003 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.0002 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0053 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.0012 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.0055 SECONDS:
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as article_count, MAX(news_articles.date) as recent_date FROM `news_categories` JOIN `news_article_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` JOIN `news_articles` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` GROUP BY `news_categories`.`id`

0.0121 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '11' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0014 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.0055 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '16' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0015 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.0008 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.0050 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '18' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0013 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.0052 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '19' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0013 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.0073 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '22' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0014 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.0062 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '23' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0016 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.0060 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '27' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0014 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.0058 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '28' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0014 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.0050 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '29' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0018 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.0132 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '30' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0014 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.0008 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.0066 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '31' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0014 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.0008 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 `tours` WHERE `id` = 'ept'

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

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

0.0021 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.0119 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.0014 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'

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 6th - Sunday 17th December, 2023

EPT Prague

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

Festival Dates: December 6-17, 2023

Key Dates & Tournament Schedule

See below for key tournament dates. 

Eureka:

Eureka Main Event: December 7-11 - €1,100

Eureka Cup: December 9-10 - €440

Eureka High Roller: December 10-11 - €2,200

EPT:

EPT Super High Roller: December 10-12 - €50,000

EPT Main Event: December 11-17 - €5,300

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

EPT High Roller: December 15-17 - €10,300

*The holding of the tournament and its schedules is subject to possible changes arising from the health situation (COVID-19) and the current restrictions in force imposed by the competent authorities.

#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 14th - Sunday 25th February, 2024

EPT Paris

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

That’s right. The European Poker Tour (EPT) is returning to Paris for 2024 after the roaring success of the inaugural event in 2023. Expect drama, huge hands and nail-biting live poker action from the first hand to the last as the EPT does its thing once again in the French capital.

And with the event being held at the mesmerizing La Palais De Congres, expect this year’s EPT Paris to be bigger, bolder and more captivating than ever before.

Key EPT and FPS tournament dates.

FPS:

FPS Main Event: February 14-19 - €1,100

FPS Cup: February 17-18 - €550

FPS High Roller: February 18-19 - €2,200

EPT:

EPT Super High Roller: February 18-20 - €50,000

EPT Main Event: February 19-25 - €5,300

EPT Mystery Bounty: February21-23 - €3,000

EPT High Roller: February 23-25 - €10,300

Check back for the full schedule. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 24th April - Saturday 4th May, 2024

EPT Monte-Carlo

Le Casino de Monte-Carlo, Pl. du Casino, 98000 Monaco

A stunning location. Players from around the world. As always, EPT Monte-Carlo is sure to be an incredible poker tournament. Are you ready to join the action and enjoy a once in a lifetime experience?

The glitz and the glamour of the star-studded EPT Monte-Carlo is here again, and the Principality is ready to showcase why this is an event that isn’t to be missed. If you’re searching for a live event to sample, this one has to be at the top of your list.

With everything from the Main Event to the High Roller and Super High Roller tournaments, there’s going to be incredible poker from day one. Get ready to take your seat at the tables.

FPS:

FPS Main Event: April 24-28 - €1,100

FPS Cup: Dates TBC - €550

FPS High Roller: Dates TBC - €2,200

EPT:

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

EPT Main Event: April 29-May 4 - €5,300

EPT Mystery Bounty: Dates TBC - €3,000

EPT High Roller: Dates TBC - €25,000

Check back for the full schedule. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

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.

Join EPT from August 26 to September 8, 2024 at the luxurious Casino Barcelona for one of the EPTs most well-loved stops of the year.

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

Check back for the full schedule. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

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. 

    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

The European Poker Tour (EPT) will be ending the tour for 2024 with its annual return to Prague.

Check back for full details. 

    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.