0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0061 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-05-04'
AND `url` = 'https://www.maineventtravel.com/tour/unibet-deepstack-open'
ORDER BY `views` DESC

0.0088 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-05-04'
AND `url` = 'https://www.maineventtravel.com/tour/unibet-deepstack-open'

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.0065 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.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.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = 'unibet-deepstack-open'

0.0003 SECONDS: 
SELECT *
FROM `tours`
WHERE `page_url` = 'unibet-deepstack-open'

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

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

0.0063 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'

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

Unibet DeepStack Open


A €550 buy-in which allows passionate players to take part in an international poker tournament without breaking the bank with a  tournament structure has been created with the help of international tournament director Matt Savage.

Upcoming Tour Stops

Wednesday 15th - Monday 20th May, 2024

UDSO Lyon 2024

Casino Lyon Vert, 200 Avenue du Casino, 69890 La Tour-de-Salvagny, France

Discover the freshly renovated Casino Lyon Vert ! The casino just reopened after its renovations to welcome you in the best conditions !

Unibet DeepStack Open Lyon has always been a record breaking event, gathering all the local players community, but also Swiss, Italian and Spanish players who want to discover the French capital of gastronomy

Win Back Up to 100% of Your Tournament Travel Costs - #FinalTableFreeroll Eligible Event - Click Here for Details
    Find Hotels, Flights & More       View Complete Schedule  
Saturday 1st - Sunday 9th June, 2024

USDO UK Aspers 2024

Aspers Casino Westfield Stratford City, Montfichet Road, Olympic Park, Stratford, E20 1ET

Unibet DeepStack Open and Casino Aspers team up for the first time to offer you a memorable poker event in 2024!

The Unibet DeepStack Open poker tournament is an exciting poker festival set to take place at Aspers Casino in London. Players will have the opportunity to showcase their skills and compete for a chance to win a share of the prize pool.

Main Event Buy In - £500

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 11th - Sunday 16th June, 2024

UDSO Barcelona

Casino de Barcelona, Calle Marina, 19-21, 08005 Barcelona, Spain

UDSO comes back to Barcelona during the best time of the year !

Barcelona Casino welcomes all European poker players to the best Mediterranean poker destination.

Unibet has already started online satellites : qualify every Thursday for a VIP package (Buy-in + hotel + cash), and every Wednesday for a seat only ticket !

Join us for a non stop poker week next to the beach.

#FinalTableFreeroll Eligible Event - Click Here for Details on How You Can Win Back 100% of Your Tournament Travel Costs
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 23rd - Sunday 28th July, 2024

UDSO Sanremo

Casino Sanremo, Corso degli Inglesi, 18, Sanremo, Italy

The beautiful coastal town of Sanremo, Italy, where the tournament will be held, provides a picturesque backdrop for this exciting event. The Sanremo Casino, an iconic venue in the poker world, adds to the allure of the tournament, offering a unique and memorable atmosphere.

Spanning six days,  the tournament encompasses a series of events and satellite tournaments, allowing participants to qualify for the main event.

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 20th - Sunday 25th August, 2024

UDSO Gujan Mestras

Casino de Gujan-Mestras, Lac de la Magdeleine, 2 avenue des loisirs, 33470 Gujan-Mestras, France

The summer stage of Gujan Mestras: one of the emblems of the tour since 2013!

In 2024, join us again for the South West event, in a casino in the middle of the forest near the Arcachon Bay. With an average of 450 admissions each year (nearly 500 in 2022), the 2024 Festival promises to be even bigger thanks to the satellites set up throughout the year!
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 27th August - Sunday 1st September, 2024

UDSO Cluj

Player's Poker Club, Strada Louis Pasteur 75, Cluj-Napoca 400343, Romania

Unibet DeepStack Open is coming for the first time in Cluj! With past events in Romania in Bucharest (3 events with an average 500 entries) and Sinaia, the UDSO lands in one of the most touristic Romanian city : Cluj.
Set in the very popular “Player’s Poker Club”, this edition is looking to beat all local records of the Club in 2024!

The most popular poker festivals from Romania take place in Cluj-Napoca! The UDSO festival features a series of poker tournaments with various buy-ins and formats including the Main Event €550 and the best structure with 50.000 starting stack and 50 min. levels, attracting both local players and international poker enthusiasts.
    Find Hotels, Flights & More       View Complete Schedule  
Friday 20th - Sunday 29th September, 2024

UDSO Marrakech 2024

Casino de Marrakech, Rue Ibrahim El Mazini Hivernage, Marrakech 40000, Morocco

Unibet DeepStack Open is coming back to sunny Marrakech for a new poker experience in Morocco!

In 2023, UDSO broke all local previous records with an astonishing 800 entries! This year again we’ve prepared more surprises for you during this 10-day festival.
    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.