0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-dev`

0.0210 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-05-11' AND `url` = 'https://dev.maineventtravel.com/destination/articles/las-vegas-guide/day-trips-from-Vegas' ORDER BY `views` DESC

0.0302 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-05-11' AND `url` = 'https://dev.maineventtravel.com/destination/articles/las-vegas-guide/day-trips-from-Vegas'

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` = 'dev.maineventtravel.com'

0.0002 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0003 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` = 'dev.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` = 'dev.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.0024 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.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`.`active` = '1'

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` = 'dev.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.0008 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` = 'day-trips-from-Vegas'

0.0001 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` = '521'

0.0018 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`

  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found
English
Thursday 3rd May, 2018

Beyond the Strip – day trips from Vegas

By Mad Harper

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.

Red Rock Canyon – more and more poker players are discovering Red Rock Canyon, a stunning national park only 25 miles from the Strip. You can rent a car or arrange a shuttle trip with local tour operators. The Red Rock scenic loop is 13 miles long and there are more than 10 easy hikes around the amazing natural rock formations. You can even gamble on your way there or back - at Red Rock Casino.

Grand Canyon – Measuring approximately 277 miles long, up to 18 miles wide and a mile deep, the Grand Canyon has been six million years in the making and is definitely one of the most spectacular sights on earth. Although visiting the Grand Canyon by car would make for a very long day trip (it’s about five hours to the South Rim) there are dozens of tour operators in Vegas offering helicopter rides which last take about four hours door-to-door from your hotel. Longer trips can include taking in Lake Mead and Hoover Dam as well, along boat trips down the Colorado River

Lake Mead – Lake Mead is one of the biggest man-made lakes in the world, and lies about 30-45 minutes’ drive from the Strip. It’s a perfect place to chill out after a hard few days at the poker tables, with a ton of activities on offer including swimming, boating, fishing, jet skiing and hiking. With 820 miles of shoreline, there are plenty of beach areas for lounging around and picnicking.

Hoover Dam - Hoover Dam is located in Black Canyon, just 30-40 minutes outside of Las Vegas and you can easily combine a trip to Lake Mead with a visit to this National Historic Landmark. The enormous, 726 feet high curved wall is an amazing feat of engineering which took five years to build – from 1931 to 1936. It was the largest dam of its kind at the time and is still the highest concrete dam in the Western Hemisphere.

Valley of Fire - Valley of Fire is about an hour northeast of the Strip and Nevada’s oldest and largest state park. This epic landscape is world-renowned – for its 40,000 acres of bright red Aztec sandstone outcrops, ancient, petrified trees and petroglyphs dating back more than 2,000 years. The trip there and back is spectacular, taking you through the heart of the Nevada desert.



What's Hot in Las Vegas


Events

Your search results are valid for . Go to checkout 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.