0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0071 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-10-15' AND `url` = 'https://www.maineventtravel.com/pages/page/Main-Event-Travel-Gift-Vouchers' ORDER BY `views` DESC

0.0006 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/pages/page/Main-Event-Travel-Gift-Vouchers', 1, '2024-10-15')

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.0066 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.0004 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 `pages`.*, `parents`.`url_name` as `parent_url_name` FROM `pages` LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id` WHERE `pages`.`url_name` = 'Main-Event-Travel-Gift-Vouchers'

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%/page/Main-Event-Travel-Gift-Vouchers%'

English

Main Event Travel Gift Vouchers


Gift Vouchers can be purchased in GBP, USD, and EUR in multiples of 25, 50, 100, 250, 500, and 1000 and will be credited to the recipient’s account in the value and currency in which the purchase was made

Gift Vouchers can be used as full or partial payment towards Pre-Paid PAY Now Hotels and ATOL Protected Flights; as well as Pre-Paid Promotional Packages, Special Offers and Buy-ins where available.

Gift Vouchers cannot be used to purchase Pay Hotel rates where a payment card is taken directly by the hotel for payment reconciliation

Gift Vouchers have NO expiration date and NO exclusion dates

Gift Vouchers are non-refundable, non-transferable and have no cash value

Purchaser will need to create a MainEventTravel.com account to purchase Gift Vouchers

Recipient will need to register for a MainEventTravel.com account, if they do not already have one, in order to receive the Gift Voucher Credit Amount in their account

Once the Gift Voucher Credit Amount has been added to the receipents account, they can use at any time for a partial or full payment of Pre-Paid products and services as outline in the Ts & Cs

Purchase and Redemption

Purchaser will receive a Gift Voucher purchase confirmation email within minutes of purchase

Purchaser will receive a printable Gift Voucher by email within 72 hours of purchase (this is usually much quicker but can take up to 72 hours on weekends and bank holidays due to staffing)

Gift Vouchers will be sent as a PDF with the value, voucher number, inclusions, and expiration details prepopulated, and the Purchaser can personalize To, From, and Message.

Recipient will need to email info@maineventtravel.com quoting the voucher number and confirming the email address associated with your MainEventTravel.com account, value of the Gift Voucher will be credited to your account within 72 hours of request. If you do not have an account click here or head to MainEventTravel.com to register.

Once the Gift Voucher Credit Amount has been added to the Recipient’s account, they can use at any time for a partial or full payment of Pre-Paid products and services as outline in the Ts & Cs

Unused balances will remain in Recipient’s Account until used for purchase

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.