0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0080 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-05-19' AND `url` = 'https://www.maineventtravel.com/tour/eureka-poker-tour'

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.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.0061 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.0005 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` = 'eureka-poker-tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'eureka-poker-tour'

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

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

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

Eureka Poker Tour


Eureka 2024 has arrived.

Will PokerStars see you at one of this year’s stops?

Upcoming Tour Stops

Monday 1st - Sunday 7th July, 2024

EUREKA Hamburg

Casino Schenefeld, Industriestraße 1, 22869 Schenefeld, Hamburg

PokerStars heads to Germany for another round of Eureka action in Hamburg. Rozvadov set the tone, so expect Eureka Hamburg to take the excitement to a whole new level at the beginning of July in Schenefeld. Let’s face it – there are worst places to spend your summer.

With the Eureka Cup, High Roller and Main Event tournaments all featuring throughout the event, you won’t be disappointed by what’s on offer. And as Schenefeld is located on the outskirts of Hamburg, there’s plenty to do and see in the local vicinity.

Eureka Cup: July 1-3 - €330

Eureka Main Event: July 3-7 - €1,100

Eureka High Roller: July 6-7 - €2,200

#FinalTableFreeroll Eligible Event

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 9th - Sunday 20th October, 2024

EUREKA Cyprus

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

Thrilling live poker. World-class accommodation. On the shores of the Mediterranean.

We’re talking Eureka Cyprus, of course. Join us October 9-20 under the stunning autumn sun for one of the most well-loved stops on the Eureka Poker Tour.

Held at the beautiful Merit Royal Diamond Hotel Casino & Spa, Eureka Cyprus is the perfect choice if you’re looking for the thrill of live poker in a mesmerising Mediterranean paradise.

Eureka Main Event: Dates TBC– $1,100

Eureka Cup: Dates TBC – $550

Eureka High Roller: Dates TBC – $2,200

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

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 4th - Sunday 15th December, 2024

EUREKA 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 Eureka 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 Eureka Poker Tour stop of the year.

Eureka Main Event: Dates TBC - €1,100

Eureka Cup: Dates TBC - €550

Eureka High Roller: Dates TBC - €2,200

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for 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.