0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0104 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-05-08' 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.0003 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.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 * 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.0072 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.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` = '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.0025 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.0130 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.0012 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

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