0.0007 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0324 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-12' AND `url` = 'https://www.maineventtravel.com/tour/888poker-live'

0.0007 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.0004 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0008 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0005 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.0003 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

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

0.0129 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.0009 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.0005 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 * FROM `tours` WHERE `id` = '888poker-live'

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

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

0.0029 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.0136 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.0015 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'

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

English

888poker LIVE


888poker LIVE series is back for 2024! 

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 2023 live tour smashed it, and we’re planning to top that in 2024.

Upcoming Tour Stops

Wednesday 8th - Monday 20th May, 2024

888poker Barcelona

Casino de Barcelona, Calle Marina, 19-21, 08005 Barcelona, Spain

The 3rd tour stop for 888poker is the eagerly anticipated Barcelona Leg!

Win Back Up to 100% of Your Tournament Travel Costs - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 14th - Sunday 25th August, 2024

888poker London

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

888poker is heading to London in August 2024.

Check back for the full schedule. 

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 10th - Monday 21st October, 2024

888poker Coventry

Grosvenor Casino Coventry, Coventry Building Society Arena, Phoenix Way, Coventry, CV6 6GE

888poker is heading to Coventry! 

Check back for the full schedule. 

#FinalTableFreeroll Eligible Event - Click Here for Details on How You Can Win Back 100% of Your Tournament Travel Costs

    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.