0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0052 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-04-27'
AND `url` = 'https://www.maineventtravel.com/venue/aria-resort-casino'
ORDER BY `views` DESC

0.0082 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-04-27'
AND `url` = 'https://www.maineventtravel.com/venue/aria-resort-casino'

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.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.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.0006 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.0065 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` = 'aria-resort-casino'

0.0004 SECONDS: 
SELECT *
FROM `venues`
WHERE `page_url` = 'aria-resort-casino'

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

0.0067 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.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.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. Aria Resort & Casino

Aria Resort & Casino


The Aria Resort and Casino, operated by MGM Resorts International, is a luxurious destination. It features two curvilinear glass towers that soar to 50 stories. With 4,004 rooms and suites, the hotel is distinguished by the AAA Five Diamond Award and has earned a five-star rating from the Forbes Travel Guide.

Aria's Casino, spanning over 150,000 square feet, features 24 tables. It has been a venue for events by the World Poker Tour (WPT) and PokerGo.

Upcoming Events at this Venue

Wednesday 29th May - Saturday 13th July, 2024

Aria Hotel & Casino

Aria Poker Classic 2024

The 2024 ARIA Poker Classic will feature 45 events with guaranteed prize pools totaling over $12,000,000! Aria are excited to continue our partnership with presenting sponsor BetMGM hosting their $3M GTD BetMGMPoker Championship on June 6th-11th!

#FinalTableFreeroll Eligible Event
    Find Hotels, Flights & More       View Complete Schedule  
Wednesday 19th June - Monday 8th July, 2024

Poker GO Tour

2024 ARIA High Roller Series

The ARIA High Roller Series returns to the PokerGO Studio in Las Vegas, Nevada, with a 14-event schedule.

Considering the competitive World Series of Poker and Wynn Las Vegas tournament schedules, the ARIA High Roller Series will give high-stakes players more opportunities to play these single-day high rollers in between the bigger events taking place throughout Las Vegas. 

The schedule will include nine Pot-Limit Omaha Omaha tournaments before switching to five consecutive No-Limit Hold'em tournaments. The ARIA High Roller Series will open with two $5,000 buy-in Pot-Limit Omaha tournaments following the WSOP $1,500 Mixed Pot-Limit Omaha and WSOP $1,000 Pot-Limit Omaha. 

The ARIA High Roller Series is part of the 2024 PGT season with players earning PGT points based on the amount they cash for. The Top 40 eligible 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. 
    Find Hotels, Flights & More       View Complete Schedule  
Latest News & Blogs

All change at the Vic!

With events being relocated due to refurb, MainEventTravel has your back with great accommodation options near all the Grosvenor Casinos selected.

Geraghty wins 888poker LIVE UKPL Manchester

Scottish player Jamie Geraghty has won the 888poker LIVE UKPL Manchester Main Event for the biggest cash of his live poker career. Geraghty won £30,610 after outlasting a 328-entry field – and beating Josh Radley heads-up.
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.