0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0006 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour/unibet-deepstack-open', 1, '2024-07-16')

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.0004 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.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.0061 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.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'unibet-deepstack-open'

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

0.0010 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.0070 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.0004 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

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

Tuesday 20th - Sunday 25th August, 2024

UDSO Gujan Mestras

Casino de Gujan-Mestras, Lac de la Magdeleine, 2 avenue des loisirs, 33470 Gujan-Mestras, France

The summer stage of Gujan Mestras: one of the emblems of the tour since 2013!

In 2024, join us again for the South West event, in a casino in the middle of the forest near the Arcachon Bay. With an average of 450 admissions each year (nearly 500 in 2022), the 2024 Festival promises to be even bigger thanks to the satellites set up throughout the year!

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 27th August - Sunday 1st September, 2024

UDSO Cluj

Player's Poker Club, Strada Louis Pasteur 75, Cluj-Napoca 400343, Romania

Unibet DeepStack Open is coming for the first time in Cluj! With past events in Romania in Bucharest (3 events with an average 500 entries) and Sinaia, the UDSO lands in one of the most touristic Romanian city : Cluj.
Set in the very popular “Player’s Poker Club”, this edition is looking to beat all local records of the Club in 2024!

The most popular poker festivals from Romania take place in Cluj-Napoca! The UDSO festival features a series of poker tournaments with various buy-ins and formats including the Main Event €550 and the best structure with 50.000 starting stack and 50 min. levels, attracting both local players and international poker enthusiasts.

    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  

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       Full Schedule Coming Soon  

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       Full Schedule Coming Soon  

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!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

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