0.0006 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0013 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour/eureka-poker-tour', 1, '2024-04-19')

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.0008 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

0.0005 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.0118 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.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.0019 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.0140 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.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.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

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.