0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0068 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-21' AND `url` = 'https://www.maineventtravel.com/venue/grosvenor-casino-coventry' ORDER BY `views` DESC

0.0006 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/venue/grosvenor-casino-coventry', 1, '2024-12-21')

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.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.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.0037 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.0001 SECONDS:
SELECT * FROM `venues` WHERE `id` = 'grosvenor-casino-coventry'

0.0005 SECONDS:
SELECT * FROM `venues` WHERE `page_url` = 'grosvenor-casino-coventry'

0.0014 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_stops`.`venue_id` = '68' ORDER BY `tour_stops`.`start_date` ASC

0.0076 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.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.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'

English

Grosvenor Casino Coventry


Grosvenor Casino Coventry is more than just a Casino, it's the perfect day and night leisure destination with a fantastic restaurant, amazing bar, sports & entertainment lounge, great poker, conference room and much, much more. 

They have numerous Roulette, Blackjack and Poker tables with popular slot games like Cleopatra and Lucky Lady’s Charm to make your gaming experience the best in town.

Coventry is also home to the Goliath poker tournament, the largest in the world outside of Las Vegas.

Situated in the beautifully designed Ricoh Arena, Grosvenor Casino Coventry has the wow factor to make an evening a memorable one. 


Upcoming Events at this Venue

Thursday 9th - Sunday 19th January, 2025

GUKPT Grosvenor

GUKPT Coventry - Leg 1

Main Event Buy-In: £1100+£150

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 20th February - Sunday 2nd March, 2025

Grosvenor UK Poker Open

The UK Poker Open

The dates have been released for the 2025 UK Poker Open!

Check back for more details.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 16th - Sunday 20th April, 2025

Grosvenor Poker 25/50

Coventry

£220+£30 Buy-In with £50,000 GTD!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 4th - Sunday 8th June, 2025

Grosvenor Poker 25/50

Coventry

£220+£30 Buy-in with £50,000 GTD!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 24th July - Sunday 3rd August, 2025

Grosvenor Goliath

Goliath 2025

Grosvenor has just announced their 2025 dates for Goliath!

Main Event Buy-in  - £200

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 17th - Sunday 21st September, 2025

Grosvenor Poker 25/50

Coventry

£220+£30 Buy-In with £50,000 GTD!

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 11th - Sunday 16th November, 2025

888poker UK Poker League

UKPL Coventry

Main Event buy-in are £560

    Find Hotels, Flights & More       Full Schedule Coming Soon  
Latest News & Blogs

GUKPT Coventry Kicks Off the 2025 Season

The Grosvenor UK Poker Tour (GUKPT) is set to commence its 19th season with Leg 1 in Coventry, running from January 9 to 19, 2025. This event boasts a total of £600,000 in guarantees, offering players a substantial prize pool to compete for.

Start 2025 with a Trip to 888poker Madrid Live

The 2025 live circuit kicks off in the vibrant city of Madrid, hosting the first 888poker LIVE event of the year! As one of Europe’s most popular cities, the dynamic and buzzing Madrid is a perfect location to experience an awesome European live poker event.
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.