0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0086 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-02-05'
AND `url` = 'https://www.maineventtravel.com/pages/page/FinalTableFreeroll'

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.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

0.0002 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.0040 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.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.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. Vegas Final Table Freeroll

Vegas Final Table Freeroll


Win back up to 100% of Vegas Tournament Travel booked with MET this Summer! 

Book your Tournament Travel to Vegas 2025 and you could win back your travel costs in our social media promotion.

Entering is as easy as 1, 2, 3 ...

Step 1) Simply tag MainEventTravel on Facebook or X in a post any time before the first Day 1 of any Bracelet Event telling us which event you booked to attend.

Step 2) Make the Official Final Table!

Step 3) Tag MainEventTravel in a pic of yourself on socials before the Official Final Table of a Bracelet Event begins using #FinalTableFreeroll 

Win 100% - win a Bracelet Event and receive a future travel credit worth the full amount of your MET-booked travel!

Win 50% - make it to heads up and receive a future travel credit worth 50% of the amount of your MET-booked travel!

Win 10% - make it to the Official Final Table and you are ITC (that’s in the credit!) as you’ll receive a future travel credit worth 10% of the amount of your MET-booked travel!

Let us know your finishing place, once verified we will transfer your travel credit and you are ready to Freeroll Your Next Trip! 

Use @MainEventTravel.com on Facebook

Use @MainEventTravel on X

No additional cost to enter and multiple opportunities to win!

If you are playing multiple Bracelet Events be sure to post BEFORE EACH EVENT STARTS so you don’t miss the first Day 1.

Have a question? Email info@maineventtravel.com

Need a patch? Email info@maineventtravel.com

Terms & Conditions apply:

Eligible Travel
  1. ALL costs associated to flights and hotels booked to travel to and from an Eligible Event where:
  2. The booking was made in the name of the Poker Traveller who has made the Final Table
  3. Booking was made and paid in full any time up to 24 hours before the start of the day the Final Table of an Eligible Event falls on
  4. The player has completed the first leg of a return flight or one-way flight at time of Final Table
  5. The players has checked into a hotel 24 hours before day of the Final Table
  6. The costs associated to travel are non-refundable
  7. All travel must be to play Bracelet Events in Las Vegas between May 26th and July 18th 2025

Will make up the total amount of credit a player is eligible to win back the value of.

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.