0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0080 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-02-03'
AND `url` = 'https://www.maineventtravel.com/pages/page/Kings-of-Tallinn-Terms-Conditions'
ORDER BY `views` DESC

0.0110 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-02-03'
AND `url` = 'https://www.maineventtravel.com/pages/page/Kings-of-Tallinn-Terms-Conditions'

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.0038 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.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` = 'Kings-of-Tallinn-Terms-Conditions'

0.0001 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%/page/Kings-of-Tallinn-Terms-Conditions%'
English
  1. Home
  2. Kings of Tallinn Giveaway T&Cs

Kings of Tallinn Giveaway T&Cs


Giveaway Terms & Conditions

Prizes

  • Two winners will each receive one €555 entry to the Kings of Tallinn Championship Event.
  • The prize cannot be transferred, refunded, or exchanged for cash.

Who Can Enter?

  • Open to individuals aged 18 or over.
  • Employees, contractors, ambassadors, and family members of MainEventTravel.com and Kings of Tallinn/OlyBet cannot enter.
  • Winners must create accounts with MainEventTravel.com and Kings of Tallinn/OlyBet to claim the prize.
  • To enter Olympic Park Casino, winners must show valid ID—failure to do so may result in loss of the prize.

How to Enter

There are two ways to win:

1. Facebook Giveaway

  • Follow MainEventTravel Offers & Promotions Poker Travel.
  • Like and share the Official Giveaway Post.
  • Like both Main Event Travel and Olybet Facebook Page

2. Booking with Main Event Travel

  • One winner will be randomly selected from those who book travel with MainEventTravel.com for the giveaway dates.

Entry Deadline & Winner Selection

  • Entry Start Date: 3rd February
  • Entries close: Midnight on 14th February.
  • Winners announced: 17th February, selected at random.
  • Winners will be notified via Facebook direct message and must respond within 48 hours to claim their prize.
  • If a winner does not respond in time, the prize will be forfeited.

Rules & Restrictions

  • Only one entry per person per post is allowed.
  • Incomplete, late, or unverifiable entries (due to privacy settings) will not be counted.
  • Entries that are offensive, inappropriate, or defamatory may be disqualified.
  • Winners must wear a MainEventTravel.com patch during event activities.
  • If a winner has already won a MainEventTravel.com giveaway in the last six months, they may be excluded.

Changes & Cancellations

  • MainEventTravel.com reserves the right to modify, suspend, or cancel the giveaway due to unforeseen circumstances, including:
    • Technical issues
    • Third-party disruptions
    • Events beyond their control (e.g. weather, strikes, etc.)
  • Any changes will be announced on Facebook.

Publicity & Liability

  • By entering, participants agree to take part in promotional activities (e.g. social media posts, news features).
  • Any personal data provided may be used for marketing purposes.
  • MainEventTravel.com is not responsible for any loss, damage, or issues resulting from participation or use of the prize.
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.