0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0087 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-06-20' AND `url` = 'https://www.maineventtravel.com/venue/grosvenor-casino-coventry'

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.0005 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' 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.0004 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.0008 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.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.0002 SECONDS:
SELECT * FROM `venues` WHERE `id` = 'grosvenor-casino-coventry'

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

0.0011 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.0111 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.0009 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'

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 25th July - Sunday 4th August, 2024

Grosvenor Goliath

Goliath 2024

2024 GOLIATH DATES & SCHEDULE HAVE BEEN CONFIRMED

ALL MULTI-DAY EVENTS ARE ELIGIBLE FOR #FINALTABLEFREEROLL

#FinalTableFreeroll Eligible Event - Click Here for Details on How You Can Win Back 100% of Your Tournament Travel Costs

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 28th August - Sunday 1st September, 2024

Grosvenor Poker 25/50

Coventry

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  


Thursday 10th - Monday 21st October, 2024

888poker UK Poker League

UKPL Coventry Grand Finale

UKPL will host their Grand Finale where the league started, in Coventry! The tour is set to take the UK by storm with exciting live events in various Grosvenor casinos across the country!

The Buy in fee is £500 + £60. Check out all the details and the schedule. 

Win Back Up to 100% of Your Tournament Travel Costs - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       View Complete Schedule  
Latest News & Blogs

MET Continues Partnership with Malta Poker Festival Autumn 2024

MPF is set to be another smash hit this Autumn and MainEventTravel.com is on hand to get you there with VIP Packages, Hotels, Flights, Buy-ins, and more.

2024 EPT Barcelona Hotels

Huge numbers are expected at this year's EPT Barcelona after 2023's sensational festival which attracted over 2,100 entries for the €5,300 Main Event and featured more than 60 different tournaments.
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.