0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0169 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-24' AND `url` = 'https://www.maineventtravel.com/tour/unibet-deepstack-open'

0.0006 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.0007 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.0117 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.0007 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.0157 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

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