0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

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

0.0075 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.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = 'eureka-poker-tour'

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

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

0.0016 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.0075 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.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.0004 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%individual-tour-stop%'
English
  1. Home
  2. Events
  3. Eureka Poker Tour

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: Dates TBC - €330

Eureka Main Event: Dates TBC - €1,100

Eureka High Roller: Dates TBC - €2,200

#FinalTableFreeroll Eligible Event
    Find Hotels, Flights & More       Full Schedule Coming Soon  
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  
UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
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.