0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0101 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-09-15'
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.0005 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.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.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.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.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.0113 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.0007 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

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. 

#FinalTableFreeroll Eligible Event
    Find Hotels, Flights & More       View Complete Schedule  
Saturday 26th October - Monday 4th November, 2024

UDSO Gold 2024 MPF Malta

The Casino at Portomaso, Portomaso, Malta

Unibet DeepStack Open maintains the partnership with Malta Poker Festival and offers you a unique event that includes a massive €500.000 guarantee for the Main Event !
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 29th October - Sunday 3rd November, 2024

UDSO Annecy 2024

Casino Annecy, 1 All. de l'Impérial, 74000 Annecy, France

The Imperial Casino of Annecy hosts the annual UDSO poker festival! The 2024 edition is already shaping up to be memorable with new surprises for players and the incredible welcome that the Casino has in store for players!

From October 29th, European players will have their eyes set on the Venice of the Alps for a festival that in three years has established itself as one of the best European poker events. With more than 1000 entries for the hundredth edition played at the Annecy casino, players from France, Switzerland, but also from all over Europe who have qualified on Unibet.com and an incredible organization of Texapoker and the casino, including free snack buffets for players throughout the day: coffee, sodas, snacks, candies, … A real gift offered by the Casino d'Annecy!
    Find Hotels, Flights & More       View Complete Schedule  
Friday 15th - Sunday 24th November, 2024

UDSO Paris 2024

Club Circus, 37 Boulevard Murat, 75016 Paris, France

The first Deepstack circuit in Europe returns to Paris in 2024 at Club Circus with the Texapoker teams: UDSO Paris is coming!

€550 Main Event Buy-In. 

#FinalTableFreeroll Eligible Event
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 10th - Sunday 15th December, 2024

UDSO La Grande Motte 2024

Pasino Partouche La Grande Motte, 335 All. des Parcs, 34280 La Grande-Motte, France

UDSO will once again take place at the Pasino de La Grande Motte in 2024!
    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.