0.0006 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0211 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-19' AND `url` = 'https://www.maineventtravel.com/destination/articles/las-vegas-guide/Vegas-summer-tourney-lowdown-2019' ORDER BY `views` DESC

0.0016 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/destination/articles/las-vegas-guide/Vegas-summer-tourney-lowdown-2019', 1, '2024-04-19')

0.0008 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.0005 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0010 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

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` = 'tour'

0.0004 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

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` = 'tour'

0.0002 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0201 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.0011 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.0003 SECONDS:
SELECT destinations.*, uapi_airports.name as airport_name FROM `destinations` LEFT JOIN `uapi_airports` ON `destinations`.`uapi_code` = `uapi_airports`.`airport_code` WHERE `url` = 'las-vegas-guide'

0.0029 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 `url_name` = 'Vegas-summer-tourney-lowdown-2019'

0.0002 SECONDS:
SELECT `news_categories`.* FROM `news_article_categories` LEFT JOIN `news_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` WHERE `news_article_categories`.`news_article_id` = '599'

0.0073 SECONDS:
SELECT DISTINCT tour_stops.*, tours.name as tour_name, ((ACOS(SIN(36.11532281210326 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(36.11532281210326 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((-115.17587848916014 - venues.map_longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance, venues.name as venue_name, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, tours.logo as tour_logo, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo FROM `venues` LEFT JOIN `tour_stops` ON `tour_stops`.`venue_id` = `venues`.`id` JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` WHERE `tour_stops`.`active` = '1' AND tour_stops.end_date > CURDATE() HAVING `distance` <= 10 ORDER BY `tour_stops`.`start_date` ASC

0.0004 SECONDS:
SELECT `news_articles`.`url_name`, `news_articles`.`main_image`, `news_articles`.`meta_description`, `news_articles`.`title` FROM `news_article_destinations` JOIN `news_articles` ON `news_article_destinations`.`news_article_id` = `news_articles`.`id` WHERE `news_articles`.`active` = 1 AND `destination_id` = 2 ORDER BY `news_article_destinations`.`display_order`

English
Wednesday 15th May, 2019

Vegas baby! MET's full summer tournament lowdown

By Mad Harper

The World Series of Poker may grab most of the poker headlines, but it’s certainly not the only big event happening in Las Vegas this summer. Overall, there are more than 1,500 tournaments in Vegas during the WSOP with eight casinos organising their own summer schedules featuring a wide range of buy-ins, guarantees and game formats. Tear yourself away from the Rio and you’ll find a rich load of other tourney offerings around the city.

With more than 100 Vegas visits between us (and direct experience of dozens of different hotels and other accommodation), we have unparalleled expertise in helping you get the most of your Vegas trip. Just get in touch and we will help, whatever your budget, planned schedule and any other requirements.

Big festivals are taking place throughout May, June and July, with buy-ins to suit players of all kinds. These include the Aria Poker Classic 2019, the Venetian’s DeepStack Extravaganza III and the 2019 Phamous Poker Series Goliath at Planet Hollywood along with the Golden Nugget’s Grand Poker Series, Binions Summer Series 2019 and the Wynn Summer Classic.

Vegas summer – at a glance

World Series of Poker – Rio, 89 events, May 28 to July 16
2019 Phamous Poker Series Goliath
- Planet Hollywood, 93 events, May 28 – July 11
Aria Poker Classic 2019 – ARIA, 78 events, June 2 to July 14
DeepStack Extravaganza III – the Venetian, 116 events, May 13 – July 28
Grand Poker Series
– Golden Nugget, 93 events, May 28 - July 8
Binions Summer Series – Binions, 15 events, June 1- July 1
Wynn Summer Classic – the Wynn, 49 events, May 30 – July 16

Aria Poker Classic
The Aria Poker Classic 2019 runs June 2 to July 14 at the ARIA Resort and Casino and is one of several series offering a lower buy-in alternative to the World Series of Poker at the Rio. The Aria Poker Classic schedule features twice daily tourneys on most days, 11 a.m. and 7 p.m., with morning events usually featuring a guarantee and bigger buy-in.

The flagship event on the schedule is the WPT500, a giant $550 buy-in event running June 21-27 and featuring eight different starting flights. Day 2 is on Wednesday, June 26 with the tournament’s final the next day. This is the sixth WPT500 at the ARIA. There will also be, for the first time, a partypoker LIVE MILLIONS Vegas ‘Special Edition’ taking place at ARIA from June 28 – July 2. This will be a standalone $5 million guaranteed ‘Special Edition’ of the MILLIONS tour with a $10,300 buy-in and two Day 1s. Live satellites at ARIA will begin Thursday, June 27. All other events on the Aria Poker Classic 2019 schedule, with the exception of the $1k NLH, $1,100 HORSE and the WPT500 are one-day tournaments.

Venetian
The Venetian’s summer DeepStack Extravaganza III still remains one of the most popular series on offer in Las Vegas and this year features more than $24 million in guaranteed prize pools. Running from May 13 to July 28, there are 116 events on offer including no-limit hold'em, Pot Limit Omaha, NLH EpicStack, Progressive Bounty, Omaha 8-or-Better and two-day Big O. There’s two Seniors events and the $5,000 Card Player Poker Tour Main Event comes with a $2 million guarantee. Overall, buy-ins range from $200 to $5,000.

Planet Hollywood
The popular Planet Hollywood poker series kicks off May 28 and runs through to July 7, with mllion of dollars in tournament guarantees. The 2019 Phamous Poker Series Goliath features multiple events most days, culminating in a $1,700 Main Event with $1 million guarantee. Other highlights including two $250,000 guaranteed $250 GOLIATH Quarter Milly events, starting June 2 and June 5 respectively, with multiple start flights and a guaranteed $50,000 for each winner.

The series opens with a Casino Employees’ tourney and there’s a comprehensive range of formats on offer in other tourneys including Triple Draw, PLO, Omaha/Stud, Bounty, Razz, Tag Team and Survivor events. Last year, Krasimir Yankov won the Main Event for $272k after defeating a 924-entry field.

Golden Nugget
The Golden Nugget's annual Grand Poker Series is back for a 12th edition this summer. The series, which runs alongside the World Series of Poker and several other poker series during the summer in Las Vegas, runs from May 28 through July 8 with a staggering 93 events.

The Grand Poker Series is one of several lower-buy-in options available during this summer, with tournaments ranging from $120 to $570. While the series features predominantly no-limit hold'em events, a handful of Omaha, stud and other mixed game tourneys are also in the mix. The Grand Poker Series is certainly considered one of the better tournament series for low-stakes players and the downtown location makes it a must-visit destination in its own right.

Highlights of the 2019 Grand Poker Series include a $250k guarantee re-entry starting June 6 and another getting underway on June 20 and a $600K Guarantee NLH tournament starting June 27. All three tournaments have multiple start flights.

Binion's Summer Series
Binion’s Gambling Hall is the place that made poker famous and is an iconic destination among poker players for this extraordinary legacy. Binion's has a feast of tourneys on offer this summer with its Binions Summer Series including a great mix of NLHE and non-NLHE tourneys. The schedule features nightly $75 NL tournaments as well as various PLO and Stud events. The $1,100 Pot Limit Omaha Championship gets underway on June 19 and the $1,100 three-day HORSE Championship starts June 28.

Wynn Summer Classic
The annual Wynn Summer Classic returns this year from May 30 to July 16 and is offering close to $19 million in guaranteed prize pools across 47 cash tournaments. There is something for everyone nearly every single day including the flagship three-flight $1,600 No-Limit Hold'em Championship in July. There's also the Wynn’s $1,100 event starting June 11 with multiple starting days and a $1,5 million guarantee.

pha



What's Hot in Las Vegas


Events

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.