0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0064 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-23' AND `url` = 'https://www.maineventtravel.com/destination/articles/london-destination-guide/Aspers-Casino-Westfield-Stratford-City' ORDER BY `views` DESC

0.0006 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/destination/articles/london-destination-guide/Aspers-Casino-Westfield-Stratford-City', 1, '2024-11-23')

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.0002 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0034 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.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.0002 SECONDS:
SELECT destinations.*, uapi_airports.name as airport_name FROM `destinations` LEFT JOIN `uapi_airports` ON `destinations`.`uapi_code` = `uapi_airports`.`airport_code` WHERE `url` = 'london-destination-guide'

0.0014 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 `url_name` = 'Aspers-Casino-Westfield-Stratford-City'

0.0002 SECONDS:
SELECT `news_categories`.* FROM `news_article_categories` LEFT JOIN `news_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` WHERE `news_article_categories`.`news_article_id` = '932'

0.0034 SECONDS:
SELECT DISTINCT tour_stops.*, tours.name as tour_name, ((ACOS(SIN(51.5072178 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(51.5072178 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((-0.1275862 - venues.map_longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance, venues.name as venue_name, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, tours.logo as tour_logo, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo FROM `venues` LEFT JOIN `tour_stops` ON `tour_stops`.`venue_id` = `venues`.`id` JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` WHERE `tour_stops`.`active` = '1' AND tour_stops.end_date > CURDATE() HAVING `distance` <= 10 ORDER BY `tour_stops`.`start_date` ASC

0.0003 SECONDS:
SELECT `news_articles`.`url_name`, `news_articles`.`main_image`, `news_articles`.`meta_description`, `news_articles`.`title` FROM `news_article_destinations` JOIN `news_articles` ON `news_article_destinations`.`news_article_id` = `news_articles`.`id` WHERE `news_articles`.`active` = 1 AND `destination_id` = 4 ORDER BY `news_article_destinations`.`display_order`

Tuesday 9th January, 2024

Aspers Casino Westfield Stratford City

By Mad Harper

Travel Tips Main Event Travel News Blogs

Aspers Stratford

Aspers’ prestigious Stratford casino in London’s East End goes from strength to strength as a top poker destination. It’s the biggest card room in London with warm and friendly staff and a real community vibe between the players. In addition to cash games and a packed schedule of regular tournaments, the casino also hosts numerous international events. 2024 gets underway with the Aspers WinterFest from January 12-21, followed by the London Poker Festival and the European Championship of Amateur Poker in February.

The London Poker Festival is set to be a very busy event and the £700 buy-in Main Event is eligible for MainEventTravel’s #FinalTableFreeroll promotion (click here for more details.) Other highlights during the London Poker Festival include a £100k guaranteed Mystery Bounty, the London Omaha Championship – which has a £75k guarantee – and the £125k guaranteed £2k High Roller. Previous festivals at Aspers include the WPT, Unibet Open and 888poker LIVE.

The regular weekly tournaments are ideal for low-stakes to mid-stakes players and there is something on every day of the week including Redtooth Mondays, the £5 buy-in Tuesday Tornados, and the £60 buy-in Second Chance Friday tournaments.

Promotions include the Monthly Cash Race for nearly £30k and a Super Jackpot that's regularly over £50k. You can keep up with the latest news from Aspers Stratford on Twitter.

Top Hotel Picks for Aspers Stratford

The 4* Hyatt Stratford offers a luxury hotel option during your trip to Aspers with all-day dining restaurant and bar with open air, outdoor terrace, fitness centre, free WiFi, room service and a 24-hour front desk. The hotel can also arrange bike hire for exploring the local area.

The Moxy Stratford is a super-stylish, eco-friendly and modern boutique hotel just 11 minutes’ walk from Aspers. There’s free Wifi and all rooms have USB charging points. The design extends to a laid-back lounge and a fun sports theme.

The Gantry London is part of Hilton’s Curio Collection and features three restaurants and lounges including a chic rooftop bar 18 floors up. The rooms are spacious and feature all mod cons. There’s room service, a 24-hour front desk and free WiFi.