0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

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.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.0041 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 in helping travellers live the dream in fabulous Las Vegas! Let us help you book your trip today - and then you can get on with planning all the exciting things you want to do when you get there. Whether you’re a seasoned pro or a Vegas first-timer, we'll help you find the right hotel-and-flights combo to suit both your plans and your budget.  

Not sure how to get there or where to stay? Contact our expert team for advice.

 

What's Hot in Las Vegas

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.