0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0058 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-07-16' AND `url` = 'https://www.maineventtravel.com/news/article/888poker-Grosvenor-Team-up-for-Festival-in-Coventry' ORDER BY `views` DESC

0.0086 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-07-16' AND `url` = 'https://www.maineventtravel.com/news/article/888poker-Grosvenor-Team-up-for-Festival-in-Coventry'

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

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

0.0068 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.0034 SECONDS:
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as article_count, MAX(news_articles.date) as recent_date FROM `news_categories` JOIN `news_article_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` JOIN `news_articles` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` GROUP BY `news_categories`.`id`

0.0070 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '11' AND `news_articles`.`active` = 1 ORDER BY `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.0004 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.0037 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '16' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0031 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '18' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0006 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.0032 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '19' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0004 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.0053 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '22' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0041 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '23' AND `news_articles`.`active` = 1 ORDER BY `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.0039 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '27' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0038 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '28' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0034 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '29' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0064 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '30' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0006 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.0004 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.0069 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '31' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0011 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.0007 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.0023 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-Grosvenor-Team-up-for-Festival-in-Coventry'

0.0154 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 `date` <= '2024-07-16' AND `news_articles`.`active` = '1' ORDER BY `DATE` DESC, `id` DESC LIMIT 5

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

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%article%'

English
Monday 28th August, 2023

888poker & Grosvenor Team up for Festival in Coventry

By Mad Harper

888poker LIVE will be holding its first-ever 888Poker LIVE Festival at the Coventry Building Society Arena from October 20 to 29. With a £500,000 guaranteed prize pool up for grabs in the Main Event, the festival promises to be a real high point in this Autumn’s UK poker calendar.

The packed 888Poker LIVE Festival schedule features a ton of events at varying buy-ins including a £200 + £200 + £40 Mystery Bounty to open the event, a two-day £110 Ladies Event, a £5k Super High Roller and £2,500 High Roller. The £888 buy-in Main Event, which kicks off on October 25, features four starting flights including a 1d turbo and all players get a generous 50k starting stack.

Grosvenor gave away 11 entries into the £888 buy-in Main Event at the recent GUKPT London. Among those who scored free seats were Weixiao Liao who won the Main Event and Ravi Sheth who won the Mini Main, along with all the Day 1 chip leaders in the Mini and the Main including Day 1b ME chip leader Ludovic Geilich. Three extra seats were given away in a random draw comprising all Main Event competitors. Grosvenor also announced that points for the National Poker League will be awarded during the 888Poker Live Festival; the league winner becomes the Grosvenor Player of the Year and wins a Grosvenor sponsorship package worth £40k.

As the Official Travel Partner for Grosvenor’s epic Goliath festival, MainEventTravel.com has years of experience in booking accommodation near the Coventry Building Society Arena. Don’t forget to check out our booking options offering free cancellation.

Below are details for six hotels that we recommend to players competing at Grosvenor Casino Coventry at the CBS Arena. They’re all comfy and conveniently located no more than 15 minutes’ drive from the venue.

DoubleTree by Hilton at the Arena

If you want to stay right bang next to the casino, then the DoubleTree by Hilton (pictured below) at the Arena is the hotel for you (ps not to be confused with the other DoubleTree by Hilton in Coventry city centre – see below.) This impressive hotel enjoys a prime location and has great transport connections – there’s an onsite West Midlands Trains railway station while Birmingham International Airport is only 20 minutes away. Hotel guests enjoy designated parking at £8/day. Your stay begins with a freshly baked chocolate chip cookie at check-in. Each guest room features free WiFi, a 42-inch flat screen HD TV and tea/coffee facilities. Faradays provides continental and Full English breakfast from 7am – 10am on weekdays and 8am to 11am at the weekend. Mill Bar & Brasserie offers classic seasonal British cuisine for lunch and dinner in a space divided into a restaurant, bar, and coffee lounge. The Anecdote (open 11am to 11pm every day) offers a great menu of street food-inspired classics, refreshing long cocktails, craft beers and sumptuous wines. The Anecdote also features a giant foosball table, shuffle-board and lots of funky areas. The hotel also has a well-equipped fitness centre.

Novotel Coventry

The Novotel Coventry (pictured below) is a premium option – easy walking distance from the CBS Arena venue and close to Junction 3 on the M6. The bedrooms are modern and well-equipped. All have plasma TV, tea- and coffee-making facilities, a safe and mini-fridge, plus Wifi is free throughout the hotel. The bar is open 24/7. Breakfast is served from 6.30am – 10am on weekdays and up to 11am at the weekend. It’s £9.95 per person unless included in your reservation. The restaurant is open for dinner from 6pm to 9.30pm.

For those who want to keep up their fitness schedule, there’s a purpose-built gym on-site, open from 7am – 10pm. For snacks and drinks, room service is available 24/7; (and from 6pm – 9.30pm for hot meals.) Parking at the hotel is £5 for your entire stay – just let reception know on arrival. Check-in is 3pm; check-out is noon.

Royal Court

The Royal Court Hotel (pictured below) is always a popular choice with Goliath and GUKPT Coventry players. This beautiful Grade II listed country house, set in 11 acres of landscaped gardens and parkland, is just a ten-minute drive from the 888poker LIVE venue. The original manor house dates back to 1894 and was built by the car manufacturer William Hillman to house his large family. It’s been extended over the years and is now one of the largest hotels in the area with over 200 rooms.

The hotel restaurant serves delicious breakfast and dinner every day in the stunning baronial hall of the original manor house. Reservations are room-only with full English breakfast available from 7am to 9.30am on weekdays and 8am to 10.30am for £18/pp. Dinner is from 6.30pm to 9pm. The Java Lounge Café serves light meals and snacks from 6:30pm-9:30pm and the hotel bar is open until 11pm. All rooms feature a TV, telephone, hairdryer and tea- and coffee-making facilities. For a small fee, guests can enjoy excellent hotel spa facilities with a heated indoor pool, gym, sauna, steam room and hot tub - open from 8:30am-7pm on weekdays and from 9:30am-5:30pm at weekends. Hotel parking is free. WiFi is free in all the public areas; in rooms, it’s £7 for 24 hours (per device.) The hotel’s reception desk is open 24/7; check-in is from 4pm; check-out is up to 10am. Please note there is no room service.

Britannia Coventry

Even though the Britannia Coventry (pictured below) is a city centre hotel, it’s still only a 12-15 minute drive to 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. All rooms have TV, hairdryer and tea- and coffee-making facilities. WiFi is free in all the public areas but in your room, it’s £7 for 24 hours (per device). The hotel’s Bentley’s restaurant is right on Cathedral Square and serves a £13.50 all-you-can-eat buffet breakfast from 7am to 9.30 weekdays and 8am-10.30am at weekends. Dinner is from 6.30pm to 9.30pm. The hotel’s Daimlers Bar offers a range of snacks throughout the day and evening including toasties and paninis. It’s open from 10.30am to 11pm (or later, if still busy). Please note, there is no room service. Check-in is 3pm; check-out is noon. There is no parking on-site but Lower Ford Street car park is just four minutes’ walk. It costs £2/hour 8am-6pm and £1/hour after 6pm – up to a maximum of £8 per 24 hours.

DoubleTree by Hilton Coventry

The DoubleTree by Hilton Coventry (pictured below) (not to be confused with the DoubleTree at the CBS Arena above) is a very stylish option for your 888poker LIVE sojourn. Located just off the M6, it’s only five miles/12 minutes’ drive from the Arena and/or Coventry city centre. It boasts a ton of amenities including free access to the fabulous LivingWell spa with 15m indoor pool, jacuzzi, sauna, steam room and gym. All the rooms have a bathtub with shower, desk, 32-inch HDTV, media hub for connecting electronic devices, tea- and coffee-making facilities. There is free Wifi throughout the hotel.

The Larder restaurant serves up a varied menu of traditional and international options and you can also grab a Starbucks-brewed coffee here – or glass of wine from The Larder Bar. The restaurant is open daily from 6.30pm to 9pm (last orders for dinner are at 8.30pm) while the bar is open up to 11pm. Breakfast is served 6.30-9.30am on weekdays and 7.30-10.30am at the weekend. Full English breakfast is just £14.95. You need to book the restaurant but light meals/snacks are also available in the Larder Bar. Room service is round the clock (with a reduced menu from 10pm.) There is secure parking in front of the hotel for £6/day. Check in is from 3pm, check-out by noon.

Holiday Inn, Coventry

Holiday Inns (pictured below) are always a reliable option if you’re looking for affordable accommodation – and the Holiday Inn Coventry has all the creature comforts you’d expect from this well-known chain. The Holiday Inn Coventry is located at Junction 2 of the M6, close to both the CBS Arena venue (10 minutes’ drive) and the city centre.

All the rooms have TV and tea- and-making facilities and the Wifi is free. There is an onsite bar and the Open Lobby restaurant serves Full English Breakfast and dinner. There is also 24/7 room service. Breakfast is served from 6.30am to 9.30am weekdays and 7.30am to 10.30am at weekends. Dinner is from at 6.00pm to 9.00pm daily. Please note you will need to book dinner in advance to dine in the restaurant.  A nice Holiday Inn touch is that, if you have left your laptop behind, you can use one at the hotel. Parking is £10 overnight. Check-in is from 2pm; check-out by noon.

Ramada Hotel by Wyndham Coventry

The Ramada (pictured below) is another reliable and reasonably-priced chain. The Queens Road Kitchen & Bar offers fresh food and drinks all day and night, featuring a mix of traditional favourites. Breakfast is served from 6.30-10am on weekdays and from 7.30am-10.30pm at the weekend. Dinner is available from 5.30pm to 9.30pm and there is also 24/7 room service (after 9.30pm, just pizza is available for hot food). There is secure parking for your convenience for £6.50 a day. There is also a small on-site gym with rowing machine and treadmill. All the rooms have plasma TV, hairdryer, iron and tea- and-making facilities and the Wifi is free. The front desk is open 24/7 and early check-in is available; otherwise, it’s 3pm check-in and 11am check-out.

Many of MainEventTravel.com’s booking options offer free cancellation in case your plans change before the tournament starts.

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.