0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0068 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-08-25' AND `url` = 'https://www.maineventtravel.com/venue/olympic-park-casino' ORDER BY `views` DESC

0.0118 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-08-25' AND `url` = 'https://www.maineventtravel.com/venue/olympic-park-casino'

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

0.0003 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.0005 SECONDS:
SELECT * FROM `venues` WHERE `page_url` = 'olympic-park-casino'

0.0012 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.0113 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.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 14th - Sunday 23rd November, 2025

Kings of Vilnius

Kings of Vilnius

Kings of Vilnius is on the horizon—get ready for an unforgettable experience in Lithuania’s capital!

    Find Hotels, Flights & More       Full Schedule Coming Soon  
Latest News & Blogs

Sun, Cards & Travel: Get Ready for the Malta Poker Festival 2025

The Malta Poker Festival returns from 27 October to 3 November 2025, offering a full week of exciting tournaments in the stunning setting of St. Julian’s. Players can conveniently book their flights and hotel accommodation through Main Event Travel, making it easy to plan the perfect poker getaway.

EPT Barcelona 2025: Poker’s Summer Highlight Returns This Month!

Get ready for EPT Barcelona 2025! Taking place this month from 18th August to 31st August at Casino Barcelona, this year's festival promises huge turnouts and top-tier poker action. Check out the best hotel options near the venue and book now before rooms sell out!
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.