0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0073 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-04-08'
AND `url` = 'https://www.maineventtravel.com/destination/guide/las-vegas-guide'
ORDER BY `views` DESC

0.0118 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-04-08'
AND `url` = 'https://www.maineventtravel.com/destination/guide/las-vegas-guide'

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

0.0042 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 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.0041 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.0002 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`

0.0002 SECONDS: 
SELECT `uapi_airports`.*, `uapi_cities`.`name` as `city`, `uapi_countries`.`name` as `country`
FROM `uapi_airports`
JOIN `uapi_countries` ON `uapi_countries`.`country_code` = `uapi_airports`.`country_code`
JOIN `uapi_cities` ON `uapi_cities`.`city_code` = `uapi_airports`.`reference_city`
WHERE `airport_code` = 'LAS'
English
  1. Home
  2. Destination Guide - Las Vegas
Destination Guide Las Vegas

The MainEventTravel.com team has over two decades of experience helping travellers live the dream in fabulous Las Vegas! Whether you’re heading to Sin City for a poker tournament, a bucket-list holiday, or a high-energy weekend, we make planning your trip easy and hassle-free.

Las Vegas offers world-class casinos, five-star resorts, Michelin-star dining, thrilling entertainment, and an unbeatable nightlife scene—and we’re here to ensure you experience it all in style. Whether you're a seasoned pro looking for the perfect poker getaway or a Vegas first-timer ready to explore everything the city has to offer, we’ll help you find the ideal hotel-and-flight combo to match your itinerary and budget.

Need help deciding where to stay or how to get there? Our expert team knows all the best locations, deals, and insider tips to make your Las Vegas adventure unforgettable. Contact us today and let Main Event Travel take care of the details—so you can focus on enjoying the trip of a lifetime!

What's Hot in Las Vegas

The 2025 World Series of Poker The World Series of Poker (WSOP) is back for its 56th edition, set to take place from May 27 to July 16, 2025, at Horseshoe Las Vegas and Paris Las Vegas. This summer’s series promises to be bigger than ever, with an unprecedented 100 bracelet events, including a mix of classic tournaments and exciting new additions.
#FinalTableFreeroll Returns for Summer 2025 – Win Back Your Tournament Travel! Main Event Travel is bringing back the #FinalTableFreeroll – Viva Las Vegas Edition for summer 2025! If you're heading to Las Vegas for Eligible Bracelet Events between May 27th and July 16th, you could win back up to 100% of your MET-booked travel costs!
Las Vegas Hotel Lowdown It’s said that there are more hotel rooms in Las Vegas than in any other city in the world –130,000 and counting – so you’ll be spoilt for choice when you head to Sin City
Beyond the Strip – day trips from Vegas With so much to do in Las Vegas itself, it can be hard to find time to explore beyond the city’s borders. However, even if you only have an afternoon spare, it’s well worth renting a car and heading out of town. Las Vegas is surrounded by stunning scenery and places like Lake Mead Hoover Dam and Red Rock Canyon are within easy driving distance.
Vegas on a Budget For a city full of so much glitz and glam, there are a surprising number of things you can do totally for free in Las Vegas, as there are plenty of free attractions dotted throughout the city.
Main Event Travel's Vegas Guide: The Linq Promenade Of all the many newish attractions in Vegas, the Caesars-owned LINQ Promenade has proved one of the most successful: an appealing, tree-lined open-air pedestrian walkway featuring tons of shops, restaurants, bars and attractions.

Events

Travel Search

Your trip starts here...
Search anywhere using the form below, click here to search for events, or have a look at the calendar to see what's on!
Flights
From
To
Cabin Class & Travellers
1 Adult, Economy
Hotels
Staying near
Rooms
Guests
1 Adult


Rates
Dates of Travel
Dates of Travel Close
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.