0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0072 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-02-06' AND `url` = 'https://www.maineventtravel.com/tour/venetian-deepstack-extravaganza' ORDER BY `views` DESC

0.0126 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-02-06' AND `url` = 'https://www.maineventtravel.com/tour/venetian-deepstack-extravaganza'

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.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.0077 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.0005 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` = 'venetian-deepstack-extravaganza'

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'venetian-deepstack-extravaganza'

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

0.0026 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` = '24' ORDER BY `tour_stops`.`start_date` ASC

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

Venetian Deepstack Extravaganza


The series that started it all back in 2007.

DeepStack Extravaganza became a reality at the request of players looking for better value. By putting the players first, The Venetian Poker Room developed these deep stack poker tournaments. This poker series gave the players more starting chips, a better structure, and longer levels.  They provide tremendous value in terms of exciting high stakes poker play and some of the largest prize pools around. 

Upcoming Tour Stops

Monday 3rd - Sunday 23rd February, 2025

DeepStack Extravaganza I

The Venetian, The Venetian, Las Vegas, Nevada

Nearly $3.3 Million in guaranteed tournament prize pools

Be a part of history with our first live streamed Final Tables:
$1,600 NLH MSPT $1 Million GTD Feb 5-10
$1,600 NLH Card Player Poker Tour $1 Million GTD Feb 12-16

    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.