        
0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0149 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-10-28'
AND `url` = 'https://www.maineventtravel.com/venue/hippodrome-casino'
ORDER BY `views` DESC

0.0162 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-10-28'
AND `url` = 'https://www.maineventtravel.com/venue/hippodrome-casino'

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

0.0074 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` = 'hippodrome-casino'

0.0009 SECONDS: 
SELECT *
FROM `venues`
WHERE `page_url` = 'hippodrome-casino'

0.0022 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` = '3'
ORDER BY `tour_stops`.`start_date` ASC

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

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

Hippodrome Casino

The Hippodrome is the UK’s largest entertainment and casino venue, and its most popular.

It sits alongside the Tower of London and Buckingham Palace as one of the ‘must-see’ destinations of the capital.

With six floors of gaming, London’s largest dedicated poker floor, a multi-award-winning steak house, 326-seat Magic Mike Live theatre, eight bars and a brand new three-floor outdoor terrace, there’s simply nothing to compare to in the West End of London.

Housed within the former Hippodrome Theatre, the main door opens onto one of Europe’s busiest thoroughfares, while the world’s largest ‘Chinatown’ community sits just alongside.

After 120 years the Hippodrome is still as famous, dynamic and inventive as it’s ever been.

Upcoming Events at this Venue

Sorry, we have no events scheduled yet for Hippodrome Casino.
Please check back soon, or subscribe to our newsletter.

The Bahamas Awaits: Join WSOP Paradise 2025 and Play for Millions

WSOP Paradise 2025 returns to Atlantis Paradise Island in the Bahamas, featuring the $25,000 Super Main Event with a $60 million guaranteed prize pool. Enjoy high-stakes poker, luxurious resort amenities, and hassle-free travel with Main Event Travel hotel and flight packages.

From the Felt to the Eiffel: Play the UDSO Paris 2025

The Unibet DeepStack Open Paris 2025 is set to deliver an unforgettable poker experience at Club Circus Paris, featuring a €550 Main Event, deep structures, and an electric atmosphere. Players can secure their seats through online or live satellites and book hotels via Main Event Travel. Don’t miss your chance to play, explore Paris, and be part of one of Europe’s most exciting poker festivals

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.