0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0101 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-24' AND `url` = 'https://www.maineventtravel.com/news/article/Get-the-Hotel-Lowdown-for-GUKPT-Blackpool-10th-17th-March' ORDER BY `views` DESC

0.0364 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-24' AND `url` = 'https://www.maineventtravel.com/news/article/Get-the-Hotel-Lowdown-for-GUKPT-Blackpool-10th-17th-March'

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

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

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

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

0.0221 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.0109 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.0150 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.0073 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.0431 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.0014 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.0094 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.0014 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.0162 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.0013 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.0169 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.0014 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.0111 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.0014 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.0013 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.0205 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.0014 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.0071 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.0013 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.0067 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.0013 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.0056 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.0013 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.0150 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.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.0082 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.0014 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.0028 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` = 'Get-the-Hotel-Lowdown-for-GUKPT-Blackpool-10th-17th-March'

0.0013 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-24' AND `news_articles`.`active` = '1' ORDER BY `DATE` DESC, `id` DESC LIMIT 5

0.0013 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.0003 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` = '966'

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

English
Tuesday 20th February, 2024

Get the Hotel Lowdown for GUKPT Blackpool 10th - 17th March

By Mad Harper

There are just a couple of weeks before the GUKPT kicks off in the popular Lancashire seaside resort of Blackpool. 

GUKPT Blackpool is running from March 10 - 17 with a feast of poker action on offer. In addition to the £1,250 GUKPT Blackpool Main Event, which gets underway on March 14, schedule highlights include a £250 PLO 4 Card, £250 Mini Main, £1650 High Roller and £550 GUKPT Cup.

Blackpool is a busy tourist destination so we strongly recommend players bag their rooms now to ensure they stay exactly where they want.

For many GUKPT enthusiasts, GUKPT Blackpool is their favourite event of the year. It’s also one of 100s of events featured in MainEventTravel’s amazing #FinalTableFreeroll promotion giving you the chance to win back 100% of your Tournament Travel booked with MET.

Below you’ll find details for six local hotels that we’re recommending to GUKPT Blackpool  players. They’re all comfy and conveniently located with easy access to both Grosvenor Casino Blackpool and Blackpool’s myriad seafront attractions.

Come enjoy the poker, pier, promenade and famous Blackpool attractions!

Travelodge Blackpool South Promenade
This is a great player option and very popular amongst GUKPT Blackpool regulars. Located just around the corner from Grosvenor Casino Blackpool, the Travelodge Blackpool South Promenade (pictured below) is comfy, convenient and clean while the staff have a great reputation for being welcoming, helpful and friendly. As Grosvenor Ambassador Katie Swift said: “It’s extremely convenient and usually a great price. Definitely an ideal location for the GUKPT.” All standard double rooms feature a comfy king-size bed with four plump pillows and a cosy duvet. There is an on-site restaurant and the bar serves hot breakfast and tasty evening meals. There are a few parking spaces on-site at £8/day on a first come, first served basis but if you miss out on hotel parking, alternative spaces are available at the large South Car Park on nearby Yeadon Way at £12/day.

OYO Chesterton Hotel
The 2* Chesterton (pictured below) is one of several hotels near the venue bearing the OYO brand. It’s a cheap and cheerful option and just 12 minutes’ walk from the
Grosvenor Casino Blackpool venue. Located in Blackpool town centre north of the South Pier, Oyo Chesterton Hotel Blackpool has free WiFi in public areas. The rooms are small but all feature a wardrobe, free toiletries in the bathroom, 32-inch flat-screen TV and electric kettle.

Hampton by Hilton Blackpool
The 3* Hampton by Hilton Blackpool hotel (pictured below) is a smart and modern property located on the new South Promenade in a prime seafront location. The hotel is within 15 minutes walking distance of the casino as well as other Blackpool amenities and attractions. Both Continental and hot breakfast (Full English/Irish) are available and the bar/lounge area is open 24/7 with a selection of food and beverages including Starbucks. All rooms feature a 40-inch HDTV, free WiFi, kettle, spacious bathroom (with shower), hairdryer and comfy bed. There’s also an on-site gym so you can keep up your fitness routine!

Travelodge Blackpool South Shore
The South Shore Travelodge (pictured below) is another popular and affordable player option. Located just 20 minutes’ walk from Grosvenor Casino Blackpool, the Travelodge Blackpool South Shore is comfy and convenient. All standard double rooms feature a comfy king-size bed with four plump pillows and a cosy duvet plus tea- and coffee-making facilities, freeview TV, ensuite bathroom with shower, black-out curtains, desk area and armchair. There is an on-site restaurant and the bar serves hot breakfast and tasty evening meals.

Village Hotel Blackpool

The Village Hotel Blackpool (pictured below) is a great choice for players who don’t want to spend ALL their time at the tables. Staying here turns your GUKPT Blackpool sojourn into a real holiday and comes recommended by Grosvenor Ambassador Katie Swift. Set in 230 acres of parkland and lakes, Village Hotel Blackpool has a championship golf course, gym, an outdoor heated swimming pool and a 21-metre indoor pool. Katie said: “The Village Hotel is only a short drive from the venue and is a higher end option if you want to combine poker with a nice spa break! It has a lovely swimming pool, a gym and clean, comfortable rooms.” The Grosvenor Casino Blackpool venue is just a 12-minute drive away. Each room at the hotel includes free WiFi and a flat-screen TV and all 175 rooms have been given a fresh and modern makeover this year. Guests can dine at the stylish all-day-dining Village Pub and Grill and there is also an on-site Starbucks coffee house serving a range of beverages.

Imperial Hotel Blackpool
The Imperial Hotel Blackpool (pictured below) is a 4*, Grade II listed luxury property enjoying a great location. Situated on the North Promenade, it boasts spectacular views of Blackpool seafront and is close to a host of shopping opportunities, dining options and entertainment venues. This iconic hotel, which first opened in 1867, is known for its charm and elegance with elegantly-appointed guest rooms featuring soft duvets, crisp, clean linen, ensuite bathrooms, flat-screen TV, free Wi-Fi and refreshment facilities. Full English breakfast is included while fine dining takes place in the hotel’s famous Palm Court Restaurant. More informal catering is available at the historic No. 10 bar where you can enjoy traditional Blackpool fish and chips and light bites such as sandwiches and salads. A terrace at the front of the hotel with views over the Irish Sea is the perfect spot for a cocktail or glass of wine at sundown. Parking is available at £9/day and it’s a 14-minute drive to the
Grosvenor Casino
Blackpool venue.

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.