0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

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.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.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.0118 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.0002 SECONDS:
SELECT * FROM `venues` WHERE `id` = 'aria-resort-casino'

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

0.0019 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.0131 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'

English

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

Monday 8th - Wednesday 17th April, 2024

Poker GO Tour

PokerGO Tour - PGT 2024 U.S. Poker Open
    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 from June 19 to July 8, 2024.

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 14-event 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 WSOP $10,000 Pot-Limit Omaha Championship will begin on June 26, and on either side of Day 1 will be two $10,000 buy-in Pot-Limit Omaha tournaments. On Day 3 of the WSOP $25,000 Pot-Limit Omaha High Roller will be a $15,000 buy-in Pot-Limit Omaha tournament, followed by the final two $5,000 buy-in Pot-Limit Omaha tournaments of the series.

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

MainEventTravel.com featured in PokerNews as Vegas Poker Travel Experts!

MainEventTravel.com has been featured in PokerNews as The Trip Leader If You're Heading to Vegas for the 2024 WSOP!

Main Event Travel.com Offers IPT's Portugal Adventure Travel this Summer!

MainEventTravel.com is excited to extend some fantastic offers on Packages, Hotels, and ATOL-Protected Flights as well as Buy-ins for this festival set along a 13km stretch of pristine sands and crystal-clear waters.
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.