0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0108 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-26' AND `url` = 'https://www.maineventtravel.com/destination/articles/las-vegas-guide/Win-a-travel-credit-worth-your-ENTIRE-2023-Las-Vegas-travel-costs-booked-with-Main-Event-Travel-com' ORDER BY `views` DESC

0.0012 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/destination/articles/las-vegas-guide/Win-a-travel-credit-worth-your-ENTIRE-2023-Las-Vegas-travel-costs-booked-with-Main-Event-Travel-com', 1, '2024-04-26')

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

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

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' 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 `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0116 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.0010 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.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.0026 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` = 'Win-a-travel-credit-worth-your-ENTIRE-2023-Las-Vegas-travel-costs-booked-with-Main-Event-Travel-com'

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

0.0071 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
Sunday 28th May, 2023

Win a travel credit worth your ENTIRE 2023 Vegas travel costs booked with MainEventTravel.com this Summer

By Mad Harper

MainEventTravel.com is running an incredible promotion for players heading to Las Vegas this Summer offering you the chance to Freeroll your Vegas travel next year! 

The MainEventTravel.com #FinalTableFreeroll promotion is completely free to enter and covers all LIVE bracelet events at the Horseshoe or Paris Casinos during May, June or July. There’s no caveat on buy-in amounts or limits regarding the cost of your trip; we’ll be giving you a travel credit worth the FULL AMOUNT of your MET-booked travel if you WIN a live bracelet event wearing our patch and tag your post on our social media channels with #FinalTableFreeroll on the day of the final table.

If you don't win the bracelet, don't worry, we’ll still give you a % back for getting heads-up, and just for making an FT. 

All you have to do before the event starts is ensure you have a MainEventTravel patch to wear. (Just get in touch with us at lasvegas@maineventtravel.com and we can send you some – or you can get some from a MainEventTravel rep once you’re in Vegas.)

How to win!

Make the final table of a LIVE bracelet event and you’re quids in – we’ll be awarding you a MET travel credit worth 10% of your entire travel costs. But don’t stop there! Make it to heads-up and you’re bagging a 50% travel credit and, if you win the event, you’ll get a travel credit worth the entirety of your Vegas travel booked with MET for Summer 2023.

The promotion covers ALL your accommodation and flight bookings made with MainEventTravel for any Vegas trip travelling in May, June or July 2023 (you can book months in advance or the week you fly). This could be multiple different trips so if you plan to fly home at some point and then head back to Vegas again, all your flights to/from Vegas booked before your official FT – and all your hotel accommodation during this period – are included in the promotion.

You can also amend your booking at any time before reaching the final table so, if you’re running hot on Day 3 of a five-day event and fancy extending, that extra cost will also be included. ALL your travel costs booked up to 24 hours before the Official Final Table announcement are included. It’s fine if you’re sharing your room – the promotion covers your full room booking in your name and flights booked in your name, but what isn’t included are any reservations that you’ve made on behalf of other people or purchases made using a travel credit received as part of a package from a third party or received as a promotional credit.

The exclusive MainEventTravel.com promotion gives players loads of opportunities to win in Vegas this Summer and is all part of our aim to offer players as much #AddedValue as possible for all your #PokerTravel.

All players have to do is:

1) Grab a MET patch before the Final Table starts

2) Post a pic of yourself wearing your MET patch on POST PINNED TO THE TOP OF MainEventTravel’s Twitter or Facebook on the day of your FT, tagging @MainEventTravel and using the hashtag #FinalTableFreeroll

The #FinalTableFreeroll promotion is the biggest MainEventTravel has ever run and part of its mission to add as much value as possible for its poker-playing clients. Hundreds of players use MainEventTravel.com every Summer to sort out their Vegas trips and benefit from our team’s expert knowledge and years of experience in booking Vegas travel.

The MET team will be keenly monitoring social media throughout May, June, and July to spot players doing well and cheer them on. 

Fancy a chance to win MET travel credit whether you play or not? Post a pic of yourself wearing a MET patch from ANYWHERE in Las Vegas in May, June, or July 2023 on the Final Table Freeroll post pinned to the top of Facebook or Twitter tagging @MainEventTravel using #BookTravelWithMET and you’ll be entered into a live random drawing taking place 31st July to win up to $500 Travel Credit*. We don't even mind if you didn't book your 2023 Vegas trip with us this year, ANYONE can take part.

Kelly, MET Retail Sales & Marketing Consultant, said: “This is such a great promotion. For starters, it’s free! And also it doesn’t matter whether you’re a seasoned pro planning a mega-stay in Vegas or a recreational player who’s only over for a week or so – whatever your travel costs, you’re eligible. Players could end up winning travel credits worth thousands of dollars depending on how luxe their flights and hotels are for Summer 2023. Even for those players that don’t make a final table in one of the live bracelet tournaments, it’s still worth sporting the MET patch and tagging us with #BookPokerTravelWithMET because you could win a travel credit for next summer - or anytime - worth up to $500 in our live draw at the end of July.”

Please note that we aren’t coughing up MORE than 100% of the value of your Summer 2023 Vegas booking, so once you’ve won an event, made it to heads-up twice, or reached ten final tables, that’s it! You can stop being so successful now – you’re freerolling!

View the full #FinalTableFreeroll Terms & Conditions that apply here.

*View the full #BookTravelWithMET Terms & Conditions that apply here.  

Whatever your plans for this summer in Vegas, don’t forget that MainEventTravel.com offers a one-stop travel service with everything you need for your trip to Sin City.

If you haven’t booked your travel yet, CLICK HERE to head to MainEventTravel.com and check out great rates at Paris Las Vegas & Horseshoe Las Vegas. We also have some fantastic offers at The Linq, Hilton Club Polo Towers, Treasure Island, OYO, Tropicana, and more. Or if you want to go LUXE check out The Cromwell, Caesars Palace, Nobu, or Bellagio. No matter your budget, we have hotel options close to the action on The Strip to suit.

Please note, most casino hotels charge resort fees on arrival, and these are estimated for you in the booking confirmation.

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


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.