0.0008 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0069 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-07-16' AND `url` = 'https://www.maineventtravel.com/venue/olympic-park-casino' ORDER BY `views` DESC

0.0033 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/venue/olympic-park-casino', 1, '2024-07-16')

0.0003 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.0002 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.0006 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.0058 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.0001 SECONDS:
SELECT * FROM `venues` WHERE `id` = 'olympic-park-casino'

0.0004 SECONDS:
SELECT * FROM `venues` WHERE `page_url` = 'olympic-park-casino'

0.0010 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_stops`.`venue_id` = '214' ORDER BY `tour_stops`.`start_date` ASC

0.0116 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.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` = 'news'

0.0004 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

Olympic Park Casino


The new flagship Olympic Park Casino is located in the centre of Tallinn at Hilton Tallinn Park Hotel. The size of the casino is 1,600 square meters and the casino is open 24/7 to provide Las Vegas style entertainment!

  • The nicest cocktail bar in the city and a comfortable lounge
  • 95 new slot machines by IGT, Novomatic, Aristocrat etc.
  • Olympic Park Casino have 14 table games where you can play Baccarat, Blackjack, Roulette, Oasis poker, Russian poker and Ultimate Texas poker
  • Poker tournaments - international or weekly up to 10 tables
  • Multi-level jackpot systems: Fort Knox, Scientific Games, Mystery Jackpot
  • VIP Room with 4 table games (available only to Olympic Casino Gold and Diamond customers)
  • Smoking room with slots
  • Hilton Tallinn Park Hotel, The Able Butcher restaurant and Eforea Spa are in the same building
  • Free parking for customers (limited parking spaces). 

 


Upcoming Events at this Venue

Friday 19th - Sunday 28th July, 2024

WSOP International Circuit

Olympic Park Casino

WSOP has announced the return of its 20th season of the WSOPC!

#FinalTableFreeroll Eligible Event

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”
    Find Hotels, Flights & More       View Complete Schedule  
Latest News & Blogs

Malta Poker Festival Packages and Hotels on Early Bird Offer

Malta is going to be a hot-bed of poker action this Autumn with a slew of massive events taking place from October 28. 

Goliath Hotels from as low as £48 per night on MainEventTravel.com

Whether it's for 1 night or 10, MET has some of the best prices going on dozens of hotels in Coventry.
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.