0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0063 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-06-21' AND `url` = 'https://www.maineventtravel.com/pages/page/Luxon-Pay-Irish-Portugal-Adventure-5-Travel-Credit-Terms-and-Conditions' ORDER BY `views` DESC

0.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/pages/page/Luxon-Pay-Irish-Portugal-Adventure-5-Travel-Credit-Terms-and-Conditions', 1, '2024-06-21')

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.0063 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.0005 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.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` = 'Luxon-Pay-Irish-Portugal-Adventure-5-Travel-Credit-Terms-and-Conditions'

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%/page/Luxon-Pay-Irish-Portugal-Adventure-5-Travel-Credit-Terms-and-Conditions%'

English

Luxon Pay IPT 5% Travel Credit T&Cs


Luxon Pay Irish Poker Tour Portugal Adventure 5% Travel Credit Terms and Conditions

Promotion is valid on pre-paid flight and accommodation purchases only made online at MainEventTravel.com. Pay Hotel, Buy-ins, and Gift Vouchers are excluded.

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 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 flights or pay now accommodation made before 0:00 UTC (12pm midnight) 23rd May 2024 for travel to Portugal in June 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 Aqualuz Troia Mar by Editory for the IPT Portugal Adventure from 19th – 24th June 2024 for €1500 using Luxon Pay at checkout. Customer is eligible for €75 future travel credit. Travel credit is added to customer’s account within 3-5 days from 24th June 2024, trip completion date.

The 5% travel credit applies to all bookings meeting the above criteria 

Travel credit is transferable by means of request in writing.

Travel credit has no cash value. 

Travel credit has no expiration date.

Gift Vouchers and Buy-ins are excluded from the promotion

Luxon Pay can be used at checkout for any Pay Now (Pre-paid) Hotels, Flights and Packages available on MainEventTravel.com

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.