0.0006 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0103 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-24' AND `url` = 'https://www.maineventtravel.com/tour/poker-go-tour' ORDER BY `views` DESC

0.0213 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-24' AND `url` = 'https://www.maineventtravel.com/tour/poker-go-tour'

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

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'poker-go-tour'

0.0004 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'poker-go-tour'

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `id` = '128'

0.0022 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_id` = '128' ORDER BY `tour_stops`.`start_date` ASC

0.0136 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.0016 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'

0.0004 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

Poker GO Tour


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, celebrating the most elite professional poker players in a similar fashion to the ranking systems of the world’s most renowned professional sports.

Players that compete in PGT events earn points to rank on a season-long leaderboard. The player to finish the season with the most leaderboard points will be crowned the PGT Player of the Year. New for 2022, the top six point earners will face off in a special end-of-season tournament with starting chip stacks determined by the number of points earned throughout the season.

In its inaugural season in 2021, the PGT attracted more than 17,600 entries and awarded more than $262,000,000 in prize money across nearly 150 tournaments

Upcoming Tour Stops

Wednesday 19th June - Monday 8th July, 2024

2024 ARIA High Roller Series

Aria Resort & Casino, 3730 S Las Vegas Blvd, Las Vegas, NV 89158, United States

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