0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0065 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-24' AND `url` = 'https://www.maineventtravel.com/news/article/WSOP-Payout-Changes-and-METs-FinalTableFreeroll' ORDER BY `views` DESC

0.0091 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/news/article/WSOP-Payout-Changes-and-METs-FinalTableFreeroll', 1, '2024-11-24')

0.0004 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.0005 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.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.0002 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0005 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.0037 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.0129 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.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` = '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.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.0034 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.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.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` = '19' 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.0063 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.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.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` = '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.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.0246 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.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.0039 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.0032 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.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` = '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.0083 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.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.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.0018 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-Payout-Changes-and-METs-FinalTableFreeroll'

0.0008 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-11-24' AND `news_articles`.`active` = '1' ORDER BY `DATE` DESC, `id` DESC LIMIT 5

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

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

English
Thursday 23rd May, 2024

WSOP Payout Changes and MET's FinalTableFreeroll

By Kelly Saxby

New payout structures have been announced for WSOP 2024, giving players who make the money but miss out on deep runs and the Final Table more value than previous years.

Some players will welcome this news, particularly those who consistently min-cash, as spreading the love further through the field can benefit the poker economy. So can MainEventTravel!

Players at the top will feel a pinch, but MainEventTravel.com is already positioned to add value to all WSOP Live Event Final Tablists with the exclusive  #FinalTableFreeroll promotion. 

MET’s #FinalTableFreeroll promotion gives Poker Travelers the chance to win back up to 100% of Tournament Travel booked with MainEventTravel.com.

Once booked entering is as easy as 1, 2, 3… 

Step 1) Tag MainEventTravel.com on Facebook or X in a post any time before the first Day 1 of the Eligible Event telling us which festival you booked to attend.

Step 2) Make the Official Final Table!

Step 3) Tag MainEventTravel.com with a pic of yourself before the Official Final Table of an Eligible Event begins using #FinalTableFreeroll

When you are ready to redeem your Travel Credit Let us know your finishing place and we will transfer your travel credit!

Use @MainEventTravel.com on Facebook Use @MainEventTravel on X

Terms & Conditions apply. To view all Eligible Events and for full Ts & Cs visit our Promotions page >>> https://maineventtravel.com/pages/page/FinalTableFreeroll

Don't wait, book your WSOP Travel with MainEventTravel.com and you could Freeroll your next trip!

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