0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0086 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-09-10'
AND `url` = 'https://www.maineventtravel.com/venue/the-venetian'
ORDER BY `views` DESC

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/venue/the-venetian', 1, '2025-09-10')

0.0004 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.0005 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.0003 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.0042 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.0001 SECONDS: 
SELECT *
FROM `venues`
WHERE `id` = 'the-venetian'

0.0004 SECONDS: 
SELECT *
FROM `venues`
WHERE `page_url` = 'the-venetian'

0.0012 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_stops`.`venue_id` = '23'
ORDER BY `tour_stops`.`start_date` ASC

0.0074 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.0005 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'
English
  1. Home
  2. Venues
  3. The Venetian

The Venetian



Upcoming Events at this Venue

Thursday 25th - Sunday 28th September, 2025

Mid States Poker Tour

MSPT The Venetian

Nevada Poker State Championship – $300,000 Guarantee
    Find Hotels, Flights & More       View Complete Schedule  
Thursday 1st - Sunday 4th January, 2026

Mid States Poker Tour

MSPT The Venetian

New Years Poker Open – TBD Guarantee 
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Wednesday 4th - Saturday 7th February, 2026

Mid States Poker Tour

MSPT The Venetian

Poker Bowl X – TBD Guarantee 
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Monday 1st - Tuesday 30th June, 2026

Mid States Poker Tour

MSPT The Venetian

Diamond Poker Championship (Dates TBD) – TBD Guarantee 
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Tuesday 1st - Wednesday 30th September, 2026

Mid States Poker Tour

MSPT The Venetian

Nevada Poker State Championship (Dates TBD) – TBD Guarantee 
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Latest News & Blogs

Experience the Thrill: The Festival Series Malta 2025 Returns to Portomaso Casino

The Festival Series Malta 2025 takes place from September 15–21 at Portomaso Casino in St. Julian's, offering a week of high-stakes poker action for players of all levels. Highlights include the €550 Main Event, The Hendon Mob Championship, mixed-format tournaments, and the unique 10-Game Mix. Players can create flexible Main Event travel packages, choosing their preferred hotel and flights. With luxurious surroundings, vibrant nightlife, and Mediterranean charm, the festival promises an unforgettable poker experience.

Irish Poker Tour Killarney Festival 2025 Set for September

Get ready for six incredible days of poker as the Irish Poker Tour Killarney Festival 2025 takes over the Gleneagle Hotel & INEC from 23–28 September! With over €900,000 guaranteed, highlights include the €700 Irish Poker Cup Main Event, the €60,000 Mystery Bounty, and the €50,000 Killarney 300. Don’t miss Ireland’s most exciting poker festival — book your flights and hotel packages now with Main Event Travel and secure your spot in Killarney!
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.