0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0058 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-05-19' AND `url` = 'https://www.maineventtravel.com/tour/gukpt-grosvenor' ORDER BY `views` DESC

0.0083 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-05-19' AND `url` = 'https://www.maineventtravel.com/tour/gukpt-grosvenor'

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.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.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.0113 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.0007 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.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` = 'page'

0.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'gukpt-grosvenor'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'gukpt-grosvenor'

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

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

0.0109 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.0005 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

GUKPT Grosvenor


GUKPT is one of the UK's leading Poker events, with recreational and professional players alike following the tour around the country each year due to the fantastic structure and massive fields.

The GUKPT is part of the Grosvenor 2024 NPL (National Poker League) offering players an opportunity to win prizes including packages valued at £5k, £10k, £15k, £20k, and a whopping £40,000 Package, as well as tickets to play in future NPL events,

Simply play any NPL qualifying event, such as a GUKPT, 25/50, or Deepstack, collect points, and climb the leaderboard – the higher you finish the bigger the prize! 

Payouts may change based on the amount collected, see Grosvenor Poker National Poker League  for full details.

MainEventTravel.com is the Official Travel Partner of Grosvenor Poker and the GUKPT

Upcoming Tour Stops

Thursday 16th - Sunday 26th May, 2024

GUKPT London - Leg 6

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

GUKPT London features a £1100 + £150 Main Event

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

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 30th May - Sunday 9th June, 2024

GUKPT Leeds - Leg 7

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

GUKPT Leeds features a £900 + £100 Main Event.

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

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 12th - Sunday 22nd September, 2024

GUKPT Luton - Leg 8

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

GUKPT Luton features a £1100 + £150 Main Event

#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  

Wednesday 30th October - Sunday 10th November, 2024

GUKPT Blackpool - Leg 9

Grosvenor Casino Blackpool, The Sandcastle, Promenade, Blackpool, FY4 1BB

GUKPT Blackpool features a £1100 + £150 Main Event. 

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

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 21st November - Sunday 1st December, 2024

GUKPT London Luton: The Grand Final - Leg 10

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

GUKPT features a £1800 + £200 Main Event.

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

    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.