0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0008 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/venue/aspers-casino-westfield-stratford-city', 1, '2025-01-22')

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.0005 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.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.0047 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.0005 SECONDS:
SELECT * FROM `venues` WHERE `page_url` = 'aspers-casino-westfield-stratford-city'

0.0017 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.0116 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.0011 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

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 13th - Sunday 26th January, 2025

Aspers Casino Stratford

Aspers Winter Fest

£120,000 GUARANTEED MAIN EVENT

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 6th - Sunday 9th February, 2025

British Poker Series

BPS200 London

Main Event Buy-In - £200+£35

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 12 February, 2025

APAT

UKICOAP 2024

Buy In: £140

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 27th February - Sunday 2nd March, 2025

Beer Poker Tour

Beer Poker Tour London

The first festival will be held in Aspers Casino, London from 27 Feb to 2 Mar 2025.

For this event, we decided to break the codes and bring fun and value to players:

  • £100K Double Mystery Main Event! What is the Double Mystery format? We added plenty of gifts and £5,000 cash to the prize pool for KO before ITM as we believe Mystery is more fun when it's available from level 1!
  • Fun variants side events as PLO6 Pot Fold and Double Board!
  • Special trophies in beer shapes for winners of the Main and Sides Events.
  • Multiple gifts to win at the poker tables during the main event: win a hand with quads or better and get a free round of beer for your table! Also, more gifts to win for you and your table by playing our special games against the dealers during the break!
    Find Hotels, Flights & More       View Complete Schedule  

Thursday 13th - Sunday 16th March, 2025

British Poker Series

BPS200 London

Main Event Buy-In - £200+£35

    Find Hotels, Flights & More       Full Schedule Coming Soon  

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  

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  
Latest News & Blogs

Kings of Tallinn Celebrates 10-Year Anniversary This February

The Kings of Tallinn, one of Europe's most exciting poker festivals, is set to mark its 10th anniversary with a spectacular event in February 2025. Hosted at the luxurious Hilton Tallinn Park Hotel and Olympic Park Casino, this milestone promises an unforgettable experience for poker enthusiasts from around the globe.

Irish Poker Open 2025: Europe’s Longest-Running Poker Festival Returns

The highly anticipated Irish Poker Open 2025 is set to take place from 10th to 21st April at the Royal Dublin Society (RDS), Dublin. Renowned for its vibrant atmosphere and prestigious history, the event is expected to draw poker enthusiasts from around the globe, all vying for their share of fame and fortune.
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.