0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

0.0014 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.0078 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.0006 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.0005 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

Monday 12th - Sunday 18th August, 2024

British Poker Series

BPS Carnival

Over £200,000 GTD for the inaugural BPS Carnival!

£100,000 GPP £340 Main Event Buy-in running from 15th - 18th August. 
    Find Hotels, Flights & More       View Complete Schedule  
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 £400,000 guaranteed London Poker Festival Main Event.

£700 Buy-in Main Event

#FinalTableFreeroll Eligible Event - Click Here for Details
Major Events
September 2024
Tue 3rd Mystery Bounty 1A at Aspers Casino Westfield Stratford City Buy In: £450 + £50.00
Tue 3rd London Festival Opener at Aspers Casino Westfield Stratford City Buy In: £125 + £25.00
Wed 4th Mystery Bounty 1B at Aspers Casino Westfield Stratford City Buy In: £450 + £50.00
Wed 4th London Main Event Day 1A at Aspers Casino Westfield Stratford City Buy In: £625 + £75.00
Wed 4th NLH at Aspers Casino Westfield Stratford City Buy In: £130 + £20.00
Thu 5th London Main Event Day 1B at Aspers Casino Westfield Stratford City Buy In: £625 + £75.00
Thu 5th London Omaha Championship 7-Max Day 1 at Aspers Casino Westfield Stratford City Buy In: £1350 + £150.00
Thu 5th London Main Event Day 1C at Aspers Casino Westfield Stratford City Buy In: £625 + £75.00
Fri 6th London Main Event Day 1D at Aspers Casino Westfield Stratford City Buy In: £625 + £75.00
Fri 6th £1k One Dayer at Aspers Casino Westfield Stratford City Buy In: £900 + £100.00
Fri 6th London Main Event Day 1E at Aspers Casino Westfield Stratford City Buy In: £625 + £75.00
Fri 6th Omaha 7 Max 4 Card at Aspers Casino Westfield Stratford City Buy In: £270 + £30.00
Fri 6th London Main Event Day 1F Fast at Aspers Casino Westfield Stratford City Buy In: £625 + £75.00
Sat 7th London Main Event Day 1G Fast at Aspers Casino Westfield Stratford City Buy In: £625 + £75.00
Sat 7th The London 250 at Aspers Casino Westfield Stratford City Buy In: £220 + £30.00
Sat 7th Highroller - Day 1 (Play 9 Levels) at Aspers Casino Westfield Stratford City Buy In: £1350 + £150.00
Sat 7th Omaha 7 Max 4/5 Card at Aspers Casino Westfield Stratford City Buy In: £270 + £30.00
Sun 8th London Women's Championship at Aspers Casino Westfield Stratford City Buy In: £225 + £25.00
Sun 8th Highroller - Day 2 (Reg Open for 2 Levels) at Aspers Casino Westfield Stratford City Buy In: £1350 + £150.00
Sun 8th London Poker Cup at Aspers Casino Westfield Stratford City Buy In: £460 + £40.00
Sun 8th Omaha 7 Max 4/5/6 Card at Aspers Casino Westfield Stratford City Buy In: £270 + £30.00
Sun 8th Last Chance Turbo at Aspers Casino Westfield Stratford City Buy In: £130 + £20.00
    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

Free Travel Credit and a Chance to Win up to £500 Value at Goliath

MainEventTravel.com is excited to be on-site at Goliath from 26th July offering FREE Poker Travel Credit to everyone who visits our stand.

Special Offers on London Poker Festival Packages Available Now!

MainEventTravel has exclusive offers on Accommodation + Buy-in Packages, along with Flights, Hotels and Buy-ins.
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.