0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0107 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-04-25'
AND `url` = 'https://www.maineventtravel.com/news/article/Vegas-the-perfect-poker-holiday-destination-this-Autumn'
ORDER BY `views` DESC

0.0029 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/news/article/Vegas-the-perfect-poker-holiday-destination-this-Autumn', 1, '2025-04-25')

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.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.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.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.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` = 'page'

0.0062 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.0037 SECONDS: 
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as article_count, MAX(news_articles.date) as recent_date
FROM `news_categories`
JOIN `news_article_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id`
JOIN `news_articles` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
GROUP BY `news_categories`.`id`

0.0104 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '11'
AND `news_articles`.`active` = 1
ORDER BY `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'

0.0039 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '16'
AND `news_articles`.`active` = 1
ORDER BY `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.0006 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.0033 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '18'
AND `news_articles`.`active` = 1
ORDER BY `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'

0.0036 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '19'
AND `news_articles`.`active` = 1
ORDER BY `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.0060 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '22'
AND `news_articles`.`active` = 1
ORDER BY `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'

0.0044 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '23'
AND `news_articles`.`active` = 1
ORDER BY `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'

0.0043 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '27'
AND `news_articles`.`active` = 1
ORDER BY `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'

0.0041 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '28'
AND `news_articles`.`active` = 1
ORDER BY `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'

0.0036 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '29'
AND `news_articles`.`active` = 1
ORDER BY `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'

0.0131 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '30'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

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

0.0051 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '31'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

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

0.0019 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 `url_name` = 'Vegas-the-perfect-poker-holiday-destination-this-Autumn'

