0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0091 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-22' AND `url` = 'https://www.maineventtravel.com/destination/articles/coventry-destination-guide/888poker-LIVEs-new-UK-Poker-League-starts-this-week' ORDER BY `views` DESC

0.0008 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/destination/articles/coventry-destination-guide/888poker-LIVEs-new-UK-Poker-League-starts-this-week', 1, '2024-11-22')

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.0003 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0005 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0005 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.0003 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

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

0.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0057 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 destinations.*, uapi_airports.name as airport_name FROM `destinations` LEFT JOIN `uapi_airports` ON `destinations`.`uapi_code` = `uapi_airports`.`airport_code` WHERE `url` = 'coventry-destination-guide'

0.0016 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 `url_name` = '888poker-LIVEs-new-UK-Poker-League-starts-this-week'

0.0002 SECONDS:
SELECT `news_categories`.* FROM `news_article_categories` LEFT JOIN `news_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` WHERE `news_article_categories`.`news_article_id` = '945'

0.0034 SECONDS:
SELECT DISTINCT tour_stops.*, tours.name as tour_name, ((ACOS(SIN(52.4128163 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(52.4128163 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((-1.5089521 - venues.map_longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance, venues.name as venue_name, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, tours.logo as tour_logo, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo FROM `venues` LEFT JOIN `tour_stops` ON `tour_stops`.`venue_id` = `venues`.`id` JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` WHERE `tour_stops`.`active` = '1' AND tour_stops.end_date > CURDATE() HAVING `distance` <= 10 ORDER BY `tour_stops`.`start_date` ASC

0.0003 SECONDS:
SELECT `news_articles`.`url_name`, `news_articles`.`main_image`, `news_articles`.`meta_description`, `news_articles`.`title` FROM `news_article_destinations` JOIN `news_articles` ON `news_article_destinations`.`news_article_id` = `news_articles`.`id` WHERE `news_articles`.`active` = 1 AND `destination_id` = 5 ORDER BY `news_article_destinations`.`display_order`

English
Tuesday 16th January, 2024

888poker LIVE’s new UK Poker League starts this week

By Mad Harper

There is already a huge buzz regarding the launch this week of 888poker LIVE’s new UK Poker League in Coventry. The £560 Main Event starts on Thursday with a bunch of other exciting side events on the schedule as well.

The UKPL is a series of live festivals that are taking place in various Grosvenor Casinos across the country. It’s the first time that 888poker LIVE has run a poker league in the UK. The new tour will have its own UKPL leaderboard and all points accumulated will also count towards Grosvenor’s acclaimed National Poker League.

In addition to the £560 Main Event, other tournaments on the UKPL’s debut event in Coventry include the £250 Opening Voyage with three starting flights, a £1,100 High Roller, the £400 Big Shot, £150 Seniors event and £200 Closer.

All Main Events will cost £560 to enter. In addition to the forthcoming Coventry festival, the new tour will also be heading to Edinburgh in February, Luton in March, Manchester in April, Leeds in August and London in September. The Grand Final will be held next October in Coventry.

MainEventTravel.com is the Official Travel Partner for Grosvenor and has a wide selection of hotels available in Coventry. Bag your room now to take advantage of lower rates – and make sure you get to stay exactly where you want.

Hotel Recommendations

Britannia Coventry: Even though the Britannia Coventry is a city centre hotel, it’s still only a 12-15 minute’ drive to the UKPL venue at the CBS Arena. Located in the heart of Coventry overlooking the cathedral, the Britannia is a great option if you’re after a more budget option. 

 

DoubleTree by Hilton Coventry: The DoubleTree by Hilton Coventry is a stylish option for your UKPL trip. Located just off the M6, it’s only five miles/12 minutes’ drive from the venue and boasts a ton of amenities including free access to the fabulous LivingWell spa with 15m indoor pool, jacuzzi, sauna, steam room and gym.

 

Days Inn By Wyndham Corley: this conveniently placed property is close to the M6 and just ten minutes’ drive from the UKPL venue. The hotel offers ample free parking, 24-hour reception, free WiFi, and an adjacent Starbucks. Each of the comfortable non-smoking rooms offers a flat-screen TV, ensuite bathroom and tea- and coffee-making facilities.

888poker’s Live Events Group Manager Matan Krakow said: “We’ve been working with Grosvenor for the past few years and it’s been an extraordinary partnership. They’re a major actor in the UK’s live poker scene. The live events we’ve done with them in the past have been very successful. Poker is very much part of the fabric of UK culture. We’re excited to be launching this new tour.”

MainEventTravel’s #FinalTableFreeroll promotion
The UKPL Coventry event is one of the standout events eligible for MainEventTravel’s amazing #FinalTableFreeroll promotion. All you have to do to enter is book your poker travel with MainEventTravel.com and then tag @MainEventTravel.com and #FinalTableFreeroll before the Main Event starts. If you reach the official final table, post a pic of yourself – including the tags – before the event begins and you’ll get a travel credit worth 10% of your MET-booked travel costs. Make it to heads-up and you’ll score a travel credit worth 50% of your travel costs and, if you win, you’ll receive a travel credit worth the full amount of your MET-booked travel. Globally, there are at least 25 Eligible Events to choose from in January alone – but you can get cracking with the new 888poker UK Poker League tour



What's Hot in Coventry


Events

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.