0.0006 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0102 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-24' AND `url` = 'https://www.maineventtravel.com/pages/page/malta-madness' ORDER BY `views` DESC

0.0016 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/pages/page/malta-madness', 1, '2024-04-24')

0.0005 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.0007 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.0120 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.0011 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.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` = 'page'

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`.`url_name` = 'malta-madness'

0.0002 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%/page/malta-madness%'

English

Malta Madness Luxon Pay


Malta Madness

Promotion is valid on PRE-PAID ACCOMODATION purchases only made online at MainEventTravel.com to stay in Malta now until the end of April 2024 for the Malta Poker Festival, EAPT Malta or Battle of Malta on hotels booked for 4 nights or more. 

Example: The accommodation portion of the purchase of a 5 day Malta Poker Festival Accommodation + Main Event Buy-in Package is eligible, the value of the buy-in amount is not eligible

The promotion is only valid on purchases made using Luxon Pay at checkout.

Credit will not be applied to any portion of purchase made with credit or debit card, or money on account.

Example: Customer using £300 money on account and £700 via Luxon Pay at checkout on £1000 (4 night hotel stay in Malta for MPF, BOM or EAPT) purchase will receive travel credit in the amount of £35 (£700 x 5%)

A travel credit of 5% will be applied to your account based on the purchase total of any pay now hotels that are booked for 4 or more days for MPF, BOM or EAPT 2024 that are made during the period of 00:01 UTC (12:01am) 21st March 2024 through 0:00 UTC (12pm midnight) 27th March 2024.

5% travel credit will be applied to your account on completion of travel booked during the promotional period outlined above.

Travel credit will be added to customer’s MainEventTravel.com account for online bookings within 3-5 days of completion of travel made during promotional period outlined above.

Example: Customer books 5 nights at Hilton Malta for MPF Irish Open 24th – 29th April 2024 for €1100 using Luxon Pay at checkout. Customer is eligible for €55 future travel credit. Travel credit is added to customer’s account within 3-5 days from 29th April 2024, trip completion date.

There is no limit on the number of purchases, all purchases made during the promotional period as outlined above are eligible, and all travel credits will be added to customer accounts as outlined above.

Travel credit is transferable by means of request in writing.

Travel credit has no cash value

Travel credit awarded can be used to purchase pre-paid hotels and flights only, purchase of Gift Vouchers or Buy-ins will be cancelled and refunded.

Travel credit has no expiration date.

Gift Vouchers and Buy-ins are excluded in entirety from the promotion.

 

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.