0.0005 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

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.0007 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.0006 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.0115 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` = 'aspers-casino-westfield-stratford-city'

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

0.0019 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.0150 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.0014 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.0007 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 16th - Sunday 19th May, 2024

British Poker Series

BPS200 London

Highlights:

- £50,000 GTD - £200+£30 

- £10,000 GTD - £105+£15
    Find Hotels, Flights & More       View Complete Schedule  
Saturday 1st - Sunday 9th June, 2024

Unibet DeepStack Open

USDO UK Aspers 2024

Unibet DeepStack Open and Casino Aspers team up for the first time to offer you a memorable poker event in 2024!

The Unibet DeepStack Open poker tournament is an exciting poker festival set to take place at Aspers Casino in London. Players will have the opportunity to showcase their skills and compete for a chance to win a share of the prize pool.

Main Event Buy In - £500

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details
    Find Hotels, Flights & More       View Complete Schedule  
Thursday 20th - Sunday 23rd June, 2024

British Poker Series

BPS200 London

Highlights:

- £50,000 GTD - £200+£30 

- £10,000 GTD - £105+£15
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Thursday 18th - Sunday 21st July, 2024

British Poker Series

BPS200 London

Highlights:

- £50,000 GTD - £200+£30 

- £10,000 GTD - £105+£15
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Monday 12th - Sunday 18th August, 2024

British Poker Series

BPS Carnival

Full details TBC 
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Tuesday 3rd - Sunday 8th September, 2024

London Poker Festival

London Poker Festival

A rich tapestry of tournaments will provide unlimited entertainment and competition in London's premier casino.

And at its heart, the blockbuster £500,000 guaranteed London Poker Festival Main Event.

£700 Buy In for Main Event

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details
    Find Hotels, Flights & More       View Complete Schedule  
Thursday 19th - Sunday 22nd September, 2024

British Poker Series

BPS200 London

Highlights:

- £50,000 GTD - £200+£30 

- £10,000 GTD - £105+£15
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Friday 4th - Sunday 13th October, 2024

British Poker Series

BPS Championships

Full Details TBC
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Thursday 14th - Sunday 17th November, 2024

British Poker Series

BPS200 London

Highlights:

- £50,000 GTD - £200+£30 

- £10,000 GTD - £105+£15
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Latest News & Blogs

Win a Portugal Adventure Package including Accommodation + Main Event!

We are so excited about the festival that MET has organised a 5-Night hotel + Buy-in Playcation Package to Giveaway! 

Book a Playcation in Portugal this Summer!

Book with MainEventTravel.com and enjoy sun, fun, and poker along a 13km stretch of pristine sands and crystal-clear waters.
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.