0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0077 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/venue/aspers-casino-westfield-stratford-city'
ORDER BY `views` DESC

0.0110 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/venue/aspers-casino-westfield-stratford-city'

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.0004 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.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.0002 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.0040 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` = 'aspers-casino-westfield-stratford-city'

0.0006 SECONDS: 
SELECT *
FROM `venues`
WHERE `page_url` = 'aspers-casino-westfield-stratford-city'

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

0.0073 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.0007 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.0004 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
  1. Home
  2. Venues
  3. Aspers Casino Westfield Stratford City

Aspers Casino Westfield Stratford City


The poker room at Aspers Casino is the home of the world's top poker tournaments including the WPT, Unibet Open and 888 Live.

It is the biggest card room in London with warm and friendly staff and a real community vibe between the players, playing poker couldn’t be more fun! With a wide variety of tournaments and cash games on offer to suit all levels, they have got something for everyone.

MainEventTravel.com is the Official Travel Partner of Aspers Casino Westfield Stratford City.

Upcoming Events at this Venue

Thursday 2nd - Sunday 5th January, 2025

British Poker Series

BPS200 New Year Edition

£100,000 Guaranteed! Save the Date!
    Find Hotels, Flights & More       View Complete Schedule  
Thursday 6th - Sunday 9th February, 2025

British Poker Series

BPS200 London

Main Event Buy-In - £200+£35
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Thursday 13th - Sunday 16th March, 2025

British Poker Series

BPS200 London

Main Event Buy-In - £200+£35
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Thursday 10th - Sunday 13th April, 2025

British Poker Series

BPS200 London

Main Event Buy-In - £200+£35
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Thursday 29th May - Sunday 1st June, 2025

British Poker Series

BPS200 London

Main Event Buy-In - £200+£35
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Thursday 26th - Sunday 29th June, 2025

British Poker Series

BPS200 London

Main Event Buy-In - £200+£35
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Sunday 10th - Sunday 17th August, 2025

British Poker Series

BPS Carnival

More details to follow 
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Thursday 11th - Sunday 14th September, 2025

British Poker Series

BPS200 London

Main Event Buy-In - £200+£35
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Thursday 13th - Sunday 16th November, 2025

British Poker Series

BPS200 London

Main Event Buy-In - £200+£35
    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.
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.