0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0131 SECONDS:
SELECT `views` FROM `page_views` WHERE `date` = '2024-02-23' AND `url` = 'https://www.maineventtravel.com/tour/poker-go-tour' LIMIT 1

0.0011 SECONDS:
INSERT INTO `page_views` (`url`, `date`, `views`) VALUES ('https://www.maineventtravel.com/tour/poker-go-tour', '2024-02-23', 1)

0.0005 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.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.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.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.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.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.0003 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'poker-go-tour'

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

0.0018 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.0159 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.0020 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 28th February - Friday 8th March, 2024

PokerGO Tour - 2024 PGT Mixed Games

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

The PGT Mixed Games is a series of 10 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 Championship $1,000,000 freeroll.

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 20th - Friday 29th March, 2024

PokerGO Tour - 2024 PGT PLO Series

Aria Resort & Casino, 3730 S Las Vegas Blvd, Las Vegas, NV 89158, United States
    Find Hotels, Flights & More       View Complete Schedule  

Monday 8th - Wednesday 17th April, 2024

PokerGO Tour - PGT 2024 U.S. Poker Open

Aria Resort & Casino, 3730 S Las Vegas Blvd, Las Vegas, NV 89158, United States
    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.