0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

0.0005 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.0006 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.0041 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.0004 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.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '83'

0.0023 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.0085 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.0011 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.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

Tuesday 18th - Sunday 23rd February, 2025

UDSO Aix-En-Provence

Pasino Grand, 21 Av. de l'Europe, 13090 Aix-en-Provence, France

The Unibet DeepStack Open returns once again to Aix-en-Provence, a stop now firmly established in the circuit’s calendar. In the unique atmosphere of Provence, the tables will host a diverse range of players, from seasoned veterans to newcomers, all competing to earn valuable points for the overall ranking!

 
    Find Hotels, Flights & More       View Complete Schedule  
Friday 14th - Sunday 23rd March, 2025

UDSO Namur 2025

Grand Casino de Namur, Avenue Baron de Moreau 1, 5000 Namur, Belgium

Poker enthusiasts, get ready for an unforgettable experience! Casino de Namur invites you to take part in its prestigious poker tournament, running from March 14 to  23, 2025.

Join players from around the world for a week filled with strategy, competition, and adrenaline. With tournament structures catering to all skill levels and exceptional prize pools, this event is your chance to showcase your talent and, who knows, claim the coveted title!
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Tuesday 8th - Sunday 13th April, 2025

UDSO Tallinn 2025

The Chesterfield Club, Viru väljak 2, 10111 Tallinn, Estonia

Get ready for an unforgettable week of poker at the Chesterfield Club in Tallinn! From April 8th to 13th, 2025, Chesterfield is hosting an exclusive Unibet DeepStack Open poker tournament that promises intense competition, thrilling action, and incredible prizes.

Whether you’re a seasoned pro or a rising star, this tournament will test your skills and strategy across a variety of exciting formats. Come join players from all over the world in the heart of Tallinn for a week of non-stop action!
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Tuesday 8th - Sunday 13th April, 2025

UDSO Pornic 2025

Casino Pornic, 30 Rue du Canal, 44210 Pornic, France
After several successful editions, the Unibet DeepStack Open returns to Pornic from April 8th to 13th, transforming the coastal town into a poker hotspot for six days.

The UDSO in Pornic will be an incredible opportunity for players with an entry ticket to compete in an enchanting maritime setting—the tables at the Casino Partouche Pornic will be ready to host intense competitions!
    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.