0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0098 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-19' AND `url` = 'https://www.maineventtravel.com/destination/articles/las-vegas-guide/Dollar-Delivery-service-2018' ORDER BY `views` DESC

0.0164 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-19' AND `url` = 'https://www.maineventtravel.com/destination/articles/las-vegas-guide/Dollar-Delivery-service-2018'

0.0006 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.0013 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.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` = '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.0031 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` = 'Dollar-Delivery-service-2018'

0.0003 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` = '289'

0.0074 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
Monday 30th April, 2018

Need cash in Vegas this summer? Check out our Dollar Delivery service

By Mad Harper

As we all know, it can be a major hassle sorting out large quantities of US dollars in Las Vegas every summer. No one wants to travel with wads of cash and trying to transfer or exchange money once you’re there can be a real headache.

To sort out your dollars this summer, and take advantage of our personal on-site delivery service, just email lasvegas@maineventtravel.com. With literally hundreds of tournaments taking place between May 30 and the end of July, there has never been a better time to visit “Sin City”.

As poker players ourselves, we know that getting your hands on your bankroll in cash is a #1 priority. At MainEventTravel, we have an easy and cost effective solution that can help you remove the difficulties of getting hold of dollars in cash in Vegas.

Even better, we offer a discount on our rate for everyone booking accommodation through MainEventTravel**.

Our bespoke Dollar Delivery service means that we will lock down a competitive rate for you whenever you want – and then deliver the cash to you, reliably, in person*. This means you no longer have to worry about carrying large quantities of cash and won’t be restricted to only getting a percentage of what you actually need!

We can accept funds in £ sterling (GBP) and/or Euros (EUR), convert it to dollars (USD) and hand over your money at a place and time that is convenient to you once you’re in Las Vegas.

No one wants to carry large amounts of cash to Vegas so our Dollar Delivery service is a real bonus for anyone holidaying or competing in Las Vegas this summer. It’s easy to set up – just contact us at lasvegas@maineventtravel.com with your contact details and we’ll give you an up to date and competitive quote**.

 *Initial bank transfers will require to be done by Wire Transfer and for new customers will require completion of Know Your Customer (KYC) data.

**For quantities between $10,000-$100,000 GBP > USD, our rate is the xe.com rate less 2%, covering transfer, conversion and personal delivery. This can be reduced to 1.5% for anyone booking rooms through MainEventTravel. For quantities above and below this rate (or non-GBP/EUR conversions) different rates apply.



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.