0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0065 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/pages/page/londonpokerfestivalmysterybountypackage'
ORDER BY `views` DESC

0.0006 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/pages/page/londonpokerfestivalmysterybountypackage', 1, '2024-11-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.0035 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` = 'londonpokerfestivalmysterybountypackage'

0.0001 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%/page/londonpokerfestivalmysterybountypackage%'
English
  1. Home
  2. London Poker Festival Mystery Bounty Package Giveaway

London Poker Festival Mystery Bounty Package Giveaway


Giveaway 

The winner will receive:

This London Poker Festival Mystery Bounty Giveaway includes:

  • One (1) Entry to the £500 (£200 + £250 + £50) Mystery Bounty Day 1B 4th September
  • One (1) night bed and breakfast single occupancy Hotel room nearby Aspers 4th September

 

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 Aspers, 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 Aspers. Failure to create an account will result in forfeiture of the prize.

Upon attending Aspers, 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 is non-transferable, non-refundable, and cannot be exchanged for cash or an alternative.

 

Entry Method

Participants must

·       FOLLOW MainEventTravel on X

·       SHARE the pinned OFFICIAL GIVEAWAY POST from MET's X page to your own X page

·       TAG a poker player below the OFFICIAL GIVEAWAY POST on MET's X page

·       Entries close at midnight on Monday 5th August UTC, winner will be selected via live random draw on Wednesday 7th August. 

Please note: Your entry is eligible when the OFFICIAL GIVEAWAY POST appears on your X page for everyone to see (please check your privacy settings) and there is a name highlighted in your comment under OFFICIAL GIVEAWAY POST to let us know you have completed your entry.

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 close on Wednesday 7th August at midnight BST

Entries received after the end date will not be considered.

All times and dates are subject to MainEventTravel.com’s local time zone BST

 

Prize Winner

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

The draw will take place on Facebook Live at on Friday 9th August BST. 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.

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 

MET will book a suitable hotel for the winner for 1 night 4th September or the winner can collect £100 MET Travel Credit.

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.