0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0060 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-05-19' AND `url` = 'https://www.maineventtravel.com/tour/unibet-uk-poker-tour' ORDER BY `views` DESC

0.0080 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-05-19' AND `url` = 'https://www.maineventtravel.com/tour/unibet-uk-poker-tour'

0.0004 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.0002 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0079 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.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'unibet-uk-poker-tour'

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'unibet-uk-poker-tour'

0.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = '69'

0.0013 SECONDS:
SELECT tour_stops.*, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image FROM `tour_stops` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE tour_stops.end_date > CURDATE() AND tour_stops.active = 1 AND `tour_id` = '69' ORDER BY `tour_stops`.`start_date` ASC

0.0073 SECONDS:
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name` FROM `news_articles` LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id` WHERE `news_articles`.`active` = '1' ORDER BY `news_articles`.`date` DESC

0.0007 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` = 'news'

0.0005 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0003 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

Unibet UK Poker Tour


*IMPORTANT* See below the following statement:

UNIBET CHANGES LIVE POKER EVENTS VENUES FOR 2020

London, UK – April 27, 2020 – Unibet today announced their decision to move all land-based poker events into their online poker room for the remainder of 2020.

This decision is relevant to the Unibet Open events; the games are not cancelled, but they will be re-homed within the independent online poker client.

“This is not a decision we have taken lightly,” said Head of Events, Nataly Sopacuaperu, “we fully understand the impact to our partners and the land-based venues, however, as a priority, we must consider not only the health of our customers but also the difficulty for recreational players with regards to planning trips around uncertainty.”

By making this decision firmly and early, ahead of knowing what the global situation will be in a few months, Unibet can ensure that Unibet Open fans can play an alternative to the live calendar events that they expect from the comfort of their own home, without risking lost money on flights or accommodation bookings.

Unibet is a poker operator that concentrates focus on recreational players and understands that poker is a hobby for many Unibet live-event regulars; the teams involved had to conclude that confirming the games, but moving them into a digital venue was the best option for most players.

In March, Unibet made the decision to combine the planned Unibet Open Tallinn with the Unibet Online Series VIII, creating a special €1 Million guaranteed series running from May 1st with 132 events, culminating with the €1100 buy-in Unibet Open Main Event on 24th May.

Today’s announcement is the logical continuation of their philosophy of being proactive in the face of adversity.

Staying true to their recreational roots, Unibet teams are already planning how to bring the fun associated with the land-based product to the online world, over and above the tournaments, and ideas are welcome from players via the Unibet community forum, where players can talk directly to senior members of the poker team.

The Unibet Poker teams know that their growth and success over the years is entirely due to the loyalty and support of their players, and it has always been the strategy to communicate openly and clearly.

“We know some people will be disappointed, the team here certainly is, we love the live events!” said Head of Poker, Kristoffer Bergvall, “That said, we are all in agreement that this is the best way to ensure the consistency and reliability that people have come to expect from our product, and the online room is better equipped than ever to house our land-based fans.”

As Europe prepares to return to a new version of normal, Unibet Poker prepares to do the same.

Upcoming Tour Stops


Sorry, we have no tour stops currently scheduled for Unibet UK Poker Tour.
Please check back soon, or subscribe to our newsletter.
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.