0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0135 SECONDS:
SELECT `views` FROM `page_views` WHERE `date` = '2024-02-23' AND `url` = 'https://www.maineventtravel.com/tour/888poker-uk-poker-league' LIMIT 1

0.0018 SECONDS:
INSERT INTO `page_views` (`url`, `date`, `views`) VALUES ('https://www.maineventtravel.com/tour/888poker-uk-poker-league', '2024-02-23', 1)

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

0.0116 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.0006 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-uk-poker-league'

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = '888poker-uk-poker-league'

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `id` = '174'

0.0021 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` = '174' ORDER BY `tour_stops`.`start_date` ASC

0.0186 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.0008 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.0005 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

888poker UK Poker League


UKPL by 888poker is an exclusive new poker league that’s set to take the UK by storm with exciting live events in various Grosvenor Casinos across the country!

Whether you’re based in the North, South, East or West, you’ll find a UKPL event to join. Incredible prizes await the top 10 UKPL winners, and all points accumulated will count towards your position in the National Poker League as well.

The UKPL will be heading to Coventry, Edinburgh, Luton, Manchester, Leeds and London, with the Grand Final event taking us back to where it all kicked off – Coventry.

Upcoming Tour Stops

Tuesday 5th - Sunday 10th March, 2024

UKPL Luton

Grosvenor Casino Luton, 35 Park Street West, Luton, LU1 3BE

UKPL will be visiting Luton. The tour is set to take the UK by storm with exciting live events in various Grosvenor casinos across the country!

The Buy in fee is £500 + £60. Check out all the details and the schedule. 

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

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 16th - Sunday 21st April, 2024

UKPL Manchester

Grosvenor Casino Manchester, Bury New Road, 2 Ramsgate Street, Manchester, M8 9SG

UKPL will be visiting Manchester. The tour is set to take the UK by storm with exciting live events in various Grosvenor casinos across the country!

The Buy in fee is £500 + £60. Check out all the details and the schedule. 

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

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 27th August - Sunday 1st September, 2024

UKPL Leeds

Grosvenor Casino Leeds Westgate, Wellington Bridge Street, Leeds, LS3 1LW

UKPL will be visiting Leeds. The tour is set to take the UK by storm with exciting live events in various Grosvenor casinos across the country!

The Buy in fee is £500 + £60. Check out all the details and the schedule. 

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

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 24th - Sunday 29th September, 2024

UKPL London

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

UKPL will be visiting London. The tour is set to take the UK by storm with exciting live events in various Grosvenor casinos across the country!

The Buy in fee is £500 + £60. Check out all the details and the 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

UKPL Coventry Grand Finale

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

UKPL will host their Grand Finale where the league started, in Coventry! The tour is set to take the UK by storm with exciting live events in various Grosvenor casinos across the country!

The Buy in fee is £500 + £60. Check out all the details and the schedule. 

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

    Find Hotels, Flights & More       View Complete 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.