0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0100 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-03-29' 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.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.0002 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.0040 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.0005 SECONDS:
SELECT * FROM `venues` WHERE `page_url` = 'aria-resort-casino'

0.0038 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.0097 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.0008 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.0008 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

Tuesday 25th March - Saturday 5th April, 2025

Poker GO Tour

2025 PGT PLO Series

The PGT PLO Series is a series of 11 events with the player who earns the most PGT points awarded the $10,000 PGT Passport. The top 40 eligible players as ranked by the PGT leaderboard at the end of the season will qualify for the season-ending PGT $1,000,000 Championship freeroll. 

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 8th - Thursday 17th April, 2025

Poker GO Tour

2025 PGT US Poker Open
    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 16th - Tuesday 29th April, 2025

Poker GO Tour

PGT Texas Poker Open

$2,000,000 Guaranteed Main Event

    Find Hotels, Flights & More       View Complete Schedule  
Latest News & Blogs

Top Hotels for the WSOP 2025: 2 Months to Go – Have You Booked Yet? Lock in the Best Rates Today!

The World Series of Poker (WSOP) is just two months away, and if you haven’t already secured your accommodation, now is the time to act! The WSOP is one of the most prestigious poker events in the world, drawing thousands of players and fans to Las Vegas for weeks of thrilling action.

The 2025 World Series of Poker

The World Series of Poker (WSOP) is back for its 56th edition, set to take place from May 27 to July 16, 2025, at Horseshoe Las Vegas and Paris Las Vegas. This summer’s series promises to be bigger than ever, with an unprecedented 100 bracelet events, including a mix of classic tournaments and exciting new additions.
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.