0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0105 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-05-08' AND `url` = 'https://www.maineventtravel.com/destination/articles/london-destination-guide/Hippodrome-Casino-London' ORDER BY `views` DESC

0.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/destination/articles/london-destination-guide/Hippodrome-Casino-London', 1, '2024-05-08')

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.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 * 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.0093 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.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.0002 SECONDS:
SELECT destinations.*, uapi_airports.name as airport_name FROM `destinations` LEFT JOIN `uapi_airports` ON `destinations`.`uapi_code` = `uapi_airports`.`airport_code` WHERE `url` = 'london-destination-guide'

0.0022 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` = 'Hippodrome-Casino-London'

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` = '930'

0.0063 SECONDS:
SELECT DISTINCT tour_stops.*, tours.name as tour_name, ((ACOS(SIN(51.5072178 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(51.5072178 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((-0.1275862 - venues.map_longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance, venues.name as venue_name, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, tours.logo as tour_logo, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo FROM `venues` LEFT JOIN `tour_stops` ON `tour_stops`.`venue_id` = `venues`.`id` JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` WHERE `tour_stops`.`active` = '1' AND tour_stops.end_date > CURDATE() HAVING `distance` <= 10 ORDER BY `tour_stops`.`start_date` ASC

0.0002 SECONDS:
SELECT `news_articles`.`url_name`, `news_articles`.`main_image`, `news_articles`.`meta_description`, `news_articles`.`title` FROM `news_article_destinations` JOIN `news_articles` ON `news_article_destinations`.`news_article_id` = `news_articles`.`id` WHERE `news_articles`.`active` = 1 AND `destination_id` = 4 ORDER BY `news_article_destinations`.`display_order`

Tuesday 9th January, 2024

Hippodrome Casino London

By Mad Harper

Travel Tips Main Event Travel News Blogs

The Hippodrome Casino

The Hippodrome Casino is home to PokerStars LIVE, a partnership that ensures exemplary standards when it comes to hosting cash games and tournaments. Dubbed London’s Leading Poker Room, the Hippodrome’s state-of-the-art card room is located on the entire third floor while major tournaments take place in Lola’s Underground Casino. The Hippodrome’s central location makes it ideal as a place to meet up with friends and the casino’s restaurants – especially the Heliot Steak House and the new contemporary Chinese restaurant Chop Chop by Four Seasons – are very highly rated.

Regular poker festivals at the Hippodrome Casino include Our Series, Super Series and MEGA series events. The Hippodrome’s annual Win Your Way to Vegas promotion has also seen dozens of players win a once-in-a-lifetime poker trip to Sin City; the Hippodrome launched its Vegas 2024 promotion at the beginning of December and at least one Vegas package will be won every month. When it comes to cash games, buy-ins start from £50 for NLH and £100 for PLO. The Hippodrome Rewards scheme offers discounts on all food and drink. The Hippodrome is open from noon to 6am weekdays and 24/7 over the weekends. You can follow updates from the Hippodrome Casino on Twitter.

Top Hotel Picks for the Hippodrome Casino

Staying right bang in the middle of London is never going to be cheap but there are some lovely options near the Hippodrome that won’t break the bank – and it’s certainly a treat to be staying in the heart of London’s West End.

The 4* Hotel Indigo is on the same side of Leicester Square as the Hippodrome and boasts a fabulous rooftop bar affording spectacular views of the city. The art deco-styled property mirrors the 1920s glamour of its theatrical surroundings and has a 24-hour front desk and free WiFi.

The Londoner Hotel is definitely not cheap but it’s very glamorous and having an onsite spa with pool and gym is a real treat. There are six concept restaurants and bars including a rooftop lounge. The Residence guest-only club provides complimentary antipasti, soft drinks, tea and coffee all day.

At the more budget end, there are two Thistle Hotels to choose from – Thistle London Picadilly (pictured) is four minutes’ walk from the Hippodrome and Thistle Trafalgar Square is just six minutes away. The Thistle Piccadilly has an all-day dining room, 24-hour pizza delivery service and a fully-equipped gym. The Thistle Trafalgar Square has an on-site restaurant and bar, plus 24-hour room service.

Zedwell Piccadilly puts sleep first and foremost so if shut-eye is the only thing you want from your room, it’s a great option. The minimalist soundproofed design is emphatically clutter-free – with no distractions such as TV and electronics. Their four-bed rooms (including two bunk beds) are ideal for players sharing.