0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0228 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-04-25'
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.0008 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

0.0005 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.0003 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.0118 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.0014 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.0005 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.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = 'unibet-deepstack-open'

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

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

0.0020 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.0126 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.0014 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.0007 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.0004 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

Monday 22nd - Monday 29th April, 2024

MPF UDSO Malta Spring 2024

The Casino at Portomaso, Portomaso, Malta

Malta Poker Festival and Unibet DeepStack Open are teaming up again from April 22nd to 29th for the MPF Grand Event Powered by USDO!

With 1444 entries during last MPF UDSO Grand Event : we’re getting ready to break new records this time !

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details
    Find Hotels, Flights & More       View Complete Schedule  
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  
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.