0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0059 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-29' AND `url` = 'https://www.maineventtravel.com/news/article/Bag-your-room-now-for-GUKPT-London-2024' ORDER BY `views` DESC

0.0078 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-29' AND `url` = 'https://www.maineventtravel.com/news/article/Bag-your-room-now-for-GUKPT-London-2024'

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.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.0004 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.0066 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.0037 SECONDS:
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as article_count, MAX(news_articles.date) as recent_date FROM `news_categories` JOIN `news_article_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` JOIN `news_articles` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` GROUP BY `news_categories`.`id`

0.0079 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '11' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0008 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.0043 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '16' AND `news_articles`.`active` = 1 ORDER BY `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.0032 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '18' AND `news_articles`.`active` = 1 ORDER BY `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.0006 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.0037 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '19' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0009 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.0051 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '22' AND `news_articles`.`active` = 1 ORDER BY `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.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.0037 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '23' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0130 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.0006 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.0041 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '27' AND `news_articles`.`active` = 1 ORDER BY `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.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.0036 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '28' AND `news_articles`.`active` = 1 ORDER BY `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.0032 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '29' AND `news_articles`.`active` = 1 ORDER BY `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.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.0066 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '30' AND `news_articles`.`active` = 1 ORDER BY `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.0058 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '31' AND `news_articles`.`active` = 1 ORDER BY `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.0017 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 `url_name` = 'Bag-your-room-now-for-GUKPT-London-2024'

0.0008 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 `date` <= '2024-04-29' AND `news_articles`.`active` = '1' ORDER BY `DATE` DESC, `id` DESC LIMIT 5

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.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.0002 SECONDS:
SELECT `news_categories`.* FROM `news_article_categories` LEFT JOIN `news_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` WHERE `news_article_categories`.`news_article_id` = '921'

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%article%'

English
Friday 15th December, 2023

Bag your room now for GUKPT London 2024!

By Mad Harper

Barely has the dust settled on GUKPT 2023 then it’s time to start planning for the first event of 2024! GUKPT London is taking place at its traditional home – the iconic Poker Room at the Grosvenor Victoria Casino – and will feature a total of 11 different live tournaments from January 4 to 14.

The £1,250 Main Event starts January 11 with other schedule highlights including the Mini Main, the new Super Mystery Bounty NLH 50/50 (with four starting flights) and Super Mystery Bounty PLO 50/50, a PLO 4/5/6 tourney, the £2k High Roller and the £550 GUKPT Cup. 

2024 National Poker League

GUKPT London will be the first qualifying event in the 2024 National Poker League. Players will have dozens of opportunities next year to garner NPL points and it’s certainly a prize worth aiming for – Grosvenor has bumped up the value of the 2024 Player of the Year prize to a £75,000 sponsorship package. Players can accrue points at all GUKPTs, the UK Poker Open in February and Goliath in July, the brand new 888poker LIVE UK Poker League and all the 25/50 series.

MainEventTravel is proud to be continuing its long relationship with Grosvenor next year as the casino’s Official Travel Partner for live events. So whether you’re playing the full GUKPT London festival or just the £1,250 buy-in Main Event, check out some of our recommendations below. 

GUKPT London will also be the first event to be featured in the 2024 edition of MainEventTravel’s amazing #FinalTableFreeroll promotion, giving you the chance to win 100% of your travel costs back in travel credits – check out the details of this no additional cost to enter promotion here.

Hilton Metropole – from £169/night*
The Hilton Metropole is a top choice for any event at the Vic – it’s super-convenient, comfortable, and represents great value.
There’s free Wi-Fi, a large gym, three restaurants, and the Bow Bar is open until 1am. Most importantly, the hotel is crawling distance of the Vic and enjoys great transport connections all over London. 

Marble Arch Inn Hotel – from £123/night*

Just six minutes’ toddle from the Vic is the modern and recently refurbished Marble Arch Inn. You can find full details by ticking our Pay Hotel option on the event page. There’s free Wi-Fi, 24/7 reception, and all rooms feature flatscreen TV, hairdryer, and tea- and coffee-making facilities. Most rooms also have en-suite shower facilities. Pay in advance (non-refundable) and you can save around £10/day on the standard rate. 

London Marriott – from £209/night*

If you want to stay TWO MINUTES from the Vic, then the 4* London Marriott could be the hotel for you. This stylish and contemporary property is certainly a notch up in terms of luxury as well. Every room has sumptuous cotton bedding, a TV with Apple TV technology, a large desk, a fridge and a laptop safe. There’s free Wi-Fi access in public areas and the top-floor Executive Lounge. Onsite, the Pickled Hen is a modern gastropub serving traditional British food and drinks. Come on – it’s GUKPT London – treat yourself!!

The Landmark London – from £432/night*

If money’s no object, then you’d be nuts not to stay at the Landmark! The Landmark has been wowing guests since it first opened in 1899 and the dramatic entrance is now complemented by a vast, eight-story glass-roofed atrium replete with towering palm trees.  It’s a ten-minute walk to the Vic and close to Regents Park. The guest rooms have everything you’d expect from a 5* hotel and there’s also a sumptuous spa with a steam room, sauna, swimming pool, and fully-equipped gym. 

OYO Boston Court Hotel - from £81/night or £43/night/per person for 4 sharing*
Located only six minutes’ walk from the Vic – and just two minutes' walk from Marble Arch, Hyde Park, and Oxford Street – the budget-friendly OYO Boston Court is ideally situated for GUKPT London. It’s a basic but friendly, family-run hotel housed in a restored English Heritage-listed Victorian property on Upper Berkeley Street. All rooms feature satellite TV, a fridge, a hairdryer, a fan and tea- and coffee-making facilities. If you don’t mind bunking up with mates, then book now to grab one of the hotel’s available “quad” rooms. These allow four people to share bringing the cost down to around £43/night* per person – amazing value for such a central London location.  

MainEventTravel.com is the Official Travel Partner of Grosvenor Poker and the GUKPT. Head to MET’s GUKPT London event page to see all these great rates!

Days Inn Hyde Park - from £150/night*

Located in a quiet elegant Georgian terrace close to Paddington station, the 55-room Days Inn Hyde Park has a 24-hour front desk and free Wi-Fi. Most London hotels don’t have onsite parking, but you can ditch your car at the Days Inn for £20/day. Located just 12 minutes from the Vic, this is a nice and comfy option for your GUKPT London stay. Using the “Pay Hotel” option, you can snag a room here for just £150/night* for a ten-night stay. A generous continental breakfast buffet is served daily in the spacious dining room and the cosy lounge bar offers a range of beverages and light snacks. The Days Inn is an affordable option for players and, in some rooms, sharers can both get a double bed. Check-in from 2pm, check out at 11am.

*Rates are correct at the time of publication but may fluctuate due to demand 

GUKPT 2024 season
Grosvenor has already announced the dates for all next year’s GUKPT stops – ten in total. After Leg 1 in London, the tour will be off to GUKPT Manchester in February. Following that, it’s Blackpool in March, Leeds from April 4 to 14 and Luton starting April 25, London in May, then Edinburgh in June, a second trip to Luton in September, Blackpool #2 in October, and then back to London for the Grand Final.  Not to mention the return of the Grosvenor UK Poker Open event starting February 22 in Coventry. Another of Grosvenor Poker’s biggest events, Goliath takes place in July. That’s a lot going on – but luckily you can start your planning now with MainEventTravel.com!

 #FinalTableFreeroll promotion

Don’t forget to tag @MainEventTravel and #FinalTableFreeroll when you book with MET, giving you the chance to win back up to 100% of your travel costs.

 Photo Credit - Grosvenor Poker

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.