0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

0.0007 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.0004 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.0038 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` = 'unibet-deepstack-open'

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

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

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

0.0108 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. 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

Sunday 27th April - Monday 5th May, 2025

MPF UDSO Malta Spring 2025

The Casino at Portomaso, Portomaso, Malta

 Malta Poker Festival is back and teaming up again with the UDSO to heat up Malta!

From the April 27th to May 5th 2025, players from all over Europe will gather at the Portomaso Casino, located in the heart of St. Julian’s. This stop is always highly anticipated, with an average 1500 entries in the Main Event !

Don’t miss these opportunities to compete in thrilling tournaments while exploring everything the archipelago has to offer. Whether you’re an experienced player or looking to test your skills, the Malta Poker Festival and Unibet DeepStack Open promises to be unmissable event in 2025!
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Tuesday 13th - Sunday 18th May, 2025

UDSO Hendaye 2025

Casino Hendaye, 121 Bd de la Mer, 64700 Hendaye, France

From May 13 to 18, 2025, the UDSO will make its debut in Hendaye, an exciting new stop that promises to be one of the highlights of the season.

Players will have the chance to dive into thrilling games while discovering a brand-new stop on the circuit.

Hendaye brings a breath of fresh air to the UDSO—get ready for epic duels at the tables in a friendly and authentic atmosphere, true to the DeepStack spirit. This is an unmissable event where adrenaline and strategy will be at their peak!
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 10th - Sunday 15th June, 2025

UDSO Lyon 2025

Pasino Tour de Salvagny, 200 Av. du Casino, 69890 La Tour-de-Salvagny, France
Lyon will resonate with the sound of chips for five days!

The City of Lights will host a leg of the 15th edition of the UDSO from June 10 to 15 at its Pasino! The tournament has already established itself well in the city and will bring together players from various backgrounds in an ideal setting, ready to compete for attractive prizes.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 15th - Sunday 20th July, 2025

UDSO Sanremo 2025

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

The Unibet DeepStack Open will head to Italy for a summer leg from July 15th to 20th.

As in the 15th edition, the tournament will take place at the stunning Sanremo Casino for 15 days.

With the Mediterranean Sea as a backdrop, players will have the opportunity to experience intense moments at the tables while enjoying the festive atmosphere of the city during this time.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 19th - Sunday 24th August, 2025

UDSO Gujan-Mestras 2025

Casino JOA de Gujan-Mestras, 2 Av. des Loisirs, 33470 Gujan-Mestras, France

The DeepStack Open will return to Gujan-Mestras from August 19 to 24 for its now-traditional summer leg, transforming the beautiful town of Bassin d’Arcachon into a poker hotspot for six days!

The UDSO tournaments held at the JOA Casino will be a golden opportunity to face off against talented players.

Last edition was a success with 618 entries for the Main Event ! 
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Friday 12th - Sunday 21st September, 2025

UDSO Marrakesh

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

From September 12th to 21st, the iconic UDSO event will take place in Morocco in the Es Saadi Resort

As in previous editions, the Marrakech Casino will undoubtedly attract many players for this leg.

It’s always a spectacular competition, taking place at the perfect time to enjoy the city, right after the summer season!
    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.