0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0074 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-07-07' AND `url` = 'https://www.maineventtravel.com/tour/888poker-live' ORDER BY `views` DESC

0.0006 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour/888poker-live', 1, '2025-07-07')

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.0043 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.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.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = '888poker-live'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = '888poker-live'

0.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = '78'

0.0012 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_id` = '78' ORDER BY `tour_stops`.`start_date` ASC

0.0068 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'

0.0003 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

888poker LIVE


888poker LIVE series is back for 2025! 

It’s promising to be a whirlwind year where we’ll be meeting up with players of all nationalities. A big recent hit with players has been our Mystery Bounty events and these will figure prominently on the schedule.

888poker LIVE is dedicated to hosting events that are centred on the player. We aim to create a comfortable environment where everyone is welcome. We also throw a pretty exciting and action-packed tournament series, with all players getting the opportunity to enjoy the 888poker LIVE experience!

Join us for great destinations, the option of winning packages and poker tournaments with affordable buy-ins. Not to mention, 888poker ambassadors and team players will be at every event, so you’ll get the chance to meet and play with them.

We’ll also be live streaming the Main Events in each series and you’ll get the chance to star on one of our 888pokerTV feature tables!

Our 2024 live tour smashed it, and we’re planning to top that in 2025.

Upcoming Tour Stops

Thursday 4th - Sunday 14th September, 2025

888 London: The Vic

The Poker Room, The Grosvenor Victoria Casino London, 150 Edgware Road, London, W2 2DT

Join 888poker LIVE London 2025, a premier poker event set in the heart of London.

London, renowned for its rich history and vibrant culture, provides an exceptional setting for an unforgettable poker experience. The festival will be hosted at the prestigious Victoria Casino, which is celebrated for its modern amenities and welcoming atmosphere.

Players can anticipate a variety of exciting events, including the highly anticipated Main Event with a buy-in of £1250. This festival not only promises exhilarating poker action but also offers a chance to meet fellow players and immerse yourself in the unique charm of London. With numerous side events and satellite tournaments leading up to the Main Event, there’s something for everyone, whether you are a seasoned player or new to the game

    Find Hotels, Flights & More       Full Schedule Coming Soon  
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.