0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0087 SECONDS:
SELECT `views` FROM `page_views` WHERE `date` = '2024-02-22' AND `url` = 'https://www.maineventtravel.com/venue/olympic-park-casino' LIMIT 1

0.0014 SECONDS:
REPLACE INTO `page_views` (views, `date`, `url`) VALUES (views + 1, '2024-02-22', 'https://www.maineventtravel.com/venue/olympic-park-casino')

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

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

0.0018 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.0118 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'

English

Olympic Park Casino


The new flagship Olympic Park Casino is located in the center of Tallinn at Hilton Tallinn Park hotel. The size of the casino is 1,600 square meters and we are open to provide Las Vegas kind of entertainment!

  The nicest cocktail bar in the city and a comfortable lounge
•    95 new slot machines by IGT, Novomatic, Aristocrat etc.
•    We 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). Ask more from the casino staff. 

 


Upcoming Events at this Venue

Friday 23rd February - Sunday 3rd March, 2024

Kings of Tallinn

Kings of Tallinn 2024

Northern Europe’s biggest poker festival, Kings of Tallinn, is set to return for its tenth year.

The 2024 edition of the festival will take place from 23 February to 3 March at the Olympic Park Casino and Hilton Tallinn Park Hotel in the capital of Estonia. Over ten days, Kings of Tallinn 2024 will hold over 50 tournaments, including the Main Event, with a guaranteed prize pool of €500 000.

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

    Find Hotels, Flights & More       View Complete Schedule  
Latest News & Blogs

Get the Hotel Lowdown for GUKPT Blackpool 10th - 17th March

With just a couple of weeks before the GUKPT kicks off in the popular Lancashire seaside resort of Blackpool, now is the time to book!

Last Chance to Book Exclusive, Deeply Discounted Rooms at Clayton Ballsbridge for Irish Open

MET still has a few rooms available for Irish Open players at an exclusive, discounted rate of €179 per night Single B&B and €189 per night Double B&B.
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.