0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0067 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-04-25'
AND `url` = 'https://www.maineventtravel.com/news/article/2023-Goliaththe-hotellow-down'
ORDER BY `views` DESC

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/news/article/2023-Goliaththe-hotellow-down', 1, '2025-04-25')

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.0004 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.0002 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.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.0067 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.0077 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.0137 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.0008 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.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` = '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.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.0054 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.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.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.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` = '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.0062 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.0010 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.0066 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.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.0052 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.0012 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.0058 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.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.0081 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.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.0063 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.0008 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.0026 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` = '2023-Goliaththe-hotellow-down'

0.0010 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` <= '2025-04-25'
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.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.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` = '809'

0.0001 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%article%'
English
  1. Home
  2. News & Blogs
  3. 2023 Goliath – the hotel low-down
Thursday 6th April, 2023

2023 Goliath – the hotel low-down

By

2023 Goliath – the hotel low-down

The Goliath festival is taking place from July 27 to August 6 this year at the Coventry Building Society Arena in the Midlands. A record field is expected so we’re strongly recommending players get a good head-start on room reservations to ensure they get exactly what they want.

Below you’ll find details for six local hotels that we’re recommending to Goliath players. They’re all comfy and conveniently located  ie no more than 15 minutes’ drive from the Goliath festival venue at the Coventry Building Society Arena.

A reminder on dates: the £150 buy-in Main Event will get underway on July 29 with eight different starting flights over a total of seven days. Flight A is on July 29 at noon with the final two start flights taking place on August 4: Flight G at 11am and the Flight H turbo starting at 6pm.

Kelly Saxby, MET’s head of Retail Sales & Marketing, said: “Last year people left it pretty late to book their accommodation and were then really disappointed that they’d missed out on good deals. Rooms can be cancelled anytime until just a few days before check-in and we currently have several hotel options at lower rates[MH1] . This year’s festival is taking place nearly a month earlier than last year so that will also put pressure on hotel bookings.”

MainEventTravel.com is the Official Travel Partner for Grosvenor’s epic Goliath festival. Bag your room now to take advantage of lower rates – and make sure you get to stay exactly where you want.

 

Novotel Coventry

The Novotel Coventry is a premium option if you’re planning to play this year’s Goliath. It’s 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, mini-fridge – and even an iron and ironing board if you’re planning to spruce up for the event! 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.

 

The hotel has a nice garden – al fresco dining! and is open to both guests and non-residents. 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. MainEventTravel has options for room only, room with breakfast and a third option offering free cancellation – so you can book now even if you’re not 100% sure you’re coming. Check-in is 3pm; check-out is noon.

 

Royal Court

The Royal Court Hotel is always a popular choice with Goliath 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 Goliath 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 hour. Reservations are room-only with full English breakfast available from 7am – 9.30am on weekdays and 8am to 10.30am for £18/pp. Dinner is from 6.30pm to 9pm. Overlooking the pool area, 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 just £4 a session, 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 however in your room, 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. MainEventTravel has options for room only and a second option offering free cancellation up to four days before arrival. There is no room service.

 

Britannia Coventry

 

Even though the Britannia Coventry is a city centre hotel, it’s still only a 12-15 minutes 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 at the Britannia Coventry. 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 away. 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 (not to be confused with the sold-out DoubleTree at the CBS Arena) is a very stylish option for your Goliath 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 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 is another reliable chain and reasonably-priced for the duration of your Goliath stay. There is also the option to upgrade to a suite for extra amenities like a kitchenette – just get in touch with us at MainEventTravel.com[MH2] .

 

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. Don’t forget to check out MainEventTravel.com’s booking options offering free cancellation.

 [MH1]I’m not sure that free cancellation is an option for all the hotels? IF not, we can just delete this line?

 [MH2]Needs confirming … but the Ramada website says you can upgrade to a “suite”

Featured Articles
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.