0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0086 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-04-27'
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.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.0005 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.0064 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.0005 SECONDS: 
SELECT *
FROM `venues`
WHERE `page_url` = 'aspers-casino-westfield-stratford-city'

0.0011 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.0071 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 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

All change at the Vic!

With events being relocated due to refurb, MainEventTravel has your back with great accommodation options near all the Grosvenor Casinos selected.

Geraghty wins 888poker LIVE UKPL Manchester

Scottish player Jamie Geraghty has won the 888poker LIVE UKPL Manchester Main Event for the biggest cash of his live poker career. Geraghty won £30,610 after outlasting a 328-entry field – and beating Josh Radley heads-up.
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.