0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0148 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-11-29' AND `url` = 'https://www.maineventtravel.com/venue/genting-casino-stratford' ORDER BY `views` DESC

0.0173 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-11-29' AND `url` = 'https://www.maineventtravel.com/venue/genting-casino-stratford'

0.0004 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.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.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.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.0073 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` = 'genting-casino-stratford'

0.0007 SECONDS:
SELECT * FROM `venues` WHERE `page_url` = 'genting-casino-stratford'

0.0022 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.0107 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.0007 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

Genting Casino Stratford


The poker room at Genting 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.


Upcoming Events at this Venue

Wednesday 26th - Sunday 30th November, 2025

British Poker Series

BPS200 London 2025

Main Event Buy-In: £200 + £35 with a guarantee of £100,000

    Find Hotels, Flights & More       View Complete Schedule  

Sunday 14th - Sunday 21st December, 2025

PartyPoker Tour

London

The PartyPoker Tour heads to London for the final stop of the first UK Tour. 

Genting Casino Stratford is an ideal stage for the PartyPoker Tour, merging a world-class casino with the buzz of Westfield Stratford City. The venue's dedicated gaming floor, upgraded poker room, stylish bars, and live entertainment spaces create a vibrant, all-in-one environment that keeps players and spectators entertained around the clock. 

The Poker Schedule

  • £500 Main Event: December 18th-21st (£100,000 GTD)
  • £150 Mini Main Event: December 14th - 18th (£50,000 GTD)
  • £250 PLO Masters: December 19th - 21st (£20,000 GTD)
  • £1,000 High Roller: December 21st 
  • Sports Betting and Casino Tournaments: Play for free in any of the tournaments in schedule and win your way to the Main Event
    Find Hotels, Flights & More       View Complete Schedule  
Latest News & Blogs

Vegas Calling: The WPT World Championship Returns Bigger Than Ever

The WPT World Championship returns to the Wynn Las Vegas this December, promising another record-breaking festival. Players and fans worldwide are already preparing for poker’s most anticipated event of the year.

The Bahamas Awaits: Join WSOP Paradise 2025 and Play for Millions

WSOP Paradise 2025 returns to Atlantis Paradise Island in the Bahamas, featuring the $25,000 Super Main Event with a $60 million guaranteed prize pool. Enjoy high-stakes poker, luxurious resort amenities, and hassle-free travel with Main Event Travel hotel and flight packages.
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.