0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0071 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-22' AND `url` = 'https://www.maineventtravel.com/news/article/WSOP-releases2024-schedule' ORDER BY `views` DESC

0.0112 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-12-22' AND `url` = 'https://www.maineventtravel.com/news/article/WSOP-releases2024-schedule'

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.0004 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.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` = 'page'

0.0036 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.0039 SECONDS:
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as article_count, MAX(news_articles.date) as recent_date FROM `news_categories` JOIN `news_article_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` JOIN `news_articles` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` GROUP BY `news_categories`.`id`

0.0097 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '11' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0005 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.0040 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '16' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0011 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.0031 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '18' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0005 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.0161 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '19' AND `news_articles`.`active` = 1 ORDER BY `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.0087 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.0259 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '22' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0005 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.0055 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '23' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0004 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.0051 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '27' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0005 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.0046 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '28' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0005 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.0037 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '29' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0005 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.0099 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '30' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0011 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.0005 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.0050 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '31' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0005 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.0017 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` = 'WSOP-releases2024-schedule'

0.0009 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 `date` <= '2024-12-22' AND `news_articles`.`active` = '1' ORDER BY `DATE` DESC, `id` DESC LIMIT 5

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

0.0004 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.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` = '961'

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%article%'

English
Thursday 15th February, 2024

WSOP releases 2024 schedule

By Kelly Saxby

The 2024 World Series of Poker schedule has been released and it’s the biggest ever with 99 bracelets up for grabs. 

This year’s World Series of Poker, the 55th edition of the series, is running from May 28 through to July 17, at the celebrated Horseshoe and Paris Las Vegas on the Strip after the festival’s highly successful last two series years and looks to be another huge event. The $10,000 No-Limit Hold’em World Championship – best known as the Main Event – starts on July 3. 

The Main Event Final Table will occur July 16-17 at Horseshoe Las Vegas. Last year’s Main Event drew a record 10,043 entrants and crowned Daniel Weinman as its champion. Hailing from Atlanta, Ga., Weinman became the first American to win the WSOP Main Event since 2018 taking home $12.1 million, the largest Main Event first-prize payout in series history.

 

Weinman and many former WSOP Main Event champions will kick off the 2024 series with an all-new event, the Champions Reunion No-Limit Hold’em Freezeout. Serving as Event #1 on this year’s schedule, the contest features a $5,000 buy-in and an exciting twist, allowing players who knock out a former Main Event champion to receive an automatic entry into the 2024 WSOP Main Event as a bounty. All living Main Event champions will be given a free entry to play in the event.

 

“We’re proud to be Las Vegas’s original Main Event,” said Ty Stewart, SVP & Executive Director of the WSOP. “Records are made to be broken, so our motto this year is bigger and better. With our best schedule ever and more than 100 additional poker tables (nearly 700 total), we look forward to welcoming legends, first-timers and everyone in between. If you’re a poker player, there is simply no experience on earth like the World Series of Poker.”

 

The opening week for the 55th edition of the WSOP contains more action-packed events, with the Champions Freezeout and Event #3 WSOP Kickoff No-Limit Hold’em Freezeout.

 

Other new and noteworthy series highlights include:

 

Seniors High Roller No-Limit Hold'em – Event #65: For the first time, players ages 50 and up can participate in an exclusive new high roller event with the Seniors High Roller No-Limit Hold'em tournament. Featuring a $5,000 buy-in and 50,000 starting stack, the three-day event begins on Wednesday, June 26.

 

Mixed No-Limit Hold'em; Pot-Limit Omaha Double Board Bomb Pot (8 Handed) – Event #41: Beginning on Saturday, June 15, this first-of-its-kind event will take place over three days. The buy-in for this event will be $1,500 with a starting stack of 25,000.

 

PokerNews Deep Stack Championship No-Limit Hold'em – Event #62: PokerNews will sponsor the $600 deep stack championship on June 25 as well as offering special promotions to put the spotlight on the low-stakes grinders. In addition to editorial coverage, for four weeks from May 28-June 24, players who participate in the daily $200, $250, or $400 deep stack tournaments at the WSOP will earn points and climb leaderboards. The top 10 point earners each week will get complimentary seats into the $600 PokerNews Deep Stack Championship.

 

Independence Day Celebration No-Limit Hold'em – Event #80: Celebrate Independence Day with a new three-day event at the WSOP. Flight A begins on Wednesday, July 3, and Flight B will begin on Thursday, July 4. Both flights contain $800 buy-ins and a starting stack of 40,000.

 

$1,000 No-Limit Hold’em During Main Event – Event #82: As Flight 1D of the Main Event occurs on Saturday, July 6, there will be a $1,000 buy-in Hold’em event at 7:00 p.m. that night. The two-day event will contain a starting stack of 20,000.

 

$3,000 Mid-Stakes Championship No-Limit Hold’em – Event #89: For players who bust out of the Main Event but want to remain a part of the high-stakes action, this new four-day event begins on July 11 with a $3,000 buy-in and a starting stack of 40,000.

  

Poker fans from around the world can enjoy the sights and sounds of the Las Vegas Strip while reveling in the history linked to Horseshoe Las Vegas. Horseshoe owns a special place in the legacy of the World Series of Poker, as the first-ever WSOP was held at Horseshoe in downtown Las Vegas in 1970. Last summer, the WSOP unveiled the Hall of Fame Poker Room at Horseshoe Las Vegas, featuring 20 poker tables with non-stop action 24/7 and a permanent Poker Hall of Fame exhibit that pays tribute to the sport's legends and history. The 2023 inductee to the Poker Hall of Fame was long-time poker great Brian Rast. The 2024 inductee will be announced this summer.

 

The WSOP Final Table, TV set and staging will again reside inside Horseshoe Las Vegas, and the main cage will be located at Paris Las Vegas. The two buildings are connected and share a parking garage, which can be accessed from Paris Drive. In addition to the new Versailles Tower featuring redesigned luxury guestrooms, Paris Las Vegas has become a mecca for foodies with the recent openings of several dining destinations led by restaurateurs and world-famous chefs, such as Nobu, Bobby’s Burgers by Bobby Flay, The Bedford by Martha Stewart and Vanderpump à Paris.

 

Weekend marquee events will have adjusted starting flights during the 2024 WSOP. The events will now have either three starting flights Friday through Sunday or four starting flights Thursday through Sunday. This change results in popular events such as Monster Stack, Millionaire Maker, and Colossus now having three starting flights. Additionally, Mega Satellites will now be played as “Landmark Mega Satellites,” where participants will accumulate a certain amount of chips (e.g., 10x starting stack) to win a seat in the respective event.

 

Daily Deep Stack tournaments will run every day from May 28 to July 16, with buy-ins ranging from $200 to $400. In addition, Daily Landmark Mega Satellites will happen from May 28 to July 15 with buy-ins starting at $135 and topping off at $25,000.

 

Main Event Maynia, the WSOP’s official guaranteed seat-qualifier series, returns in 2024, providing another way to qualify for the 2024 WSOP through land-based satellites at official partner casino resorts and card rooms throughout the country and the world. Participating locations include the Horseshoe St. Louis, Grand Victoria Casino Elgin, Harrah’s Cherokee, Horseshoe Tunica, Harrah’s Pompano Beach, Thunder Valley Casino Resort, Turning Stone Resort Casino, Horseshoe Las Vegas, Foxwoods Resort Casino, and Graton Casino and Resort.

 

PokerGO, the world’s largest poker content company and streaming platform, returns as the official livestream and production partner of the WSOP. 


 

MainEventTravel.com can help you with all your Vegas travel needs – from our comprehensive Flight Bookings to securing Hotel Rooms on the Vegas Strip or anywhere in town! 

 


 

Click here for the entire WSOP 2024 bracelet schedule on MainEventTravel.com.

 

 

Whatever your plans for this year's World Series of Poker don’t forget that MainEventTravel.com offers a one-stop travel service with everything you need for your trip to Sin City.

Photo Credit: WSOP,  WORLD SERIES OF POKER

“WORLD SERIES OF POKER and associated logos and designs are trademarks and service marks of Caesars Interactive Entertainment, LLC. Main Event Travel is not affiliated in any way with Caesars Interactive Entertainment, LLC or the World Series of Poker.”

 

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.