0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0120 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-09-16'
AND `url` = 'https://www.maineventtravel.com/venue/olympic-casino-lietuva'
ORDER BY `views` DESC

0.0164 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-09-16'
AND `url` = 'https://www.maineventtravel.com/venue/olympic-casino-lietuva'

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.0044 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-casino-lietuva'

0.0006 SECONDS: 
SELECT *
FROM `venues`
WHERE `page_url` = 'olympic-casino-lietuva'

0.0013 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` = '435'
ORDER BY `tour_stops`.`start_date` ASC

0.0086 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'
English
  1. Home
  2. Venues
  3. Olympic Casino Lietuva

Olympic Casino Lietuva



Upcoming Events at this Venue



Sorry, we have no events scheduled yet for Olympic Casino Lietuva.
Please check back soon, or subscribe to our newsletter.




























Latest News & Blogs

GUKPT Edinburgh 2025 — A Key Stop on the UK Circuit

The Grosvenor UK Poker Tour (GUKPT) Edinburgh runs from 9–19 October 2025 at Grosvenor Casino Edinburgh, with the prestigious £1,000 Main Event as the highlight of the ten-day festival. Known for its deep structures and competitive fields, the stop also features a variety of side events and satellites, making it a key date on the UK poker calendar. Main Event Travel, the official travel partner of the GUKPT, provides players with tailored hotel and travel packages to ensure a seamless experience. With Edinburgh’s unique cultural backdrop and only a few stops left before the Grand Final in London, this leg is set to be one of the standout moments of the season.

Experience the Thrill: The Festival Series Malta 2025 Returns to Portomaso Casino

The Festival Series Malta 2025 takes place from September 15–21 at Portomaso Casino in St. Julian's, offering a week of high-stakes poker action for players of all levels. Highlights include the €550 Main Event, The Hendon Mob Championship, mixed-format tournaments, and the unique 10-Game Mix. Players can create flexible Main Event travel packages, choosing their preferred hotel and flights. With luxurious surroundings, vibrant nightlife, and Mediterranean charm, the festival promises an unforgettable poker experience.
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.