0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0065 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-04-07'
AND `url` = 'https://www.maineventtravel.com/pages/page/FinalTableFreeroll'
ORDER BY `views` DESC

0.0007 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/pages/page/FinalTableFreeroll', 1, '2025-04-07')

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

0.0002 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`.`url_name` = 'FinalTableFreeroll'

0.0001 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%/page/FinalTableFreeroll%'
English
  1. Home
  2. #FinalTableFreeroll – Viva Las Vegas

#FinalTableFreeroll – Viva Las Vegas


Win Back Up to 100% of Your Tournament Travel with MET!

Playing in Las Vegas this summer? Book your travel with Main Event Travel and you could win back your costs in our #FinalTableFreeroll – Viva Las Vegas Edition!

How to Enter in 3 Easy Steps:

1 Tag Us: Before, or during, the first Day 1 of your Eligible Bracelet Event (between May 27th and July 16th, 2025), post on Facebook or X, tagging @MainEventTravel and letting us know which event you’ve booked travel for.

2 Make the Official Final Table: Secure your spot at the final table of an Eligible Bracelet Event in Las Vegas.

3 Show Off Your Run: Before the Official Final Table begins, tag @MainEventTravel in a photo of yourself on social media using #FinalTableFreeroll to confirm your spot!

What You Can Win:

  • 100% Travel Credit – Win an Eligible Bracelet Event and receive a future travel credit equal to the full amount of your MET-booked travel.
  • 50% Travel Credit – Reach heads-up play and earn a travel credit worth 50% of your MET-booked travel.
  • 10% Travel Credit – Make the Official Final Table and receive a travel credit worth 10% of your MET-booked travel.

Once your placement is verified, your travel credit will be issued – it's that simple!

No Extra Costs & Unlimited Chances to Win!

♠ Only Eligible Bracelet Events in Las Vegas between May 27th and July 16th qualify.

♠ Book with MET and get rewarded for going deep!

Stay Connected:

Don’t miss your chance to Freeroll Your Next Trip with MET this summer!

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
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.