0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0082 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-04-06' 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.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.0053 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.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.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

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 10th - Sunday 13th April, 2025

British Poker Series

BPS200 London

Main Event Buy-In - £200+£35

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Saturday 19th - Sunday 27th April, 2025

PartyPoker Tour

London
  • Main Event Buy-In - £500 
  • Mini Main Buy-In - £150
  • High Roller - £1000
    Find Hotels, Flights & More       View Complete Schedule  

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  

Wednesday 19 November, 2025

APAT

UKCOAP 2025

6pm

Buy-in: £140

    Find Hotels, Flights & More       Full Schedule Coming Soon  
Latest News & Blogs

Starts This Week! Last-Minute Rooms for the Irish Open

The highly anticipated Irish Open kicks off this week, and if you haven’t sorted your accommodation yet, don’t worry—there are still last-minute rooms available!

Top Hotels for the WSOP 2025: 2 Months to Go – Have You Booked Yet? Lock in the Best Rates Today!

The World Series of Poker (WSOP) is just two months away, and if you haven’t already secured your accommodation, now is the time to act! The WSOP is one of the most prestigious poker events in the world, drawing thousands of players and fans to Las Vegas for weeks of thrilling action.
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.