0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0072 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-22' AND `url` = 'https://www.maineventtravel.com/pages/page/DTD-EAPT-UK-Package-Giveaway' ORDER BY `views` DESC

0.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/pages/page/DTD-EAPT-UK-Package-Giveaway', 1, '2024-12-22')

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.0037 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.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` = '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` = 'DTD-EAPT-UK-Package-Giveaway'

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%/page/DTD-EAPT-UK-Package-Giveaway%'

English

DTD EAPT UK Package Giveaway


Prize

The winner will receive:

DTD EAPT UK Package Giveaway worth £500

Includes the £340 Buy-In Luxon Pay Mystery Bounty and £160 MET Travel Credit

Eligibility

This giveaway is open to applicants aged 18 years and over.

Employees, contractors, ambassadors, and family members of employees of MainEventTravel.com and Dusk Till Dawn are not eligible to apply; entries and wins found to be as such will be declared null and void.

By entering the giveaway, participants acknowledge and agree to the terms and conditions of Dusk Till Dawn, including any age and location restrictions applicable to their services.

To be eligible for the prize, the winner must create an account with MainEventTravel.com and Dusk Till Dawn Venue. Failure to create an account will result in forfeiture of the prize.

Upon attending Dusk Till Dawn, the winner is required to present valid identification (ID) for verification purposes. Failure to provide valid ID may result in forfeiture of the prize or refusal of entry to the venue.

The prize and travel credit are non-transferable, non-refundable, and cannot be exchanged for cash or an alternative. The MainEventTravel.com travel credit will be deposited 48 hours into the winners account after the acceptance of the prize. It can only be used on Pay Now Hotels and flight reservations. If there is unused credit on the account, this can be used towards other Pay Now Hotel bookings or flight reservations and there is no expiry date in use of the credit.

Entry Method

Participants must like the MainEventTravel.com ‘Offers and Promotion’s Group’ on Facebook, Like the Luxon Mystery Bounty Package Giveaway Post pinned at the top of the group page and share the post and comment ‘Shared’.

The shared post must be public and be able to be viewed on your Facebook page, if this is private and unable to see, the entry will not be included in the giveaway.

Only one entry per person is permitted.

Entries that are incomplete, or submitted outside of the specified timeframe will not be accepted.

Any entries deemed to be inappropriate, offensive, or slanderous may be disqualified at managements discretion.

By entering the giveaway, participants agree to abide by these terms and conditions and any other instructions provided by MainEventTravel.com.

Changes & Disruptions

MainEventTravel.com reserves the right to modify the giveaway period at its discretion, in which case the revised dates will be communicated via Facebook.

Any changes to the giveaway period will be made in accordance with the terms and conditions, and all eligible entries received before any modification will still be considered valid.

In the event of unforeseen circumstances or causes beyond MainEventTravel.com's control, including but not limited to technical issues, force majeure events, or disruptions imposed by third-party platforms, MainEventTravel.com may, at its discretion:

  1. Modify, suspend, or terminate the giveaway without prior notice.
  2. Disqualify any entries or participants who violate these terms and conditions or engage in fraudulent or unfair practices.
  3. Determine alternative methods for prize allocation or distribution, if applicable.

 Giveaway Period

The giveaway will end at Sunday 12th May at midnight UTC.

Entries received after the end date will not be considered.

All times and dates are subject to MainEventTravel.com’s local time zone (UTC)

Prize Winner

The winner will be selected at random from all eligible entries.

The draw will take place on Facebook Live at 16:00 on Monday 13th May UTC). The winner will be notified via Facebook by direct message.

The winner must acknowledge receipt of the notification and accept the prize within 48 hours. If there is no acknowledgment or acceptance within this timeframe, the prize will be deemed invalid, and the promotion made null and void.

The winner must agree to wear a MainEventTravel.com patch prominently during any official events or activities associated with the prize.

Publicity

By entering, participants agree to participate in any publicity which can include news feature, social media posts and promotional activities related to the giveaway.

Any personal data or content provided may be used for promotional purposes.

 Liability

MainEventTravel.com is not liable for any loss, damage, or injury resulting from participation in the giveaway or acceptance of the prize.

Participants indemnify MainEventTravel.com against any claims, damages, liabilities, or expenses arising out of their breach of these terms.

MainEventTravel.com shall not be liable for any failure to perform its obligations under these terms and conditions where such failure results from any cause beyond its reasonable control, including but not limited to acts of God, natural disasters, war, terrorism, strikes, or governmental restrictions.

 

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.