0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

0.0003 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.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.0002 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

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

0.0124 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 *
FROM `venues`
WHERE `id` = 'aspers-casino-westfield-stratford-city'

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

0.0020 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.0119 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.0013 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

Vegas on a Budget

For a city full of so much glitz and glam, there are a surprising number of things you can do totally for free in Las Vegas, as there are plenty of free attractions dotted throughout the city.

Las Vegas Hotel Lowdown

It’s said that there are more hotel rooms in Las Vegas than in any other city in the world –130,000 and counting – so you’ll be spoilt for choice when you head to Sin City
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.