0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0096 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-09-15' 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.0004 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.0062 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.0010 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.0066 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.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

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

Tuesday 17th - Sunday 22nd September, 2024

British Poker Series

BPS200 London

Highlights:

- £50,000 GTD - £200+£30 

- £10,000 GTD - £105+£15

    Find Hotels, Flights & More       View Complete Schedule  

Friday 4th - Sunday 13th October, 2024

British Poker Series

BPS Championships

£200,00 GUARANTEED

Buy-In: £300+£40

    Find Hotels, Flights & More       View Complete Schedule  

Monday 21st October - Sunday 3rd November, 2024

Aspers Casino Stratford

Aspers AutumnFest

£600 Main Event Buy-in for a £120,000 Guaranteed Main Event. 

#FinalTableFreeroll Eligible Events

    Find Hotels, Flights & More       View Complete Schedule  

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

MainEventTravel.com Named Official Travel Partner for Costa Rica Poker Festival

MET is thrilled to announce its appointment as the OTP for this inaugural set to take place in San Jose from January 27th.

Malta lays it on big for High Rollers this Autumn

Malta's two biggest festivals are offering High Rollers the chance to experience first-class tournament action in tandem with the Main, HR and SHR schedule!  
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.