0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0059 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-05-02'
AND `url` = 'https://www.maineventtravel.com/pages/page/IPT-Portugal-Adventure-X-Giveaway'
ORDER BY `views` DESC

0.0082 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-05-02'
AND `url` = 'https://www.maineventtravel.com/pages/page/IPT-Portugal-Adventure-X-Giveaway'

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.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` = 'tour'

0.0002 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.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` = 'IPT-Portugal-Adventure-X-Giveaway'

0.0001 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%/page/IPT-Portugal-Adventure-X-Giveaway%'
English
  1. Home
  2. IPT Portugal Adventure X Giveaway

IPT Portugal Adventure X Giveaway


IPT Portugal Adventure X Giveaway

 

Giveaway 

The winner will receive:

Irish Poker Tour Portugal Adventure Package worth €1700.

The package includes:

  •  One (1) Entry to the €700 Buy-in Main Event with €250k GPP
  • Five (5) Nights at the luxurious 4* Aqualuz Troia Mar Single Occupancy B&B 19th – 24th June
  • €275 MainEventTravel.com Travel Credit towards Flight or Hotels

 

Eligibility

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

Employees, contractors, ambassadors, and family members of employees of MainEventTravel.com and Irish Poker Tour 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 Irish Poker Tour and Casino Troia, 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 Casino Troia. Failure to create an account will result in forfeiture of the prize.

Upon attending Casino Troia, 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 follow the MainEventTravel.com X (Twitter) Page, Like the giveaway post pinned at the top of the page and share the post and tag 2 of your favourite poker players.

The names of your favourite poker players will be valid when they turn blue.

MainEventTravel.com and 3rd party suppliers take no responsibility for entries that cannot be verified due to an individual’s privacy settings on X (Twitter), entries that cannot be verified may 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 related to the giveaway.

 

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 Twitter.

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:

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

 

Entry Period

The giveaway will end on Thursday 25th April 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 15:00 on Friday 26th April (UTC). The winner will be notified via Twitter 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.

The winner of this giveaway will be required to confirm their preferred Day 1 entry within 48 hours of acceptance of prize.

 MET reserves the right to exclude entry to players who have 1) won a MainEventTravel.com promotion within the last 6 months and 2) have not adhered to Ts & Cs on this or a previous occasion 

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.

 

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
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.