0.0009 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 `date` <= '2025-04-25'
AND `news_articles`.`active` = '1'
ORDER BY `DATE` DESC, `id` DESC
 LIMIT 5

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` = 'news'

0.0006 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.0002 SECONDS: 
SELECT `news_categories`.*
FROM `news_article_categories`
LEFT JOIN `news_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id`
WHERE `news_article_categories`.`news_article_id` = '895'

0.0001 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%article%'
English
  1. Home
  2. News & Blogs
  3. Vegas – the perfect poker holiday destination this Autumn
Monday 25th September, 2023

Vegas – the perfect poker holiday destination this Autumn

By Mad Harper
Travel Tips Blogs

As Summer draws to a close, many poker players are eyeing up Las Vegas for their next poker vacation. Autumn in Las Vegas means comfortable temperatures – around the mid-70s to mid-80s Fahrenheit – making it the ideal time to explore the iconic Las Vegas Strip, lounge by the pool without getting totally sunburnt, discover the city's hidden gems, or even head out of town to stunning places such as Lake Mead, Hoover Dam and Red Rock Canyon.

Visiting Las Vegas in the Autumn brings a host of other benefits too. While there’s no shortage of world-class poker action, the city is far less crowded than in Summer: queues are shorter, restaurant bookings are easier and hotel bargains abound. You’re also more likely to find really affordable prices for shows and tours.

This Autumn also heralds a thrilling schedule of sport with inaugural Formula 1 Grand Prix hitting town from November 16 to 18, the Canelo Alvarez versus Jermall Charlo boxing match taking place at the T-Mobile Arena on September 30 and a string of great football matches between local heroes Las Vegas Raiders and the New England Patriots (October 15), the New York Giants (November 5), the Kansas City Chiefs (November 26) and the Minnesota Vikings (December 10).

Staying in Vegas

When it comes to accommodation, MainEventTravel has rooms available at hotels all over the city this Autumn, to suit budgets of all kinds. This is a great time to snag a bargain stay right on the Vegas strip (perhaps not so affordable in the height of WSOP season) but also to explore other areas of the city.

New attractions


The Sphere
There are also a bunch of amazing new attractions in Las Vegas opening this Autumn. Chief among them is The Sphere (pictured below)– a much-heralded futuristic new entertainment area that lies just east of the Venetian Resort. With a capacity of 18,600, the world’s largest spherical structure cost some $2.3 billion to build making it the most expensive entertainment venue in the city. Its bowl-shaped theatre contains the world’s highest-resolution wraparound LED screen but even if you don’t go in, you’ll certainly be able to admire The Sphere from outside. The exterior is being illuminated 24/7 with animations and other imagery. The Sphere is being officially launched by U2 on September 29 with a series of 25 concerts built around the Irish band’s landmark 1991 album Achtung Baby.

Atomic Golf

Atomic Golf (pictured below) at the Strat is set to open in time for the Formula One Las Vegas Grand Prix on Nov. 18. This 100,000 square-foot, four-storey golf and entertainment complex will host next-generation golf technology with an immersive experience through gameplay. The project will host four stories with 103 hitting bays facing the stunning Red Rock Canyon, eight putting bays featuring projection mapping technology, six bars – including a featured tap room with 15 locally brewed beers, meeting spaces and a 12,000-square-foot Astrocade with giant-screen televisions and a sports bar atmosphere

Durango Casino and Resort
Durango Casino and Resort (pictured below) is a brand new casino opening in the Las Vegas Valley on November 20 featuring 83,000 square feet of casino space, 200 hotel rooms, a stunning pool, free parking and 15 restaurants including a steakhouse, a modern Mexican Restaurant, the Summerhouse beach restaurant, the Bel-Aire Lounge cocktail bar and a 25,000-square-foot Eat Your Heart Out food hall, along with The George Sportsmen’s Lounge offering food and drinks, live entertainment, bar-top gaming and sports viewing on a 56-foot-long LED screen.

 

Autumn is also a great time to catch top stars in action. Lady Gaga is doing five nights at Park MGM in October while, in November, Adele is followed by Rod Stewart at Caesar’s Palace. Vegas is world-renowned for spectacles such as the aquatic Cirque du Soleil extravaganza “O" and the quirky "Blue Man Group" show – all easier to get into once the summer crowds have dissipated. And then there’s Halloween – a great shout for a Las Vegas visit with a ton of weekend events around the city from extravagant fancy-dress galas to Halloween-themed club nights.

Autumn Poker Tournaments in Vegas 

Venetian Deepstack Vegas
If you’re a deepstack poker fan then there’s no better place to head for this Autumn than the DeepStack Showdown Poker Series. The Venetian is a sumptuous Italian-style casino located right on the Strip and it’s been a mecca for deepstack players for more than 15 years. With nearly 60 different tournaments on the schedule – and more than $1 million in guaranteed tournament prize pools, the DeepStack Showdown Poker Series is all the excuse you need to spend time in Sin City. It’s taking place throughout October through to November 12 with at least one tournament every single day.

 WPT World Championships and WPT Prime Championship
The second WPT World Championships festival kicks off on November 29 this year and another massive turnout is expected. MainEventTravel is a Preferred Travel Supplier for the season-ending extravaganza which is taking place at the Wynn Las Vegas.

 Last year’s debut World Championship Main Event attracted nearly 3,000 entries creating a prize pool of £29,008,000, nearly double the $15k guarantee.  The award-winning tournament was named Event of the Year in the 2022 Global Poker Awards. This year the prize pool guarantee has been boosted to an incredible $40 million making it the biggest tournament guarantee ever offered.

 The full WPT World Championships festival, which marks the grand finale for Season XXI of the World Poker Tour,  runs from November 29 to December 21. The robust schedule is certain to attract a stellar crowd and features a great mix of tournaments at the glamorous Wynn Las Vegas casino including the WPT Prime Championship (December 7-12) and the WPT World Championship Main Event (December 12-21) which features four starting flights and a televised final table.

 WPT Prime

The WPT Prime series made its debut last year and has already proved a huge success. This year’s season-ender – the $5 million guaranteed WPT Prime Championship – is running from December 7-12 at the Wynn with a $1,100 event featuring four starting flights and a televised final table on December 19. Last year’s inaugural $1,100 WPT Prime Championship event was another blockbuster with 5,430 entrants and a prize pool of $5,267,100, way more than the $2 million guarantee. The winner was American Stephen Song for a career-best live cash of $712,650. Among the 677 players who cashed was Britain’s Tom Middleton who finished 11th for £56,500.

Poker Go – Aria – October

Featuring only poker tournaments with buy-ins of $10,000 or greater, the PokerGO Tour aims to become one of poker’s most exclusive tours. There’s a LOT of Poker Go action at the ARIA this Autumn including the PGT Mixed Games II festival, the PGT Super High Roller Bowl Pot Limit Omaha event and the 2023 PGT PLO Series II. The PGT Mixed Games II festival is running October 5-14, a  series of nine events with the player earning the most PGT points awarded the $25,000 championship bonus. The top 40 players as ranked by the PGT leaderboard at the end of the season will qualify for the season-ending PGT Championship $1,000,000 freeroll. Take your pick from $10,200 H.O.R.S.E., $5,100 10-game Mix Mini Championship, Triple Stud Mix, Triple Draw Mix and so on – you get the picture!

Wynn Fall Classic – October

The Wynn Fall Classic returns with 23 tournaments and more than $3,800,000 in guaranteed prize pools including two headlining events, both featuring $1 Million guarantees. This series offers multiple Seniors and mixed game tournaments, plus the exciting addition of Dealers Choice. Players can still win their seats into higher buy-in events by playing in a Milestone Satellite, or the new Double Play format which awards winners with two $1,100 tournament tickets redeemable during the festival.

NAPT – Resorts World – November 

Hurrah for PokerStars bringing back the North American Poker Tour! NAPT Las Vegas gets underway on November 4 at Resorts World with a $1,650 buy-in Main Event starting November 6. The $550 PokerStars Cup is scheduled for November 9-12, with a $5,300 High Roller attracting the biggest names between November 10-12. 

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