0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0072 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-01-23'
AND `url` = 'https://www.maineventtravel.com/destination/guide/london-destination-guide'
ORDER BY `views` DESC

0.0198 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-01-23'
AND `url` = 'https://www.maineventtravel.com/destination/guide/london-destination-guide'

0.0005 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.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.0042 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.0003 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.0003 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.0041 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.0003 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`

0.0002 SECONDS: 
SELECT `uapi_airports`.*, `uapi_cities`.`name` as `city`, `uapi_countries`.`name` as `country`
FROM `uapi_airports`
JOIN `uapi_countries` ON `uapi_countries`.`country_code` = `uapi_airports`.`country_code`
JOIN `uapi_cities` ON `uapi_cities`.`city_code` = `uapi_airports`.`reference_city`
WHERE `airport_code` = 'LHR'
English
  1. Home
  2. Destination Guide - London
Destination Guide London

As one might expect, you’ll be spoilt for choice when it comes to places to play poker in London.

However, when it comes to truly understanding the poker player’s mindset, four casinos in the capital really stand out. The Poker Room at Grosvenor’s Victoria Casino, The Hippodrome Casino and the Empire Casino in Leicester Square plus Aspers Stratford in London’s East End all have fantastic offerings for players including cash games, tournaments and regular promotions.

What's Hot in London

The Poker Room at the Vic The Vic has legendary status for poker players with one of the longest-running and busiest card rooms in the capital. The Poker Room, which officially opened in 2013 after a full renovation.
Hippodrome Casino London The Hippodrome Casino is home to PokerStars LIVE, a partnership that ensures exemplary standards when it comes to hosting cash games and tournaments.
Aspers Casino Westfield Stratford City Aspers’ prestigious Stratford casino in London’s East End goes from strength to strength as a top poker destination. It’s the biggest card room in London with warm and friendly staff.
Empire Casino, Leicester Square The Empire Casino offers a busy roster of daily tournaments including a £108 tournament with unlimited re-entries which kicks off at noon every Sunday (apart from the first of the month.)

Events

Mon 13th - Sun 26th January, 2025 Aspers Winter Fest Aspers Casino Westfield Stratford City Thu 6th - Sun 9th February, 2025 BPS200 London Aspers Casino Westfield Stratford City Wed 12 February, 2025 UKICOAP 2024 Aspers Casino Westfield Stratford City Thu 27th February - Sun 2nd March, 2025 Beer Poker Tour London Aspers Casino Westfield Stratford City Thu 13th - Sun 16th March, 2025 BPS200 London Aspers Casino Westfield Stratford City Thu 10th - Sun 13th April, 2025 BPS200 London Aspers Casino Westfield Stratford City Sat 19th - Sun 27th April, 2025 London Aspers Casino Westfield Stratford City Thu 29th May - Sun 1st June, 2025 BPS200 London Aspers Casino Westfield Stratford City Wed 11th - Sun 15th June, 2025 London: The Victoria The Poker Room Thu 26th - Sun 29th June, 2025 BPS200 London Aspers Casino Westfield Stratford City Thu 10th - Sun 20th July, 2025 GUKPT London - The Vic - Leg 5 The Poker Room Sun 10th - Sun 17th August, 2025 BPS Carnival Aspers Casino Westfield Stratford City Wed 27th - Sun 31st August, 2025 London: The Victoria The Poker Room Thu 4th - Sun 14th September, 2025 888 London: The Vic The Poker Room Thu 11th - Sun 14th September, 2025 BPS200 London Aspers Casino Westfield Stratford City Wed 24th - Sun 28th September, 2025 London: The Victoria The Poker Room Wed 22nd - Sun 26th October, 2025 London: The Victoria The Poker Room Thu 13th - Sun 16th November, 2025 BPS200 London Aspers Casino Westfield Stratford City Thu 20th - Sun 30th November, 2025 GUKPT London - The Vic - Grand Final 2025 The Poker Room

Travel Search

Your trip starts here...
Search anywhere using the form below, click here to search for events, or have a look at the calendar to see what's on!
Flights
From
To
Cabin Class & Travellers
1 Adult, Economy
Hotels
Staying near
Rooms
Guests
1 Adult


Rates
Dates of Travel
Dates of Travel Close
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.