0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0115 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2026-02-01'
AND `url` = 'https://www.maineventtravel.com/tour/olybet-showdown-vilnius-'
ORDER BY `views` DESC

0.0238 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2026-02-01'
AND `url` = 'https://www.maineventtravel.com/tour/olybet-showdown-vilnius-'

0.0004 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.0005 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
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 *
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.0056 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 `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.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = 'olybet-showdown-vilnius-'

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `page_url` = 'olybet-showdown-vilnius-'

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '178'

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

0.0076 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.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'

0.0003 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%individual-tour-stop%'
English
  1. Home
  2. Events
  3. OlyBet Showdown Vilnius

OlyBet Showdown Vilnius


Olympic Casinos are much more than casino games or slot machines: with their unique interior design, comfortable lounge areas, modern sports bars & betting points, delicious cocktails and music nights they are the place to look for world-class entertainment.

Upcoming Tour Stops

Saturday 14th - Sunday 22nd March, 2026

Olybet Showdown Riga Voodoo Spring 2026

Olympic Voodoo Casino, Riga, Latvia, Elizabetes iela 55, Centra rajons, R?ga, LV-1010, Latvia
From 14 to 22 March, Olympic Voodoo Casino will once again host one of Latvia’s most anticipated poker festivals in the heart of the city. The OlyBet Showdown Riga Voodoo Spring 2026 is ready to take over the tables.
 
Over nine packed days of live poker, players from Latvia and abroad will compete across a schedule featuring 30+ tournaments. The festival is headlined by the €1,100 Main Event and complemented by cash games running throughout the festival
    Find Hotels, Flights & More       View Complete Schedule  
Saturday 9th - Sunday 17th May, 2026

Olybet Showdown Vilnius 2026`

Olympic Casino Lietuva, Konstitucijos pr. 20, 09308 Vilnius, Lithuania

Save the dates!
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Saturday 19th - Sunday 27th September, 2026

Olybet Showdown Riga Voodoo Autumn 2026

Olympic Voodoo Casino, Riga, Latvia, Elizabetes iela 55, Centra rajons, R?ga, LV-1010, Latvia

Save the dates!
    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.